Database Connection String
UI Element
| Description |
---|
Connection String | A connection string in the appropriate format for the selected database type. See Sample Connection Strings. |
Credentials | How to handle the supplied credentials: - Save into credential store as new identity: Use a connection string with credentials that are not yet in the Credential Store.
- Use existing identity: Select existing credentials from the Credential Store.
- Use Windows integrated security: Connect to the database with your Windows credentials, which are not stored by SV. Note: Ensure that a standalone server is running with the appropriate account.
|
Test Connection | Checks if the Service Virtualization server can successfully connect to the database with the specified connection string. |
Data Driving Properties
UI Element
| Description |
---|
Use Schema | The schema to use for both import and export. This is useful when you have a large database. |
Table Prefix | For importing: The prefix of the tables that SV will allow you to use. This is useful when you have many tables and want to filter out some of them. For exporting: The prefix of the tables that SV will export. SV considers any table with this prefix as a potential for export. The screen lists the number of existing tables that match the prefix. Caution: Make sure that you do not have any unrelated tables with the prefix that you are specifying, as SV will overwrite them. |
Data synchronization | For importing: Automatically import data from the external data source before each simulation. For exporting: Export data to bound tables after each learning. |
Read-Only Schema | For exporting: If the supplied credentials lack privileges to create or modify tables, this option lets you generate an SQL script that performs the necessary changes. You can run the SQL script with database administration credentials and then export the rule again. |
Service Operations | The operations in your virtual service for which you want to import/export data. By default, only the selected service's operations are used. To edit the list of operations, click Change and modify the list. |