Creating a Global Data Repository and Mapping with Test Case

Test data plays a vital role in test automation. There are testing scenarios that need different datasets to be used across multiple test cases for successful application testing. For such cases, Opkey provides a user-friendly data storage and management feature called Global Data Repository (GDR).

GDR contains a spreadsheet divided into several rows and columns where data can be added. The different datasets of a GDR can be used to iterate the entire test case.

GDR offers flexibility to users by enabling them to add and delete rows/columns, move rows/columns, copy and paste data, and export or import Excel data. GDR can be accessed inside a project/test case by all the users with access to that project. 

Creating a Global Data Repository

1. Hover over the Automate section in the left panel and select the Test Data tab to create a DataSheet as shown below. 

2. Click the Create Datasheet button. A new Create Data window opens up on the right. In this window, add a name, choose priority, assign a user, add a description, and click Create. You can also upload attachments such as videos, images, spreadsheets, etc.

3. Your empty data sheet will be created. Now, you can start adding data to its rows and columns.


4. After the sheet opens, the toolbar at the top has various buttons to perform different actions on the GDR file. 


  Getting Familiar with Global Data Repository buttons



5. You can double-click on a cell and enter your data. Right-clicking a cell allows you to perform actions such as Copy, Paste, Add Row, Delete Row, Move Row Up, and Move Row Down. 

6. You can also right-click on any column to perform actions like Add Column, Delete Column, Move Column Left, Move Column Right, Rename Column, and Encrypt Column using the encryption password.

7. After adding the data, click the Save button at the top to save the GDR.

Mapping GDR Values in a Test Case

1. Ensure that the datasheet mode of your test case is Global Data Repository in the right pane.

2. Link the input data of test steps from GDR by clicking on the three dots icon on the test step and selecting ‘Set Input Data’.

3. In the Edit data of the Step panel, click on the Data Drive icon as shown below.

 4. In the new screen, select the datasheet type.

5. After selecting the datasheet type, select the linking icon and chose the GDR you have created by clicking on it. 

6. Your data sheet will be opened in the same window. Select the column whose values you want to map in the input and click on the linking icon as shown below. 

7. Once the data is mapped a message will be displayed as seen in the below screenshot.

8. Now, you can close the window and click the Run button to execute the test with the new data mapped from the new GDR. 


You've reached the end of this article and are now well-prepared to create, encrypt, and call a GDR in your test case.

Ready to dive deeper? Check out the next article: Creating a Local Data Repository.

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

To learn more about how data repositories work, you can visit Opkey LMS 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