Creating the JDBC connection in the web application server

About this task

The Unica Journey web application must be able to communicate with its system table database using a JDBC connection.

You must create this JDBC connection in the web application server where you plan to deploy Unica Journey.

Follow these guidelines if you decide to create the data source manually.

  • In WebSphere┬«, set the classpath for your database driver during this process.
  • When the Unica Journey system tables are created in a different schema from the default schema of the database login user, you must specify that non-default schema name in the JDBC connection used to access the system tables.
  • In Tomcat, set the classpath for your database driver during this process.
  • In JBOSS, set the classpath for your database driver by adding the module for the JDBC driver and register the SQL JDBC driver.
  • You must use JourneyDS and JourneyReportDS as the JNDI name. This name is required, and is noted in the Unica Journey installation worksheet.