Prerequisites — Adding an ODBC Data Source

To use the Database Query (ODBC)Closed You 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, you must create connections to an ODBC data source first. You do this in the ODBC Connections interface. 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.

  1. Click Add to create a new connection and select the required ODBC driver or data source.
  2. Expand ODBC Drivers to see all ODBC drivers available on the client computer.

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

  3. Once a driver has been selected, add the connection details to the database. Note that the configuration interface is different for every driver available.

For more information, see Adding ODBC Connections.

Adding a Task Step

Even though the Database Query (ODBC) tool is found under two different tool categories, they do not affect the functionality of the tool.

To add a new Database Query (ODBC) step to an existing task:

  1. Open the relevant task (if creating a new task, see How to Create a Basic Task).
  2. Either:
Click and drag the Database Query (ODBC) icon from the Task Browser to the task Design area.

–OR–

From the task's Design tab, right-click on empty space and select New > then either Data Connectors > Database Query (ODBC) or Input > Database Query (ODBC).
  1. In the General tab, select the relevant data source for this task step.
  2. Go to the Query tab and configure the SQL statement.
  3. (Optional) Go to the Results tab and execute the query () to test the statement.
  4. Go to the Options tab and select the relevant error handling options for this task step.

  5. Click  to save the task step.