Cisco Cisco Process Orchestrator 3.1 Guia Do Utilizador
13-78
Cisco Process Orchestrator 3.1 User Guide
Appendix 13 Using Adapters
Database Adapter—Generic (OLEDB)
Step 4
Click the Configuration tab to specify the character restrictions for a database identifier. A distinction
is made between simple identifiers and special identifiers.
is made between simple identifiers and special identifiers.
Step 5
Click the Permission tab to define the type of SQL commands that can run on the target.
Step 6
Click OK to close the dialog box and complete the procedure.
Automating SQL Queries in the Generic (Microsoft OLEDB) Database
Executing a Generic (OLEDB) SQL Script
This script executes an SQL script against a Generic (OLEDB) database.
Step 1
In the Process Editor Toolbox, choose the [Generic (OLEDB) SQL Database Activity] property page,
then click the Execute Generic Database SQL Script tab.
then click the Execute Generic Database SQL Script tab.
Step 2
Specify the information that describes the script you want to run, including the SQL script text for the
selected database. For example, to encrypt data using the ODBC ENCRYPT function:
selected database. For example, to encrypt data using the ODBC ENCRYPT function:
create proc #tfn
as
select { fn USER() } , { fn CURRENT_DATE() },
{ fn CURRENT_TIME() }, { fn CURRENT_TIMESTAMP() }
go
exec #tfn
go
drop proc #tfn
Step 3
In the Columns panel, click Add to display the Table Column properties dialog box and define the table
column and data type to be displayed.
column and data type to be displayed.
Step 4
Enter the other criteria as necessary.