This topic explains how to configure and apply the SQL Responder Action tool, which allows you to model complex interdependent environment scenarios by connecting multiple virtual assets. More specifically, it enables you to have a Message Responder update values in a virtual database that is represented by a .CSV-driven SQL Responder.

Sections include:

...

The SQL Responder Action tool enables you to establish an interconnected virtualization environment where an operation made by a Message Responder updates values in a virtual database that is represented by a . CSV-driven SQL Responder.

...

By applying SQL Responder Action tools, you can create a synchronized environment so that when the virtualized service performs an operation, it will update the corresponding value in the virtual database. That updated virtual database value can then be accessed or operated on by yet another virtual asset (perhaps another service that retrieves account values and transaction histories)—creating , creating a chain of interconnected operations.

...

To add a SQL Responder Action tool, chain it as an outgoing response to the Message Responder that modifies data in the virtual database.

Next, configure the following options:options on the Target, ResultSet Selector and Row Selector tabs.

Target Tab

Configure the following settings in this tab:

• Target column is : Specifies the virtual database column you want to modify.
• Operation describes : Describes how you want to modify the existing data in the virtual database.
• Value is : Specifies the value that will be used to perform the specified operation. You can use specific fixed values—for values. For instance, if you’re transferring $100  $100 from one account to another, the value here would be 100. You can also use scripted or parameterized values—for instancevalues, for example, a value that was pulled from the incoming request and stored in an Incoming Request> Request > XML Data Bank tool.
• JDBC URL points : Points Virtualize to the appropriate set of files captured during the database recording. Type j. to open a list of valid JDBC URLs.

ResultSet Selector Tab

You add Add Query Parameters table values to specify which recorded result set you want updated with the value and operation specified in the Target tab. For instance, you might have result sets for customer_id 12212 and customer_id 12222. If you want this action to be performed only on queries for customer_id 12212, you would indicate this as follows:

Note that the names and values that you specify here need to correspond to the actual values in the SQL query and result set (see the SQL Responder control panel to review the actual values).

...

Resetting Data Modified by the Tool

To reset the originally - recorded values for any data that was modified by this tool:

1. In the Virtualize Server view, double-click Local machine.
   
2. In the page that opens, click the Reset button.