Configuring the web application server for your JDBC driver

You must configure the web application server before you install Marketing Operations. All major database types support IBM® EMM tables. Select the JDBC driver according to your database type.

Use the following procedure to obtain the correct JDBC driver for your installation of Marketing Operations, and to configure your web application server to use it.

If you are installing Marketing Operations on the same machine where you installed Marketing Platform, this task is already complete. Continue to Creating the JDBC connections in the web application server.

Obtain the latest Type 4 JDBC drivers and any required associated files (for example, Oracle requires several associated files) for the database you plan to use.

You should always use the latest vendor-provided Type 4 driver.

If the driver does not exist on the machine where Marketing Operations will be installed, obtain it and copy it to any location on the Marketing Operations machine.

If you obtain the driver from a machine where the database client is installed, verify that the version is the latest supplied by the database vendor. See your IBM® consultant for a list of supported JDBC drivers.

The following list provides the driver file name or names for database types supported for IBM® EMM system tables.

Supported database types and drivers
Database type	File for jre 1.6
Oracle 11	N/A
Oracle 11g	ojdbc6.jar
DB2® 9.7	db2jcc.jar db2jcc_license_cu.jar
DB2® 10.1	db2jcc4.jar
SQL Server 2005, 2008	sqljdbc4.jar with JDBC3

Include the full path to the driver in the CLASSPATH of the web application server where you plan to deploy Marketing Operations, as follows.

For all supported versions of WebLogic, add the jar files to the CLASSPATH variable in DOMAIN_DIR\bin\setDomainEnv.cmd. Yours must be the first entry of the CLASSPATH values to ensure that the web application server uses the correct driver. For example, if you are using SQL Server you might set the path as follows.

set CLASSPATH=c:\SQLDRIVER\sqljdbc.jar;%PRE_CLASSPATH%;%WEBLOGIC_CLASSPATH%; %POST_CLASSPATH%;%WLP_POST_CLASSPATH%

For all supported versions of WebSphere®, set the CLASSPATH in the Administration Console.