Cisco Cisco Workload Automation 6.3 Guida Utente

Configuring the JDBC Adapter

Defining a Connection Using JDBC

Click the 

 tab.

This tab defines how to access a database using JDBC. There are several different ways to connect to a database 
using JDBC. If you wish to connect to a specific database, you can designate that database for the connection.

Use automatic population or manual entry to enter data:

: Use predefined templates for the most commonly used database connections:

In the 

 field, select a template from the drop-down menu.

The 

 field and the 

 field are automatically populated.

You must select the JDBC driver before overriding the JDBC connection string, otherwise, the connection will 

not be saved.

In the 

 field, enter the host machine.

The 

<Host> placeholder in the 

field is replaced.

In the 

 field, optionally enter a user that is used to connect to the database from the drop-down 

menu.

You must enter a user to obtain a drop-down list of databases in the 

 field.

(Optional) In the 

 field, select from the drop-down menu or enter the name of the database for 

this connection.

If the JDBC connection was created using an Oracle/DB2 database, the “Database Name” is the Schema 

Name and not the actual Database name used while creating JDBC jobs and events.

The drop-down menu only lists databases for connections where a database name is optional; otherwise, if a 
database name is required to make a JDBC connection, you must type in the name.

This value is added to the JDBC connection string in the 

field.

 If the driver for your RDBMS is not listed in the 

 drop-down menu, enter the 

information manually:

In the 

 field, enter your JDBC driver’s fully qualified class name.