If you select the option to capture and generate data, you are then able to customize the use of collecting or generating data on specific tables. Click Next to continue.
- The following dialog will prompt you to select which tables are to have generated data and which tables are to have data captured from the existing data. Click Next to continue.
Note
For entities where sample data will be captured, if a query is set on a entity this query will be run on the source connection to collect sample data for that entity, otherwise a query will be generated. Refer to Entity Query Properties for details.
- The Export sample data - Configure the boundaries and limitations dialog will prompt you to configure the boundaries and limitations of the export.
Enter the following details:Fields
Description
Connections
This field allows you to specify the connections from which the data may be obtained.
Referential Integrity
When selected, this enforces the referential integrity as defined by the foreign key constraints.
Maximum Iterations
The maximum number of iterations performed to resolve cyclic referential integrity. The user will be informed if referential integrity could not be obtained within the specified number of iterations.
Click Next to continue.
- The dialog that follows allows you to define the data characteristics. Click Next to continue.
Enter the following details:Fields
Description
Populate from template
Click to Select data characteristics template.
Varchar
Expand to define the characteristics for data of type varchar.
Number
Expand to define the characteristics for data of type number.
Date and time
Expand to define the characteristics of data of type date and time.
Minimum null%
This field allows you to specify the minimum percentage of null values.
Maximum null%
This field allows you to specify the maximum percentage of null values.
- The following dialog allows you to manage ranges for the number of rows. Click Next to continue.
Icons
Description
Click to Create range.
Select a range and click to Edit range.
Select a range and click to Delete range.
- The Export sample data - Select the destination folder dialog allows you to set the column and record delimiters and to select the destination folder.
Enter the following details:Icons
Description
Delimited
Choose between delimited and fixed width.
Column delimiter
Select one of the following from the drop-down list:
- Newline (EOL or LF)
- Tab
- CR
- Character
- ASCII Code
Record delimiter
Select one of the following from the drop-down list:
- Newline (EOL or LF)
- Tab
- CR
- Character
- ASCII Code
Apply escape characters
Apply escape characters to values defined by RFC 4180. Any " in a value is substituted by "". If the value contains a comma, carriage return or line feed the value is encapsulated in double quotes.
Size escape characters
Consider escape characters as part of the value, hence limiting the maximum length of the generated value. This is for instance required for MS SQL Server bulk load.
Export folder
Each entity becomes a CSV file with a name reflecting the entity.
- Click Export to continue.