Create JDBC connections on each of the web application servers where
Unica Campaign and Unica Interact is deployed. Unica Campaign
and Unica Interact use the JDBC connections to access the required
databases.
You can use the list to simplify configuration because
the names in the list match the default values of the configuration
properties that refer to the JDBC connections.
Use the following
table to create JDBC connections to the databases that hold the Interact, Unica Campaign, and Unica Platform tables:
Table 1. JDBC connections in the web application server
This two-columned table provides information about the deployed web
application in one column, and the JDBC connections that are required to the databases in the second
column.
Deployed web application |
JDBC connections required to the databases |
Unica Campaign
|
In the web application server where Campaign is deployed, create JDBC connections to the
databases that hold the following tables:
-
Unica Interact runtime tables
JNDI name: InteractRTDS
-
Unica Interact test run tables (which can be the same as the Customer (User)
tables)
JNDI name: testRunDataSource
|
Unica Interact runtime environment
(The Unica Interact runtime environment is typically deployed in a different
JVM from Unica Campaign)
|
In the web application server where the Unica Interact runtime environment is
deployed, create JDBC connections to the databases that hold the following tables:
-
Unica Interact runtime tables
JNDI name: InteractRTDS
-
Unica Interact profile tables
JNDI name: prodUserDataSource
-
Interact test run tables (required for test run server group only)
JNDI name: testRunDataSource
-
Unica Interact learning tables (if you are using built-in learning)
JNDI name: InteractLearningDS
-
Unica Campaign contact and response history
tables (if you are using cross-session response tracking)
JNDI name: contactAndResponseHistoryDataSource
-
Unica Platform system tables
JNDI name: UnicaPlatformDS
Important: This is the required JNDI name for connections to the Platform system table
database.
You must set up the JDBC connection only if you install the Unica Interact
runtime environment in a web application server where Unica Platform is not currently deployed. If
Unica Platform is deployed in the same
web application server, the JDBC connection is already defined.
All JNDI names are recommended, unless otherwise indicated.
|