Руководство Пользователя для Cisco Cisco Workload Automation 6.3
19
Configuring the JDBC Adapter
Defining a Connection Using JDBC
6.
Click the
JDBC Connection
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.
using JDBC. If you wish to connect to a specific database, you can designate that database for the connection.
7.
Use automatic population or manual entry to enter data:
Automatic population
: Use predefined templates for the most commonly used database connections:
a.
In the
JDBC Template
field, select a template from the drop-down menu.
The
JDBC Driver
field and the
JDBC Connection String (URL)
field are automatically populated.
Note:
You must select the JDBC driver before overriding the JDBC connection string, otherwise, the connection will
not be saved.
b.
In the
JDBC Host
field, enter the host machine.
The
<Host> placeholder in the
JDBC Connection String (URL)
field is replaced.
c.
In the
Connect User
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
Database/DSN
field.
d.
(Optional) In the
Database/DSN
field, select from the drop-down menu or enter the name of the database for
this connection.
Note:
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.
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
JDBC Connection String (URL)
field.
Manual entry:
If the driver for your RDBMS is not listed in the
JDBC Template
drop-down menu, enter the
information manually:
a.
In the
JDBC Driver
field, enter your JDBC driver’s fully qualified class name.