TurboData either obtains the database schema definition directly from the source database, or the database schema may be entered manually into TurboData. CA Gen users can use the optional Data Composer™ component to read the database definition from the CA Gen model. The information in the database schema such as data type, length, and foreign key details are used to create suites of test data.
How does this differ from other Test Data creation methods?
There are various other different ways to create test data:
- Manually creating SQL test scripts or files to be loaded into the database
- Entering data via online transactions
- Writing batch programs to create high volumes of data
These methods are all time consuming, difficult to maintain and very error prone. Mistakes are commonly made with the referential integrity. Errors in the test data often manifest themselves as program bugs, resulting in lost time by developers looking for bugs in action diagrams, when the errors are actually in the test data.
Step 1: Access the CA Gen ERD and database objects
Data Composer™ accesses the CA Gen model directly to "learn" the rules of the ERD. There are various advantages of using Data Composer™ component of Turbo Data to read in the database definition directly from the CA Gen model.
- Referential integrity defined in CA Gen that is not on the physical database is applied to generated test data.
- CA Gen entity names are displayed in TurboData with the physical table names.
- CA Gen attribute names are displayed in TurboData with the physical column names.
- Permitted Values are read in from CA Gen, and stored in TurboData as generic values. These values are automatically associated
to the appropriate column. The values may be used randomly or in ascending or descending sequence when generating test data.
Step 2: Define optional data generation rules (override values, range, frequency, user defined foreign keys etc.):
Once the Data Composer™ component has retrieved vital information about the data model then developers can use Turbo Data to provide new or override old data values for columns, to create user defined foreign keys or to specify the range of unique keys for data generation. You can easily generate parent-child or more complex dependent data!
Step 3: Generate your test data
Now test data generation can commence by the click of a button! You can generate tens of thousands, even millions of rows of test data easily!
The generated test data can be loaded into the database by executing the generated SQL via the appropriate native database SQL execution tool, or loaded by a database load facility. Delimited files can be used directly as desired.