Step: Configure the web application server for your JDBC driver

You must obtain the correct JAR file for the JDBC connections the Marketing Platform requires. You must also add the location of the file to the class path of the web application server where you plan to deploy the Marketing Platform.

Perform this procedure for every web application server where you plan to deploy your IBM® EMM products.

Obtain the latest vendor-provided Type 4 JDBC driver that is supported by IBM® EMM, as described in the IBM® Marketing Platform Recommended Software Environments and Minimum System Requirements document.

If the driver does not exist on the server where you plan to deploy the Marketing Platform, obtain it and unpack it on the server. Unpack the drivers in a path that does not include spaces.

If you obtain the driver from a server where the data source client is installed, verify that the version is the latest supported by IBM® .

The following table lists the driver file name or names for the databases that are supported for IBM® EMM system tables.

Database	Files
Oracle	ojdbc6.jar
DB2®	db2jcc.jar db2jcc_license_cu.jar - not required in V9.5 and higher
SQL Server	You must use version 3.0 of the SQL Server driver and above. See the IBM® EMM Recommended Software Environments & Minimum System Requirements for the exact version of this driver to use. sqljdbc.jar

Add the full path to the driver, including the file name, to the class path of the web application server where you plan to deploy the Marketing Platform.

For all supported versions of WebLogic, set the class path in the setDomainEnv script in the WebLogic_domain_directory/bin directory where environment variables are configured. Your driver entry must be the first entry in the class path list of values, before any existing values, to ensure that the web application server uses the correct driver. For example:

UNIX™

CLASSPATH="/home/oracle/product/11.0.0/jdbc/lib/ojdbc6.jar:
${PRE_CLASSPATH}${CLASSPATHSEP}${WEBLOGIC_CLASSPATH} 
${CLASSPATHSEP}${POST_CLASSPATH}${CLASSPATHSEP}${WLP_POST_CLASSPATH}"
export CLASSPATH

Windows™

set CLASSPATH=c:\oracle\jdbc\lib\ojdbc6.jar;%PRE_CLASSPATH%;
%WEBLOGIC_CLASSPATH%;%POST_CLASSPATH%;%WLP_POST_CLASSPATH%

For all supported versions of WebSphere®, you set the class path in the next step, while you are setting up the JDBC providers for the Marketing Platform.

Make a note of this database driver class path in the Marketing Platform database information checklist, as you must enter the path when you run the installer.

Restart the web application server so your changes take effect.

During startup, monitor the console log to confirm that the class path contains the path to the database driver.