Description

You can import one or more Domains using Data Definition Language (DDL). The Import from DDL option can import a data model as a Single Table DDL or read a DDL File to create multiple Domains within a Project. 


NOTE: This article shows how to create multiple Domains from a DDL file. Click here to learn more about creating a Domain from a Single Table DDL.


IMPORTANT: Domain relationships will not be assigned automatically with this import method. They must be manually assigned using the Domain Referencing Wizard.


In This Article


Training Video 

The following video can be viewed to learn more about creating multiple Domains from a DDL. Please note that this video is slightly dated. Up-to-date instructions are provided below after the video. 


Step 1 - Import multiple Domains from a DDL File

  • Select a Test Data Project in the Project Dashboard and navigate to the Domains Pane in the Projects Dashboard.
  • The Domains Pane will be visible when a project has been selected.


  • Open the New Domain drop-down menu and select Import from DDL.



  • Select the Import Multiple Domains from DDL option and click the Next button.




  • Select a Vendor from the drop-down menu (mysql for this example).
  • Click on Choose File to browse to and select the DDL file.


  • (Optional) Check the Enforce Type/Limit box for the import. 
    • It should be used whenever you want the generated data to be within a defined data type and size. 
    • This option will also be checked for the Generator assigned to the imported Domain Attributes when enabled. To learn more, click here.

  • Click the Save button once finished.



  • The DDL file will be placed in a queue. Please wait patiently for the DDL to be imported.
  • The user who initiated the import will receive an email when the import has started and once it is completed. 
  • Once received, the Domains have been imported into the selected Project.



  • The import will create each Domain and its Attributes. If the Enforce/Type Limit option was selected, then this option will also be checked for each assigned Generator. 




  • It will NOT automatically create relationships between Domains.
  • It will NOT automatically assign Receivers to Domains or create Scenarios.
  • These steps have to be performed manually. 


Step 2 - View the DDL Audit (Optional)

After the import, you can view a DDL audit to see if any errors occurred. The DDL import audit can be accessed from the Project Versions pane.
  • Click on the GenRocket Table Schema (GTS) Audit Details option.



  • In the DDL Audit Dialog, select a DDL import to audit and click the Next button. 
  • Only one will be visible if this is the first time a DDL has been imported.
     

  • The DDL Audit will appear, as shown below. Four Domains have been imported from the DDL file: Department, Customer, Address, and Account. 
     


    NOTE: The Import from DDL option does not support some keywords. Make sure to remove any of the following keywords before importing the DDL:
    • DEFAULT 'N'::bpchar
    • FOR SBCS DATA
    • WITHOUT TIME ZONE
    • ON UPDATE CURRENT_TIMESTAMP(N)
    • GENERATED BY DEFAULT AS IDENTITY START WITH N
    • FORMAT 'K' BETWEEN M AND N

Step 3 -Manually Define Relationships between Domains

Remember to use the Domain Referencing Wizard to manually set up Domain Relationships. It can be accessed from the Project Dashboard in the Project Versions pane (shown below). Click here to see the documentation.


Next Steps

The following tasks will need to be performed based on the desired output: 

  1. Tune Generators - Make any required changes to parameters and/or assign different Generators. Click here to learn more.

  2. Assign Receivers- This can be done for one or multiple Receivers. The required receivers will depend on the generated output type (flat files, nested files, database insertion, etc.). 
  3. Create Scenarios- A Scenario must be created for each Domain. It can be done for one Domain or multiple Domains at a time.
  4. Setup G-Cases - Allow you to generate different volumes and varieties of test data without manually altering the template Domains created during the import each time. Click here to learn more.