Cisco Cisco Process Orchestrator 3.1 Betriebsanweisung
13-74
Cisco Process Orchestrator 3.1 User Guide
Appendix 13 Using Adapters
Database Adapter—Microsoft SQL Server
Getting Started Using the Microsoft SQL Server Database Adapter
Use the following process to monitor and manage Microsoft SQL Server database instances.
Step 1
Create a Microsoft SQL Server database target (see
Step 2
Define a Microsoft SQL Server database activity.
a.
In the Process Editor Toolbox, choose Database > Microsoft SQL Server > [Microsoft SQL
Server Database Activity], then drag and drop the activity onto the Workflow pane.
Server Database Activity], then drag and drop the activity onto the Workflow pane.
b.
Click the General tab and enter the required information.
c.
Click the [Activity-Specific] tabs to define the properties specific to the activity.
d.
Enter the information in the remaining tabs as necessary, then click Save to complete the activity
definition.
definition.
For details about a specific activity, see
Step 3
View the activity results (see
).
List SQL Server Running
SQL Queries
SQL Queries
Display the results of the running SQL queries performed in the SQL
server database.
server database.
Specify the information that describes the query results, including:
•
Row Limit—The appropriate number rows to limit for the query and
returned data (default=50).
returned data (default=50).
Select from SQL Server
Query data from an SQL server database.
For more information, see
.
Select From Report
Database
Database
Query data from a report database.
For more information, see
.
Note
Use a different Select activity when switching between databases.
SQL Server Lock
Information
Information
Use this activity to display a list of all client processes that have locks.
For more information, see
.
Update SQL Server
Use this activity to update column information in the SQL Server database
using SQL command lines.
using SQL command lines.
Enter the command text for the selected database. For example, this
sample query updates the columns in a table:
sample query updates the columns in a table:
Update mytable set column1 = 'newvalue' where column2 = 'zzz'
Activity
Comments