CSV dataset name

Dataset name

Starting row number

The starting number of ROW INDEX for dynamic dataset. The value must be in range of 0~2147483647 and the default is zero.

User application URL

HTTP address of user application or data file. User application URL can also be set using the parameter wizard by clicking [Parameter] button.

Temp CSV file location in design

A temporary design time CSV file path on the local system. It can be set with the parameter wizard by clicking [Parameter] button and also be selected by [Browse] button.

Field delimiter

Set the field delimiter. Select one of TAB, SPACE, SEMICOLON, COLON, COMMA, or enter your delimiter.

You can also set the field delimiter with the parameter wizard by clicking [Parameter] button.

Include field type information

Check if CSV file includes field type. If not check, all field types are regarded as "VARCHAR".

Line delimiter

Set the line delimiter. You can enter your delimiter and the default is LINEFEED.

You can also set the line delimiter with the parameter wizard by clicking [Parameter] button.

Null mark

A string to represent the NULL value.

Character set

Character set of a file. The default is default locale of the system.

Error indication code

Set the code to notice a data error. If the code value appears at the first line of the file, an error message box will be displayed with no report preview. For example, if a CSV file have "ERR" at the first line and you set the error indication code to "ERR", "ERR" won't be recognized as data and a message box shows saying the file is not valid CVS file.

Enclosed with Double Quotes

Check if the data enclosed in double quotes is treated as one data.

Server Log file name

The file on the server to log data received when ODI is binding on the server. Enter only the file name without path.

Retry count

Retry count to reconnect when an error occurs with HTTP store dataset. If not set or invalid value, the default is 5.

Set URL encoding

Check to encode Server URL. Check if URL parameter includes foreign language character like Korean when requesting data.

Submit by POST method

Check to use POST method to send URL parameter and uncheck for GET method.

Alias

Check if use dataset alias defined in datasource.properties file on the server and enter the alias name.

Alias filename: configuration file for dataset alias.

View Data

Previews data of the CSV file. If the server log file name was set, all data rows are fetched before viewing data regardless of the maximum row number and so, performance may possibly be slower.

Save Dataset Information

Save dataset information (field name, field type) as CSV file. This button is activated only when modifying the dataset and uses UTF-8 data encoding.

Save Original Data

Save the original dataset as a file. [Save Original Data] button will be activated only when modifying the dataset.