Cisco Cisco Process Orchestrator 3.1 User Guide
13-86
Cisco Process Orchestrator 3.1 User Guide
Appendix 13 Using Adapters
Database Adapter—Common Database Tasks
Configuring Database Adapters
The database adapters provide the activities to access database objects and execute SQL queries in
Process Orchestrator.
Process Orchestrator.
Step 1
Choose Administration > Adapters, right-click [Database Adapter] and choose Properties.
Step 2
On the properties dialog box, click the SQL tab.
Step 3
Enter:
•
The maximum number of rows to return in a Select SQL query (default=10000).
•
The termination character string with default values. Termination characters can be configured;
common termination characters are forward slash [ / ] and the semi-colon [ ; ].
common termination characters are forward slash [ / ] and the semi-colon [ ; ].
Adding a Column to an SQL Command Line
Use the Column Definitions dialog box to map the properties for a source column or modify the name
of an existing column.
of an existing column.
Step 1
On the SQL tab, under Column List, click Add.
Step 2
In the Column Definition dialog box, enter the column properties.
Adding a Column to Table Source
Use the Column map dialog box to add a column to the queried table source or modify the name of an
existing column.
existing column.
Step 1
On the SQL tab, under Column Map List, click Add.
Step 2
In the Column Map dialog box, enter the column properties.