Page History
If you select the option to capture a sample from the source system, then random data will be collected from the source connection. Select the warning acceptance checkbox and click Next to continue.
REPLACE WITH THIS IMAGE: Images/Wizards/Exporting Sample Data_1.png
Note | ||
---|---|---|
| ||
If a query is set on |
...
an 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 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.