Cisco Cisco Workload Automation 6.3 User Guide

Configuring the JDBC Adapter

Securing the JDBC Adapter

For operation with MSSQL 2008, you will need Microsoft SQL Server JDBC Driver 2.0 or Microsoft SQL Server 

JDBC Driver 3.0, which is backwards compatible with SQL Server 2000, SQL Server 2005, and SQL Server 2008. 
Version 3.0 has additional support for SQL Server 2008. The Microsoft SQL Server JDBC Driver 3.0 download 
contains two jar files, sqljdbc.jar and sqljdbc4.jar. Use sqljdbc.jar with JRE 5.0 and sqljdbc4.jar for JRE version 6.0 
or later.

Windows Example: 

C:\Program Files\TIDAL\Scheduler\master\services\{7640B420-5530-11DE-8812-7B8656D89593}\lib

Unix Example:   

/opt/tidal/master/services/{7640B420-5530-11DE-8812-7B8656D89593}/lib

You will now update the service.props to include a reference to the CLASSPATH for the JDBC driver for use in your 
configuration.

service.props entry example for Windows:

CLASSPATH= C:\\Program Files\\TIDAL\\Scheduler\\master\\services\\{7640B420-5530- 

11DE-8812-7B8656D89593}\\]lib\\sqljdbc.jar;${CLASSPATH})

This example is for SQLServer JDBC driver on Windows. The .jar file will refer to the appropriate driver for your 

configuration. Also note the use of ";" as a classpath separator on Windows systems. You will use the appropriate 
separator for you operation system, for example ":" on Unix/Linux systems.

service.props entry example for Unix:

CLASSPATH=/opt/unixsa/6.0.1/master/152/TIDAL/master/lib/sqljdbc.jar:${CLASSPATH}

Reboot the Master machine on Windows as needed. Source the profile file as needed on Unix.

Restart the master.

For Windows installations: The JDBC Libraries requires Microsoft Visual C++ runtime components. If your 

system does not include these components and there is an error starting the JDBC Adapter, you may need to install 
the runtime components from Microsoft.

Download the installer from Microsoft, as follows for the version of the JDBC Adapter being installed:
Download "Microsoft Visual C++ 2005 Redistributable Package (x86)" or "Microsoft Visual C++ 2005 SP1 
Redistributable Package (x64)"  as appropriate.  These downloads can be found from Microsoft's site given an 
internet search from your browser.

Securing the JDBC Adapter

Access to databases using JDBC is controlled by assigning a JDBC security policy with specified privileges to user 
accounts. The system administrator should create a new security policy or edit an existing policy in CWA as described 
in the Users chapter of the Cisco Workload Automation User Guide. In addition to the normal user privileges, this policy 
should include the capability to add or edit JDBC jobs. A user whose assigned security policy does not include JDBC 
privileges cannot create or run JDBC jobs.

The user types associated with the JDBC Adapter are described as follows and are defined in the 

 pane:



Runtime Users

Runtime users in the context of JDBC jobs represent those users and passwords required to connect to the database 
using JDBC to run queries. 



Schedulers