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.

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.

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

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

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

  4. Click Export to continue.