Follow-On Topics

Related Topics

# About ODBC Memory

The ODBC memory provider allows a user to create a memory 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 upon VBScript rules

## Global Configuration

In order to be able to create a new ODBC memory definition, a connection to an ODBC compliant data source must be available or selection or configured through the ODBC Connections dialog box.

In addition, the user must also have permission to use the memory definition. This is configured in the Memory Access tab of the User Properties dialog box.

Any number of connections can be made and access to each one may be controlled through a user name and password if required.

## Dialog

The ODBC Memory dialog box is displayed when the Add button is selected in the Memory Definitions dialog box and the ODBC Memory option is selected in the Please select a Memory Provider dialog box. Alternatively it may be displayed by selecting an existing ODBC Memory definition in the Memory Definitions dialog box and selecting the Edit button.

The dialog box contains the following two tabbed panes which are used to configure an ODBC Memory Definition:

|  | Memory

|  | Options

Copyright © 2018 Quadrant Software B.V. All rights reserved.