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
-
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.
-
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.
-
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.
-
Record the JNDI names in the Unica Collaborate installation database information worksheet.