Creating the JDBC connections in the web application server

The Collaborate web application uses JDBC connections to communicate with the system table database and with the Platform system table database.

About this task

You must create the following JDBC connections to the following databases in the web application server where Collaborate is deployed:

If you are creating the data source in WebSphere®, set the classpath for your database driver during this process.

Procedure

  1. Create a connection to the database that contains the Collaborate system tables.

    You can allow the installer to create this data source when you install Collaborate. To enable automatic data source creation during installation, on the Datasource Creation panel, select the Create Collaborate 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 Collaborate 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.

  2. Create a connection to the database that contains the Platform system tables.

    If is Platform already installed, and if you deploy Collaborate. in the same JVM as 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 Platform system tables. This is the required name.

  3. Create a connection to the customer database that contains your list tables.

    If you plan to deploy Collaborate 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.

  4. Record the JNDI names in the Unica Collaborate installation database information worksheet.