Manage Test Data

Estimated reading time: 4 minutes

Starting from Katalon Studio version 6.3.0, you can configure variable binding to read test data values as the intended data types. Refer to this document for an example of Variable binding for Test Data with option bind into test case as string enabled/disabled.

Create an Excel Test Data

  1. Select File > New > Test Data from the main menu. The New Test Data dialog is displayed. Enter the name for your test data and select Data Type as Excel File. Click OK.

  2. Browse to the Excel file that you want to import into Katalon Studio.

  3. Data from the selected Excel file is populated into the preview section below.

  4. Save the Test Data when you finish. The data set defined here can be utilized in other configurations. For example, you can use it to input data for keywords in Manual View or data for Test Execution when setting up test suites.

Create a CSV Test Data

  1. Select File > New > Test Data from the main menu. The New Test Data dialog is displayed. Enter the name for your test data and select Data Type as CSV File. Click OK.

  2. Browse to the CSV file that you want to import into Katalon Studio.

  3. Data from the selected CSV file is populated to the preview section below.

  4. Save the Test Data when you finish. The data set defined here can be utilized in other configurations. For example, you can use it to input data for keywords in Manual View or data for Test Execution when setting up test suites.

Create an Internal Test Data

With Internal Data, you can freely define the data in tabular format. It's up to you to decide how many columns, rows, and what value for each cell.

  1. Select File > New > Test Data from the main menu. The New Test Data dialog is displayed. Enter the name for your test data and select Data Type as Internal Data. Click OK.

  2. In the Editor View, select the option to add a new column.

  3. Select the option to add a new row.

  4. Finally, click on each cell to input the value for them.

  5. You can edit or delete the columns (or rows) by right-clicking to access the context menu.

  6. Save the Test Data when you finish. The data set defined here can be utilized in other configurations. For example, you can use it to input data for keywords in Manual View or data for Test Execution when setting up test suites.

Create a Database Data

With Internal Data, you can freely define the data in tabular format. It's up to you to decide how many columns, rows, and what value for each cell.

  1. Select File > New > Test Data from the main menu. The New Test Data dialog is displayed. Enter the name for your test data and select Database Data as Data Type. Click OK.

  2. Click Edit Query to open the Database Connection and Query settings dialog.

  3. Enter the connection details as well as the data query then click OK.

    Starting from Katalon Studio version 7.0.0 and later, you can query data from additional database sources with the JDBC Driver field in the dialog. You can enter the ClassDriverName of the database that has a library support connection (JDBC).

    You can check Use global database connection settings to use the connection defined in project settings. Refer to Database Settings for more details.

  4. Queried data is fetched and loaded respectively into the preview section below.

  5. Save the Test Data when you finish. The data set defined here can be utilized in other configurations. For example, you can use it to input data for keywords in Manual View or data for Test Execution when setting up test suites.

User Contributed Notes