Working with External Data Sources - Use-case Example
This section provides an example of working with an external data file.
Note: For a task related to this example, see Work With External Data Sources.
It can be difficult to manually configure an Excel worksheet when your data has a particular complex structure. As an alternative to manually setting up a file and configuring binding in the Data Model, you can create a new data driven rule, and have Service Virtualization create a new data file for you, according to your message structure.
- Create a virtual service.
In the Data Model, create a new data driven rule and select Create new data file. Service Virtualization will create the new file according to your message structure, and bind the columns.
Select Data Synchronization to automatically re-import data in the new file before Simulation.
Alternatively, clear the Data Synchronization check box. You can choose to import at a later time.
After the new data file is created, you can add data to it. If you selected Data Synchronization, when you place your virtual service into Simulating mode, the external data is re-imported. If you did not select Data Synchronization, you can choose to refresh the data manually at any time, or reconfigure the rule for data synchronization.