Cisco Cisco Process Orchestrator 3.0
4-31
Cisco TEO Adapter Guide for Microsoft SQL Server Database
OL-24576-02
Chapter 4 Using Microsoft SQL Server Database Activities
Defining the Select from SQL Server Activity
Step 5
Complete the appropriate information in the following tabs, as necessary, and then click the Save
tool to complete the activity definition.
•
Info—Review the SQL command used when executing the activity.
•
Target—Specify whether the defined process target should be used or overridden. See
•
Credentials—Specify the runtime user whose credentials should be used to monitor for changes that
will trigger the process. See
will trigger the process. See
in
•
Knowledge Base—Choose the appropriate knowledge base article to associate with the process. See
in
.
•
Result Handlers—Click the appropriate buttons to manage the condition branches on the workflow.
See
See
Note
To view the running SQL queries, see
.
Defining the Select from SQL Server Activity
Use the Select from SQL Server activity to query data from a SQL Server database.
To define the Select from SQL Server activity:
Step 1
On the Toolbox pane, under Database—Microsoft SQL Server, select the Select from SQL Server
activity, then drag and drop the activity onto the Workflow pane.
activity, then drag and drop the activity onto the Workflow pane.
The Select from SQL Server property pages display.
Figure 4-23
Select from SQL Server Properties—General Tab