The G-Queries platform can be used to create a suite of Test Data Queries that can be run by GenRocket Runtime on their own with a Scenario, ScenarioChain, or ScenarioChainSet (or) added to an individual Test Data Case. The following can be queried for real data using the G-Queries platform.

  • SQL Databases
  • NoSQL Databases
  • CSV Files

Test Data Queries query a database for real data and then blend it with generated synthetic data. For example, you could query a Customer Database for each customer's first and last name and then blend that data with the following synthetically generated data values:

  • address
  • city
  • state
  • zip code
  • date of birth
  • SSN

In This Article

Self Service Test Data Portal Diagram

Sample SQL Query with Retrieved Data

select id, first_name, last_name, middle_initial,
email_address, department_id, role_id, password
from user
where department_id = 2;

Generating Test Data with Test Data Queries

Test Data Queries can be run manually by running the corresponding command line in a Command or Terminal Window. GenRocket also offers options for automating this process. Test Data Queries can be used to blend data with synthetically generated test data two ways: 

  • Run on their own with a downloaded Scenario, ScenarioChain, or ScenarioChainSet in GenRocket Runtime
  • Added to an individual Test Data Case. The query will occur when the Test Data Case is run in GenRocket Runtime

Note: For more information about configuring and using Test Data Queries, click here.