Work with your Microsoft SQL Server database server administrator to gather the information that you need to create a data source for your IBM® Content Navigator database on the web application server and update the script that is used to create a table for IBM Content Navigator on your Microsoft SQL Server database. The data source enables the web client to connect to the IBM Content Navigator database. The IBM Content Navigator Configuration and Deployment Tool requires that you enter values that are prepared in advance. The worksheet is a useful place to put these values.
Print this worksheet and enter values as you prepare for your installation.
Parameter | Description | Value |
---|---|---|
JDBC driver | The JDBC driver that corresponds to the type of database where you will store IBM Content Navigator configuration data. IBM Content
Navigator supports
the following JDBC drivers:
Remember: You must copy the
JDBC driver for your database to the IBM Content
Navigator server.
In addition, if you are deploying on Oracle WebLogic Server, you must add the JDBC driver class path to the Oracle WebLogic Server startup script. For more information, see Preparing Oracle WebLogic Server for IBM Content Navigator. |
Microsoft JDBC Driver |
JDBC driver version | The version of the JDBC driver that is installed on the IBM Content Navigator database server. | |
JDBC data source name | The name of the non-XA
JDBC data source that you want to create to communicate with the IBM Content
Navigator database. The name
must be unique and cannot contain spaces. The default name is ECMClientDS. You cannot run this task if the data source name exists on your web application server. It is recommended that you remove the existing data source by using your application server administration tools before you run this task. |
|
Database host name | The short name, long name, or the IP address of the server where the IBM Content Navigator database software is installed. | |
Database port | The port number that is used by the database instance where you will create the IBM Content Navigator database table. The default port is 1433. | |
Database name | The name of the database that you created to store the IBM Content Navigator configuration data and user preferences. This is the database where you want to create the IBM Content Navigator configuration table. You must specify an existing database. | |
Database user name | The name of the database users
that the IBM Content
Navigator data
source will use to connect to the database. The user must be an SQL server user with rights to the database. |
|
Database user password | The password of the specified database user. | |
IBM Content Navigator administrator | The name of the user that you want to use as the IBM Content
Navigator administrator. Important: This user must be an existing web application server user name or LDAP
user name.
This parameter is the ECMClient_ADMINID parameter in the database script, MSSQL_ONE_SCRIPT.sql. |
|
IBM Content Navigator schema name | The name that you want to use for the schema when you
create the IBM Content
Navigator database table. See
your database documentation for naming restrictions. This parameter is the ECMClient_SCHEMA parameter in the database script, MSSQL_ONE_SCRIPT.sql. |
|
JDBC directory | The directory where you installed
the JDBC driver files on your IBM Content
Navigator server. If you plan to deploy IBM Content Navigator in a highly available cluster, you must copy the driver files to the same directory on each node in the cluster. |
|
JDBC configuration script | The fully qualified
path of the JDBC data source configuration script. The name of the
script depends on the web application server you are using:
|
|
Current database configuration | Specify whether your database has already been configured for IBM Content Navigator or not. | |
Run the script to build and populate the database | You can use the IBM Content
Navigator Configuration and Deployment
Tool to run the script that is generated by this task on your database
server. When you run this script, it creates the objects that you identified in this task on the database and populates the database with the default configuration. If you do not select this option, you must manually run the updated script on your database server to create the IBM Content Navigator configuration table on your database instance. You must complete this step after you deploy the web application but before you administer the web client. Specify whether this option applies to your environment. |
|
Enable database connection validation | You can enable connection
validation (WebSphere Application
Server) or
automatic connection testing (Oracle WebLogic Server)
on the data source to decrease the likelihood of the web client encountering
a connection failure to the database. For more information on connection validation and automatic connection testing, see your web application server documentation. Specify whether this option applies to your environment. Note: This description is different from the description
in the IBM Content
Navigator Configuration
and Deployment Tool. Refer to this description when completing the
task.
|