Create an ODBC connection to a database

To access your databases during database tests, you have to set up a corresponding ODBC data source. This topic shows you how.

Consider ODBC driver limitations

For information on supported versions, check out the system requirements.

You can use any data source that provides an ODBC driver. However, this means that Tosca Cloud is limited to what these drivers support. What exactly ODBC drivers support varies between database vendors.

For example, if you work with ODBC drivers for Oracle, you might experience the following limitations:

  • Oracle ODBC drivers can't interpret PL/SQL commands and, therefore, don't support them.

  • Oracle ODBC drivers don't support more than one SQL statement in one call.

Create an ODBC connection on the agent machine

To create an ODBC connection, follow these steps:

  1. Open the ODBC Data Source Administrator on Windows via Control Panel->Administrative Tools->ODBC Data Sources.

    If you want to establish a 32-bit data source on a 64-bit system, the application odbcad32.exe must be started from the directory C:\Windows\SysWOW64.

  2. In the ODBC Data Source Administrator, go to the System DSN tab.

  3. Select Add. Then, select the right driver for your database type. For example, if you use a Microsoft Access database, select the driver Microsoft Access Driver (*.mdb, *.accdb).

  4. Select Finish.

  5. In the subsequent dialog, set up your database driver and select the database.

  6. Select OK.

What's next

Now that you have your ODBC connection, you can start creating database test cases.