Creating the JDBC connections in the web application server

The Distributed Marketing web application uses JDBC connections to communicate with the system table database and with the IBM® Marketing Platform system table database.

About this task

You must create the following JDBC connections to the following databases in the web application server where Distributed Marketing is deployed:

If you are creating the data source in WebSphere®, set the classpath for your database driver during this process.

Procedure

  1. Create a connection to the database that contains the Distributed Marketing system tables.

    You can allow the installer to create this data source when you install Distributed Marketing. To enable automatic data source creation during installation, on the Datasource Creation panel, select the Create Distributed Marketing Datasource check box and supply information about your application server.

    • The installer creates the data source using collaborateds as the JNDI name.
    • Note that, if you are using WebLogic, you must add the JDBC driver to your classpath manually even if you allow the installer to create the data source. The installer does this automatically for WebSphere.

    If you create this connection manually, use collaborateds as the JNDI name for the JDBC connection to the database that holds the Distributed Marketing system tables. This is the default value of a configuration property that refers to this name. If you do not use the default value, you must set the value later in the configuration process.

  2. Create a connection to the database that contains the Marketing Platform system tables.

    If is Marketing Platform already installed, and if you deploy Distributed Marketing. in the same JVM as Marketing Platform, this connection should already exist.

    If you create this connection, use UnicaPlatformDS as the JNDI name for the JDBC connection to the database that holds the Marketing Platform system tables. This is the required name.

  3. Create a connection to the customer database that contains your list tables.

    If you plan to deploy Distributed Marketing on a clustered environment, you must create JNDIs in the WebSphere Application Server. You can use any name for the connection to the customer database.

  4. Record the JNDI names in the IBM Distributed Marketing installation database information worksheet.