You use the ODBC memory feature
Memory definitions specify the data, generated by a task at run-time, to be memorised. You can save memorised data in an internal Repository, in an ODBC or OLEDB data source, or in an OLEDB data source via a stored procedure. to create a definition that memorises data for a selected table, columns, or both, from a specified ODBC data source at task run-time. Instead of mapping the data into a Repository, the data is written back into the applicable table.
The ODBC data source can be located within the same network or domain as the BPA Platform Server, or for partner-hosted instances of BPA Platform where the server has no direct connectivity to the customer's external network by using our Remote Data Relay as part of the connection configuration.
Features include:
| ► | Memorise data using an |
| ► | Free-type and graphical generation of SQL Statements |
| ► | Transaction support |
| ► | Memorise based on rules created in VBScript |
Global Configuration
In order to be able to create a new ODBC memory definition Memory definitions specify the data, generated by a task at run-time, to be memorised. You can save memorised data in an internal Repository, in an ODBC or OLEDB data source, or in an OLEDB data source via a stored procedure., a connection to an ODBC compliant data source must be available — see Adding ODBC Connections.
In addition, you must also have permission to use the memory definition feature — see Memory Access tab.