To use the Database Query (ODBC)ClosedYou typically use the Database Query (ODBC) tool to extract specific records from a relational database, using a valid ODBC driver to make the connection. These are then made available to other task steps as a recordset. tool or to add an 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., you must create connections to ODBC data sources first. You open the ODBC Connections interface by either:

You open this interface from the resources tree — expand System > Tools > Data Connectors or Input, and double-click Database Query (ODBC) in the items list.

Use Properties to edit an existing connection, Remove to delete an existing connection, and Test to ensure the highlighted connection can be successfully made.

Click Add to create a new connection and select the required ODBC driver or data source.

Selecting an ODBC Driver

Expanding ODBC Drivers displays all ODBC drivers available on the client machine.

Note: Any machine hosting a BPA Platform client that runs tasks using this connection, including the BPA Platform server, must have the selected driver installed on the machine. Without the driver, the task will fail.

Once a driver has been selected, add the connection details to the database. The configuration interface is different for every driver available; the following example is shown when an SQL Server driver has been selected:

Connecting to Data Sources

Expanding Data Sources displays all data sources available on the client machine. If none are available, you must add them to the machine's ODBC data sources (Control Panel > Administrative Tools > ODBC Data Sources). For more information, refer to your Microsoft documentation.

Note: Any machine hosting a BPA Platform client that runs tasks using this connection, including the BPA Platform server, must have the selected data source installed on the machine. Without this, the task will fail.

Connecting to File Data Sources

Expanding File Data Sources displays all data sources available on the client machine. If none are available, you must add them to the machine's ODBC data sources (Control Panel > Administrative Tools > ODBC Data Sources). For more information, refer to your Microsoft documentation.

Note: Any machine hosting a BPA Platform client that runs tasks using this connection, including the BPA Platform server, must have the selected data source installed on the machine. Without this, the task will fail.