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.
See also: