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.

About this task

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.

Note: 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.

Procedure

  1. 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 HCL 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.

    Table 1. Supported database types and drivers
    Database type File for jre 1.6
    Oracle 11 N/A

    Oracle 11g

    		 ojdbc6.jar

    DB2® 9.7

    		 db2jcc4.jar

    db2jcc_license_cu.jar

    DB2 10.1

    		 db2jcc4.jar

    SQL Server 2008, 20012

    		 sqljdbc4.jar with JDBC4
  2. 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.