Manage data binding

Note:

An active Katalon Studio Enterprise license.

The data binding feature allows you to bind test data files with the variables defined in the test case and dynamically run tests with the bound test data. In Katalon Studio, you can perform data binding at the test suite level and the test case level. For more details on data binding at the test case level, you can refer to Data-driven testing at test case level.

This article will focus on the components of the extended Data Binding section in a test suite.

Once you have opened your test suite, click Show Data Binding to expand the Data Binding section.

The extended Data Binding section has two tables:

Test Data: Specify here the data files for your test execution.
Variable Binding: This displays all variables of the selected test case.

Test data table

In the Test Data table, you can add one or more data files, then modify the data iteration and manage test data relationship.

Add data files

In the Test Data table, click Add to add data file(s).
In the Test Data Browser dialog, select the data files to use for variable binding. Then, click OK.

The select data files appear in the Test Data table.

Modify data iteration

An iteration is a test case execution with a test data row.

After adding data file(s) to the Test Data table, you can modify the data iteration. Double-click the cell under the Data Iteration column of each data file.


Option	Description
Run all rows	To use all the data rows in the data file in the test execution.
Run from row ... to row ...	To use the data range from a particular row to another particular row in the data file during the test execution.
Run with specific rows	To use the specific data rows in the data file during test execution. You can use comma and hyphen characters to define the rows. For example: to use three data rows (row 1, row 2, row 3), enter: 1,2,3 to use six data rows (row 1, row 2, row 3, row 4, row 5, row 9), enter: 1-5,9

Manage test data relationship

The Type column in the table represents the relationship of multiple test data sources.

The data relationship can be defined as below:


Type	Description
One	To indicate the data set as 'One' in the relationship with the other data set.
Many	To indicate the data set as 'Many' in the relationship with the other data set.

To toggle between One and Many, click the cell under the Type column of each data file.

Katalon Studio determines the relationships of data sets as follows:


Relationship	Example
One to One	Given there are two data sets as below: Then the final data set used for test execution will be: John Marketing Joe Sales
Many to Many	Given there are two data sets as below: Then the final data set used for test execution will be: John Marketing John Sales Joe Marketing Joe Sales Mary Marketing Mary Sales
One to Many	Given there are two data sets as below: Then the final data set used for test execution will be: John Marketing Joe Marketing Mary Marketing Emily Marketing John Sales Joe Sales Mary Sales Emily Sales
One to One to Many	Given there are three data sets as below: Then the final data set used for test execution will be: John Marketing Executive John Marketing Director Joe Sales Executive Joe Sales Director

Variable binding table

After adding the test case into a test suite, Katalon Studio automatically imports all test case variables. You can select each test case to view the variables in the Variable Binding table.


Column	Description
Type	Data Column: uses the data file's column header as value Data Column Index: if you set the Value as 2, Katalon Studio will use the second column of the data file as value Default: uses the default value of the test case variables Script Variable: allows you to associate the variables with other scripting value To set the variable types, click the cell under the Type column of each variable, then click Set Type.
Test Data	This column is enabled if you set Type as Data Column or Data Column Index. To choose the test data file, double-click the cell under Test Data column of each variable.
Value	Here you choose the according column header of the data file for each variable. If the variables and column headers of the data files share the same name, you can click Map All to quickly map them together. During execution, the username variable looks for the `username` column, and the password variable looks for the `password` column of the valid-accounts data file.