Description
GenRocket needs to understand your data model to generate your test data. From our experience, every team has a different level of access to their data model (i.e., direct access to the database, access to flat files, etc.).
We offer sixteen primary methods that can be used to import or manually create your data model. While you can manually create each Domain and Attribute necessary to define your data model, our import options make this process faster and easier when thousands of tables must be added to a Project.
Sixteen Ways to Import Your Data Model
There are sixteen primary ways you can import your data model into GenRocket:
| Method | Description |
| DDL File Import | The Import from DDL option can be used to import your data model as a single or multiple data definition language (DDL) into a Project. A Single Table DDL can be used to create a single Domain by pasting a single table DDL. To learn more about this method, please view this help article. A DDL File can be read to create multiple Domains within a Project. To learn more about this method, please view this help article. |
| GenRocket Extract Table Schema (XTS) | The Import from XTS option can be used to create Domains and Attributes by importing a GenRocket Table Schema file into the selected Project. These files can be created by using the -xts command. To learn more about this method, please view this help article. |
| CSV Import | The Import from CSV option can be used to create Domains and Attributes by importing a CSV file into a selected Project. To learn more about this method, please view this help article. |
| CSV Import for Fixed File | The Import from CSV for Fixed File option allows you to import a CSV file of a defined format to generate a fixed file. The file must contain specific information (Domain Name, Data Type, Size, etc.). The user chooses the file delimiter, and GenRocket will automatically set up the project to generate Fixed File output. Click here to see the help article. |
| JSON File Import | The Import from JSON option can be used to import a JSON File into GenRocket to automatically create the Domains and Attributes defined within the JSON, Avro, or Parquet files. To learn more about this method, please view this help article. |
| JSON Schema File Import | The Import from GenRocket JSON Schema option enables the importing of the many different and evergrowing JSON formats into the GenRocket web platform and successfully turning those formats into concrete Domains with Attributes, Generators with Parent/Child Relationships. For more information, please see these articles: |
| XSD Import | The Import from XSD option can be used to create Domains and Attributes by importing an XML Schema Definition (XSD) that formerly describes the elements of nesting of an XML Document. All Domains and Attributes will be created based on the imported file within the selected Project or Project Version. To learn more about this method, please view this help article. |
| YAML Import | The Import from YAML option can be used to create Domains and Attributes by importing a YAML file based on Open API version 2.0 specification for a selected Project or Project Version. To learn more about this method, please view this help article. |
| Import from Presets | The Import from Presets option can be used to create Domains and Attributes from GenRocket-defined presets or your own custom presets. A Preset contains predefined Domains with their own Attributes and Generator configurations. To learn more about this method, please view this help article. |
| Import from Spark Schema | The Import from Spark Schema option can be used to create Domains and Attributes by importing a Spark Schema file to create a JSON, Avro, or Parquet output. To learn more about this method, please view this help article. |
| Import from Avro JSON Schema | The Import from Avro JSON Schema option can be used to create Domains and Attributes by importing an Avro JSON Schema file into a selected Project Version within a Project. To learn more about this method, please view this help article. |
| Import from CopyBook | The Import from CopyBook option can be used to create Domains and Attributes by importing a CopyBook file. |
| Import from Salesforce | The Import from SF option can be used to create Domains and Attributes by importing your Salesforce data model. To learn more about this method, please view this help article. |
| Scratch Pad | The Scratch Pad option allows testers to quickly and easily model simple to complex test data. To learn more about this method, please view this help article. |
| Quick Pattern | The Quick Pattern option allows users to quickly and easily create Domains that follow a typical design pattern. There are currently three available design patterns: Map/Type Table, List, or Permutation. To learn more about this method, please view this help article. |
| New Domain | The New Domain option can be used to manually create an individual Domain. To learn more about this method, please view this help article. |