Cisco Cisco Workload Automation 6.3 Betriebsanweisung

Configuring the JDBC Adapter

Defining a Connection Using JDBC

You can create connections to one or more databases. JDBC access can be managed by limiting a user account to use 
only certain connections to particular databases. A connection is created through the 

 dialog.

This dialog contains the following elements:



 – Enter a name for this JDBC adapter connection.



 – Activates or deactivates the connection, shutting down communication with the database.

A job cannot run on an adapter if its connection is disabled. 



 – Select to use the connection as your default connection when setting up future 

JDBC jobs. 



 – This tab designates a job limit and default runtime user.



 – This tab provides information to connect to the designated database.



 – This tab provides configuration options for accessing the database.



 – This tab describes the connection and provides a convenient place for notes about its purpose and 

use.

Adding a Connection Using JDBC

From the 

 pane, select 

to display the 

pane.

Click the 

 button on the toolbar or right-click and select 

 from the context 

menu to display the 

 dialog.

Enter a name for the new connection in the 

 field.

In the 

 field of the 

 tab, select the maximum number of concurrent active processes that CWA 

should submit to this database at one time.

(Optional) In the 

list, select the name of a default user for JDBC jobs.

Only users that have been defined with adapter passwords display in this list. The user selected is automatically 
supplied as the runtime user in CWA JDBC job definitions.