Working With Databases

Applies to TestComplete 15.47, last modified on January 20, 2023

In TestComplete tests, you can connect to databases, read data from them, and write data there. You can also create data-driven loops that will extract values from a database to DBTable variables and move to the following database record.

TestComplete uses database drivers that have the same bitness. If you use the Microsoft Open Database Connectivity Data Source Administrator tool to connect to a database, make sure the version you use has the same bitness as TestComplete. On a 64-bit operating system, you can find the 32-bit version of the tool (Odbcad32.exe) in the <Windows>\SysWOW64 folder.

Working with databases in tests

Tutorials

Using the approaches described above, you can retrieve data from the needed database (or file), store records to variables and then use these variables in your tests. For more information that illustrates working with databases via TestComplete, we recommend that you get acquainted with the following tutorials:

Data-Driven Testing With Keyword Tests - Tutorial

This tutorial will help you in creating data-driven keyword tests.

Data-Driven Testing With Scripts - Tutorial

This tutorial will help you in creating data-driven tests with the script engine.

See Also

Working With External Data Sources

Highlight search results