Data driven testing

Run test against multiple scenarios

The data driven testing feature allows you to run a single test against multiple scenarios using different test data combinations. This is achieved by creating and utilizing test datasets.

Examples:

1. Testing a login form with various usernames and passwords to verify authentication.
2. Testing a search feature with diverse keywords to validate results and handling of invalid inputs.
3. Testing a registration form with varying user inputs to ensure data validation and acceptance criteria.
4. Testing a shopping cart with different product combinations and quantities to assess calculations and error handling.
5. Testing a checkout process with diverse payment methods and shipping addresses to verify functionality and edge cases.

Create test dataset

You can create a test dataset in one of two ways:

• Upload a CSV file
• Connect to your database

Choose the option that best aligns with your workflow and data requirements.

Upload a CSV file

1. Click Test dataset from the desktop app or web page.
2. Click Add Test Dataset to upload a csv file.
3. Select a CSV file containing your test dataset.
4. Ensure the file meets the following requirements:
   • CSV format
   • Consistent number of columns in each row
   • Values not exceeding 1000 characters
   • Maximum of 100 rows and 40 columns
   • At least one row of data in addition to the header row
5. Give the dataset a unique name.

Connect to your database

You can create test datasets directly from your database connection allowing you to execute tests with dynamic data combinations.

To create a test dataset from a database:

1. Click Test dataset on the left pane.
2. Click + Add Test Dataset and select Create from database.
3. Select a database connection from the list and click + Connect.
4. Alternatively, you can click + Add new connection to configure a new one. You can also create new connections from the Database section of the Low Code Automation. For more information, refer to the Run database query document.
5. Enter your SQL query to fetch the required test data. Click Run Query to preview the query results.
6. The query results display in a table. Enter a unique name and description for your dataset, then click Save dataset.

Run data-driven tests using real-time data from your database to ensure your test scenarios are always up to date.

Review the test dataset

Once the dataset is created successfully, you can verify the data by looking at the data table.

Click the Refresh icon to update the dataset with the latest data from your database.

To view additional information about the query, click Query details.

Optionally map a scenario name column

• Once a test dataset is created successfully, you can map any column from the dataset as scenario column
• It is used in build report and other places as a label to represent the particular row
• We recommend using the Map a scenario name column to a unique identifier or any column that uniquely identifies each row in your dataset.

Using test dataset in tests

You can import any column from the dataset, similar to importing variables.

1. Within a test, navigate to the step details.
2. Click the + button and choose Import a value from test data.
3. Select or link a dataset from the list. If you do not have any dataset created, you can create a new test dataset here by uploading a CSV file.
4. Choose the column you want to use from all the columns in the test dataset that you chose in previous step.

Test execution with test dataset

Local execution

Local replay automatically uses the first row (excluding the header) from the dataset.

Cloud execution

• Run the test against each row of data in the test dataset.
• Build reports list each execution individually.
• Multiple executions of a test are grouped in the report. Observe the highlighted text, which represents the scenario column data previously mapped to the test.
• For datasets sourced from a database, the query executes at the start of the build to fetch the latest data for execution.