<< Click to Display Table of Contents >>

Dynamic XML dataset

To create a dynamic XML dataset, select [Add Dynamic Dataset] from the right mouse click popup menu on the HTTP STORE in OZ data window.

Check "XML dataset" in Add Dynamic Dataset - HTTP Store dialog.

Set options in Add Dynamic Dataset - XML dialog. Click [OK] on Add Dynamic Dataset - XML dialog and dynamic XML dataset information appears under HTTP store in data window.

Dialog Options

XML 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 XML file location in design

A temporary design time XML 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.

Dataset node name

The node name representing the dataset in the XML file. Default name is DATASET.

Recordset node name

The node name representing the record set in the XML file. Default name is RECORD.

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