Description
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
- Generating Test Data with Test Data Queries
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
Note: For more information about configuring and using Test Data Queries, click here.