Unica Interact

Create JDBC connections in the web application server

Use the following table to create JDBC connections to the databases that hold the Interact, Campaign, and 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.

The following sections provide information on creating JDBC connections on different application servers.

WebLogic

Use the following values if your application server is WebLogic.

OneDB

  • Driver: OneDB JDBC Driver
  • Default port: <onedb port>
  • Driver class: com.informix.jdbc.IfxDriver
  • Properties: jdbc:informix-sqli:<your_db_host>:<your_db_port>/<your_db_name>:INFORMIXSERVER=<Informix_server_name>;user=<username>;password=<Password>

    For example: jdbc:informix-sqli://localhost:9090/unicaifx:INFORMIXSERVER=ol_informix1410;user=test_user;password=test_password

WebSphere

Use the following values if your application server is WebSphere.

OneDB
  • Database Type: OneDB JDBC Driver
  • Default port: <onedb port>
  • Driver class: com.informix.jdbc.IfxDriver

  • Driver URL: jdbc:informix-sqli:<your_db_host>:<your_db_port>/<your_db_name>:INFORMIXSERVER=<Informix_server_name>;user=<username>;password=<Password

    For example: jdbc:informix-sqli://localhost:9090/unicaifx:INFORMIXSERVER=ol_informix1410;user=test_user;password=test_password

Tomcat

Use the following values if your application server is Tomcat.

OneDB
  • Driver: ONEDB JDBC Driver
  • Default port: <onedb port>
  • Driver class: com.informix.jdbc.IfxDriver
  • Driver URL: jdbc:informix-sqli:<your_db_host>:<your_db_port>/<your_db_name>:INFORMIXSERVER=<Informix_server_name>;user=<username>;password=<Password>

    For example: jdbc:informix-sqli://localhost:9090/unicaifx:INFORMIXSERVER=ol_informix1410;user=test_user;password=test_password

JBOSS

Use the following values if your application server is JBOSS.

OneDB
  • Database Driver: ONEDB JDBC Driver
  • Default port: <onedb port>
  • Driver class: com.informix.jdbc.IfxDriver
  • Driver URL: jdbc:informix-sqli:<your_db_host>:<your_db_port>/<your_db_name>:INFORMIXSERVER=<Informix_server_name>;user=<username>;password=<Password>

    For example: jdbc:informix-sqli://localhost:9090/unicaifx:INFORMIXSERVER=ol_informix1410;user=test_user;password=test_password

  • valid-connection-checker class-name= org.jboss.jca.adapters.jdbc.extensions.informix.InformixExceptionSorter