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 database in the web application server where Distributed Marketing is deployed:

  • The database that contains the Distributed Marketing system tables
  • The database that contains the Marketing Platform system tables
  • 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.

Complete the following tasks for creating the connections in WebSphere® and WebLogic:

Procedure

  1. 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.
  2. 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.
  3. Use any name for the connection to the customer database.
  4. Record the JNDI name in the IBM Marketing PlatformCampaignDistributed MarketingeMessageContact OptimizationInteractLeadsOpportunity DetectDigital Analytics for On PremisesCustomerInsightPredictiveInsightMarketing OperationsInteraction HistoryAttribution ModelerIBM SPSS Modeler Advantage Enterprise Marketing Management Edition Installation database information worksheet.