You use the ODBC memory featureClosedMemory 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.

Features include:

Memorise data using an ODBC compliant data source
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 definitionClosedMemory 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.