When you want to create test data for one of your databases with TDG 2.0,
you start this by creating a new collection within TDG 2.0.
The new Collection Creation Wizard of TDG 2.0 accompanies you through the creation process of your new collection, asks you for all necessary information and offers you the appropriate selections to choose.
Todays SQL based DBMS are of different internal structure. They differ also in what they call Catalog and Schema.
Some use one of them, others the other. Some use both while still others use none.
To harmonize all these differences, TDG 2.0 offers a dialog that lets you make the proper selections regarding to this particular database.
After selecting the appropriate items, TDG 2.0 is going to start the scan process of your database.
During this scan, TDG 2.0 reads all the necessary catalog data, such as table and column names, columns data types, primary and foreign keys etc. from your database and stores it internally.
So TDG 2.0 contains all this database information and can therefore use them for all of the following operations. No further database access is required unless you want to insert your test data into this database.
When the scan has been finished, TDG 2.0 shows all the tables of your database in their order of dependency.
So TDG 2.0 is able to comply with the referential integrity of the database while inserting test data.
With this operation the groundwork is done and you got a representation of your database within TDG 2.0
for further usage.