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.
REPLACE WITH THIS IMAGE: Images/Wizards/Capturing and Generating Data.png
- 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.
REPLACE WITH THIS IMAGE: Images/Wizards/Capturing and Generating Data_1.png
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.
REPLACE WITH THIS IMAGE: Images/Wizards/Capturing Sample Data from Source Connection.png
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.
REPLACE WITH THIS IMAGE: Images/Wizards/Capturing and Generating Data_3.png
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.
REPLACE WITH THIS IMAGE: Images/Wizards/Capturing Sample Data from Source Connection_1.png
Icons |
Description |
|---|---|
REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png |
Click to Create range. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/renamequeryicon.png |
Select a range and click to Edit range. |
REPLACE WITH THIS IMAGE: Images/Common_Icons/removequeryicon.png |
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.
REPLACE WITH THIS IMAGE: Images/Wizards/Capturing Sample Data from Source Connection_2.png
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:
|
Record delimiter |
Select one of the following from the drop-down list:
|
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.