Configure subsetting

Coming soon

This feature is planned for release soon.

On the Job configuration panel, click on Switch to Subsetting -> to go to the Subsetting panel.

View subsetting configuration

On the Subsetting panel, you can view the subsetting configuration in the table overview.

• The Table name column shows all tables that are part of the source database.

• The Include column indicates whether the table will be included in the subset.

• The Row count column indicates, by estimate, how many rows will be generated for the subset.

You can quickly filter tables by selecting the dropdown icons next to the column headers.

By default, all tables are marked as Exclude, indicating they are excluded from the subsetting configuration.

You can adjust the table mode by selecting a row in the table overview.

Configure target table

Select Subsetting mode > Target to configure the table as Target table.

You can specify a percentage of the target table to include. This percentage is converted into a filter or WHERE clause depending on the database type.

It is possible that the target table in the subset contains more rows than the specified percentage in order to maintain referential integrity.

Note: To preserve referential integrity, at most one target table can be set in. When updating the targe table, all linked tables will be updated accordingly.

Configure linked tables

Once a target table has been selected, all linked tables will automatically be marked as Linked in the subsetting configuration.

Select Subsetting mode > Target | Duplicate | Exclude to change the Subsetting mode for any linked table.

Select Subsetting mode > Linked to reconfigure a table as Linked table. Note that this is only possible if a target table has been defined that is directly or indirectly related to the table.

Configure duplicated tables

Select Subsetting mode > Duplicate to copy, i.e. duplicate, the full table to the subset.

Configure excluded tables

By default, tables that are not defined as target tables, linked tables, or duplicated tables, will be automatically set to Exclude.

You cannot manually exclude a table from the subsetting configuration. If you want to exclude a table from a data generation job, you can do this using the appropriate table mode.

Launch subsetting job

When you select Generate from the Job configuration panel, Syntho performs several validation steps against the schema of the source database and the destination database.

At last, select Start generating to launch your subsetting job.