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
-
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.
-
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.
-
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.
-
Record the JNDI names in the IBM Distributed Marketing installation database information worksheet.