Cisco Cisco Process Orchestrator 3.0

Pagina di 106
 
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 
 in 
  •
Credentials—Specify the runtime user whose credentials should be used to monitor for changes that 
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 
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.
The Select from SQL Server property pages display.
Figure 4-23
Select from SQL Server Properties—General Tab