Cisco Cisco Process Orchestrator 3.1 Betriebsanweisung

Use the Generic (OLEDB) Adapter to automate common SQL queries in a generic Microsoft Object 
Linking and Embedding Database (OLEDB) database.

The following table displays activities that are provided by the generic Microsoft OLEDB database 
adapter. For more information about using these activities, see 

.1

Bulk Insert into Generic 
Database

Provides source table for data inserted into a generic database. 

For more information, see 

.

Generic Database Locks

Queries the locks performed in the generic database. 

For more information, see 

.

Generic Database Table 
Space

Queries the table space in a generic database. 

Delete from Generic 
Database

Deletes data from the generic database using SQL command lines. 

Enter the command text for the selected database. For example, this is a 
simple DELETE statement:

DELETE from mytable where mycolumn = 'zzz'

For more information, see 

Execute Generic Database 
SQL Script

Use the Execute Generic Database SQL Script activity to execute SQL 
script against the specified database.

New support in release 3.0 allows retrieval of data tables from SAP HANA 
databases. The activity can retrieve the data table directly or through the 
mechanism HANA uses.

For more information, see 

.

Insert Into Generic 
Database

Executes SQL command used to insert data into a generic database. 

Enter the command text for the selected database. For example, this query 
inserts values into a table:

INSERT into mytable (column1,column2) VALUES ('val1','val2')

List Generic Database 
Running SQL Queries

Queries the running SQL queries performed. 

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).