Types of data generation processes
Simple data generation
In the simplest type of data generation, Tonic Structural uses the configured table modes and generators to transform data in the source database and write the transformed data to the destination location. The destination location is usually a database server, but might also be:
A storage location such as an S3 bucket
A container repository
A Tonic Ephemeral snapshot
Subsetting data generation
Upsert data generation
Required license: Professional or Enterprise
After the initial data generation, Structural runs an upsert job to add or update the appropriate records from the intermediate database to the destination database. The upsert job only adds and updates records. It does not remove any records from previous data generation jobs.
Before Structural can run an upsert job, the destination database must already exist and have the correct schema defined. To initialize the destination database:
Disable upsert.
Run a regular data generation.
Re-enable upsert.
Last updated