You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

If you select the option to generate data; instead of collecting actual data, you will generate representative data. Select the , the warning acceptance checkbox and click Next to continue.
REPLACE WITH THIS IMAGE: Images/Wizards/Generating Data.png

  1. 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.
REPLACE WITH THIS IMAGE: Images/Wizards/Capturing and Generating Data_4.png

Number

Expand to define the characteristics for data of type number.
REPLACE WITH THIS IMAGE: Images/Wizards/Capturing and Generating Data_5.png

Date and time

Expand to define the characteristics of data of type date and time.
REPLACE WITH THIS IMAGE: Images/Wizards/Capturing and Generating Data_6.png

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

    • 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.
  1. Click Export to continue.
  • No labels