Creating the JDBC connection in the web application server

About this task

The Marketing Platform 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 Marketing Platform.

You can allow the installer to create this data source when you install Marketing Platform. To enable automatic data source creation during installation, on the Datasource Creation panel, select the Create Marketing Platform Datasource check box and supply information about your application server.

  • The installer creates the data source using UnicaPlatformDS 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.

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

  • In WebSphere®, set the classpath for your database driver during this process.
  • You must use UnicaPlatformDS as the JNDI name. This name is required, and is noted in the Marketing Platform installation worksheet.
  • When the Marketing Platform 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.