Cisco Cisco Process Orchestrator 3.1 Betriebsanweisung

Use the SQL Server Database target to specify the connection information for a SQL server target.

Choose Definitions > Targets, right-click and choose New > SQL Server Database.

Click the General tab and enter the appropriate information.

Click the Connection tab and enter the required information, including:

Server—Host name or IP address of the database server

Default runtime user—The default runtime user account that contains the credentials to connect to 
the target. 

Connection string—The information needed to establish a connection to the database. To connect to 
a non-default instance, use the (server\instance) format. If your SQL server has a non-default port 
number, the correct format is to enter the server\instance, then a comma, then the port number. For 
example:

servername,portnumber

Click the Permission tab to define the type of SQL commands that can run on the target.

Click OK to close the dialog box and complete the procedure.

Use this activity to execute SQL script against a Microsoft SQL Server database.

In the Process Editor Toolbox, choose the [Microsoft SQL Server Database Activity] property page, 
then click the Execute SQL Server SQL Script tab.

Specify the information that describes the script you want to run, including the script text for the selected 
database. For example:

To truncate a sample table Employees:

TRUNCATE TABLE Employees

To execute a stored procedure:

exec master..xp_logininfo

.