Specify Datasource Type Page (DB Table Variable Wizards)

Applies to TestComplete 15.40, last modified on July 05, 2022

On the Specify Datasource page, you can specify the needed type of the data storage whose current record will be used by the DB table variable.

The Specify Datasource page is part of the wizards that assist you in adding DB Table variables to your test. These wizards are: Add Variable to Keyword Test and Add Variable.

The following types are available:

  • Excel worksheet - Select this type to use an Excel worksheet as the needed data storage.

    The following pages of the wizard will help you select the needed Excel file and its worksheet. The current record of that worksheet will be stored to the DB table variable.

    Click Next to proceed to the Select Workbook page of the wizard.

  • CSV file - Select this item to use a CSV file as the needed data storage.

    The following pages of the wizard will help you select the needed CVS file (.txt or .cvs) and format parameters for it. The current record of this file will be stored to the DB table variable.

    Click Next to proceed to the Select CVS File page of the wizard.

  • Database table - Select this item to use a database table as the needed data storage.

    The following pages of the wizard will help you connect to the target database and the table whose records the DB Table variable will store.

    Click Next to proceed to Specify Database Connection Settings page of the wizard.

  • Database query - Select this item to specify a query to a database, and then use its results as the needed data storage.

    The following page of the wizard will help you connect to the target database and specify the query to retrieve the needed data from the database.

    Click Next to proceed to the Specify Database Connection Settings page of the wizard.

Choose the needed type and click Next to proceed with adding the DB table variable. Back will return you to the Add Variable to Keyword Test wizard. Cancel will close the wizard and abort adding the variable.

See Also

Add DB Table Variable Wizard
Add Variable to Keyword Test Wizard
Add Variable Wizard
Keyword Test Editor - Variables Page

Highlight search results