Data Files in Katalon Studio
Katalon studio data files provides a rich feature that allows us to store or fetch data easily from these sources.This could be internal data files , external data files or databases.
Data used in test cases in the form of variables or input are usually obtained from files that can be excel files, CSV files, profiles or Databases.Read data from excel in katalon studio using it.
Katalon Studio provides the ability to execute automation tests with external data sources which can be used by configuring the test suite with external files.This process is called Data Binding.
In this article we will discuss below topics:
- How to read data from excel file in Katalon Studio.
- How to read data from external CSV file in Katalon Studio.
- How to read data from internal file in Katalon Studio
- How to read data from Database in Katalon Studio
How to read data from excel file in Katalon Studio
Input data is usually maintained in files and then accessed in automation projects. Excel files are most frequently used for this. In Katalon below steps are followed to create excel data .
- In Test Explorer, select Data Files → New → Test Data.
2. Dialog box Test Data opens. Â Select Excel File and click on OK.
3. File’s Information section options. Click on Browse button and select the external excel file that you have created to store input data. Select the sheet name from which data needs to be fetched from the Sheet Name drop down
4. Save the Test Data created. We will see in the upcoming topics how this data is utilized in our automation test cases.
How to read from CSV file in Katalon Studio
Input data is usually maintained in files and then accessed in automation projects. CSV files are frequently used for this. In Katalon below steps are followed to create excel data .
-
- In Test Explorer, select Data Files → New → Test Data.
2. Dialog box Test Data opens. Â Select CSV File and click on OK.
3. File’s Information section options. Click on Browse button and select the external CSV file that you have created to store input data. Select the separator based on which data needs to be segregated
4. Save the Test Data created. We will see in the upcoming topics how this data is utilised in our automation test cases.
How to read data from Internal file in Katalon Studio
Input data is usually maintained in files and then accessed in automation projects. In Katalon below steps are followed to create Internal data .
- In Test Explorer, select Data Files → New → Test Data.
2. Dialog box Test Data opens. Â Select Internal Data and click on OK.
3. Add columns and rows by clicking on + sign
4. Save the Test Data created. We will see in the upcoming topics how this data is utilised in our automation test cases.
How to read data from database in Katalon Studio
There are cases when data is required from the Database. Based on some input query data needs to be fetched and then utilised in the test case. Best way to achieve this in Katalon is using Database data.
1. It In Test Explorer, select Data Files → New → Test Data.
2. Dialog box Test Data opens.  Select Database Data  and click on OK.
3. Database data test data created above opens. Click on the Edit Query option here.
4. Database Connection and Query Settings dialog box opens. Enter the database connection details and the query that needs to be executed. Click OK.
5. Save the Test Data created. We will see in the upcoming topics how this data is utilised in our automation test cases.
   Recommended Articles
About Author
Nitesh is working as a Quality Analyst with more than 10 years of comprehensive experience in test automation, performance testing , DevOps etc .He likes to share his wealth of knowledge across software test Process