Cisco Cisco Workload Automation 6.3 ユーザーガイド
18
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
only certain connections to particular databases. A connection is created through the
Connection Definition
dialog.
This dialog contains the following elements:
Name
– Enter a name for this JDBC adapter connection.
Enabled
– Activates or deactivates the connection, shutting down communication with the database.
A job cannot run on an adapter if its connection is disabled.
Use as default for JDBC Jobs
– Select to use the connection as your default connection when setting up future
JDBC jobs.
General
– This tab designates a job limit and default runtime user.
JDBC Connection
– This tab provides information to connect to the designated database.
Options
– This tab provides configuration options for accessing the database.
Description
– This tab describes the connection and provides a convenient place for notes about its purpose and
use.
Adding a Connection Using JDBC
To add a connection:
1.
From the
Navigator
pane, select
Administration>Connections
to display the
Connections
pane.
2.
Click the
Add
button on the toolbar or right-click and select
Add Connection>JDBC Adapter
from the context
menu to display the
JDBC Connection Definition
dialog.
3.
Enter a name for the new connection in the
Name
field.
4.
In the
Job Limit
field of the
General
tab, select the maximum number of concurrent active processes that CWA
should submit to this database at one time.
5.
(Optional) In the
Default Runtime User
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.
supplied as the runtime user in CWA JDBC job definitions.