External Data Properties Dialog Box

This dialog box enables you to configure options for a data rule that is working with an external data source.

External File

Database

To access

Right-click a rule or column header and select External Data Properties.

Available for a rule that is associated with an external data source for import or export.

Relevant tasks Work With External Data Sources
See also Data Driving

User interface elements are described below:

UI Element Description
Importing data from external data source The rule is associated with an external data source from which it has imported data.
Exporting data to external data source The rule is associated with an external data source to which it has exported data.
External Data File The path to the associated external data file.
Column Names

Indicates that the first row of your file is a header row, containing the names of each column.

Available for import only.

Data Synchronization

For import: Data is automatically re-imported from the external data source before each Simulation session.

For export: Data is automatically exported to the external data source after a virtual service Learning session.

Service Operations

The operations in your virtual service that are configured for import or export.

By default, only the active operation of the virtual service is selected. To change this selection, click Change and edit the list of operations.

Relations

Binding configuration for working with array data. You can define the relationships between tables that is required for array binding.

Primary/Foreign Key: The drop-down lists display the columns in the external data source. The format of the keys is <worksheet_name>.<column_name> for Excel files, or <schema>.<table>.<column name> for a database source.

Order By: A drop-down list of the available columns in the child table to be used for ordering items within the array.

Select a value for each key to define the relationship.

Add

Adds a row, enabling you to define an additional relationship between Excel worksheets or database tables.

Available when working with array data.

Delete

Removes the selected row.

Available when working with array data.

Refresh Data on Confirm Updates the data according to your new settings. For example, if you changed the setting from Import to Export, the data is exported to the external file when you click Finish.

This dialog box enables you to configure options for a data rule that is working with an external data file.

Back to top

See also: