Creating a Local Data Repository in a Test Case

A Local Data Repository (LDR) is akin to a spreadsheet that contains various data sets, allowing you to run iterations of specific test steps with different data values within a test case. 

For instance, consider a scenario where you're testing a sign-up feature of a website. The LDR can hold different datasets such as varying email addresses, passwords, and user details, enabling the test case to simulate sign-up attempts with diverse input combinations.

This repository provides flexibility through features like adding new datasets, modifying rows or columns, and importing/exporting data from Excel. When you integrate a local data repository into a test case, the associated test step(s) iterate based on the corresponding DataRow in the LDR.

Let's understand how to create a Local Data Repository in Opkey:

1. Hover over the Automate section and click Test. Open the test case where you want to create and use your local data repository.

2. In a test case, by default, Global Data Repository mode is selected. Click on the dropdown present on the automated test case to change the mode of the data to Local Data Repository.

3. In the icon next to the dropdown, you can create Local Data Repository. 

A new page opens up on the right pane where you get the option of adding a new datasheet.

4. A new datasheet is added. Click on the icon to open the datasheet.

 Open the datasheet and click Enable Editing option to unlock the datasheet.

5. The number of columns in the Local Data Repository is equal to the number of test steps in the Test Case. 

6. You can add either a single or multiple Datasets divided into rows and columns in your LDR. The number of datasets in the Local Data Repository defines the number of iterations a step will go through.

7. After entering the relevant data in the LDR, click the Save button at the top to save the inputs.

8. Click on the Run button to execute the test case. 

Select Local Run on the pop-up window.

9. The Run Wizard will open up on the right pane. Enter details like Run Name and Milestone and select the browser.

10. Under ‘Advance Setting’, select the build, agent, and plugin. Click Start Run.

11. Once the execution is complete, you can view the result by clicking on View Result. 

12. During the execution, the data gets picked up from the datasheet. On clicking the ‘View Result’ button, you can view the details of the executed test case.

You've reached the end of this article and are now well-prepared to create an LDR in a test case. 

Ready to dive deeper? Check out the next article: Creating a SOAP API Service Repository.

Explore, experiment, and achieve your testing goals on Opkey!

To get into more detail about Opkey's Local Data Repository you can visit and enroll in our Opkey series course


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article