Skip to end of metadata
Go to start of metadata

Create an Excel Test Data

  1. Select File > New > Test Data from the main menu. The New Test Data dialog will be 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 will be populated into the preview section below.


  4. Save the Test Data when you're done. The data set defined here can be utilized in other configurations (e.g. input data for keywords in Test Case 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 will be 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 will be populated to the preview section below.


  4. Save the Test Data when you're done. The data set defined here can be utilized in other configurations. (e.g. input data for keywords in Test Case 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 will be 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're done. The data set defined here can be utilized in other configurations. (e.g. input data for keywords in Test Case Manual View or data for Test Execution when setting 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 will be 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 data query then click OK.

    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 will be fetched and load respectively into the preview section below.


  5. Save the Test Data when you're done. The data set defined here can be utilized in other configurations. (e.g. input data for keywords in Test Case Manual View or data for Test Execution when setting up test suites...)

 

  • No labels