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 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 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.