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