Worksheet for creating the data source and updating the database script for your Oracle or Oracle SSL database

Work with your Oracle or Oracle SSL 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 Oracle or Oracle SSL 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.

Use this worksheet when you do the following configuration and deployment tasks in the IBM Content Navigator Configuration and Deployment Tool:

Update and Run the Database Script for Your Environment
Creating a Data Source for Your Database

Restriction: The IBM Content Navigator Configuration and Deployment Tool does not allow you tp specify the following information:

The location of the datafile table space
The location of the tempfile table space

If these table spaces need to be created in a specific location on the database server, work with your Oracle database server administrator to modify and manually run the script on the database server. Do not run the script from the IBM Content Navigator Configuration and Deployment Tool.

Table 1. Parameters required by the IBM Content Navigator Configuration and Deployment Tool to create a data source for your Oracle database
Parameter	Description	Value
JDBC driver	The JDBC driver that corresponds to the type of database where you store IBM Content Navigator configuration data. IBM Content Navigator supports the following JDBC drivers: DB2® Universal JDBC Driver DB2 for z/OS® Universal JDBC Driver (available on WebSphere® Application Server only) DB2 Universal JDBC Driver (pureScale or HADR) (available on WebSphere Application Server only) Microsoft JDBC Driver Oracle JDBC Driver Oracle JDBC Driver (RAC support) Oracle JDBC Driver (SSL enabled) (available on WebSphere Application Server only) 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 components.	Oracle JDBC Driver or Oracle JDBC Driver (SSL enabled)
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.
Oracle service name enabled	Enables the Oracle pluggable database by building the correct JDBC URL. This allows an administrator to create the data source on the application server as well as the tables and database data. Oracle 12.1.0.2 Container Databases (CDB) and Pluggable Databases (PDB) are supported. When using these types of Oracle databases, use the Oracle Service Name and not the Oracle Service ID when specifying a JDBC connection in the IBM Content Navigator Configuration Manager (CMUI).
Database port	The port number that is used by the database instance where you create the IBM Content Navigator database table. The default port is 1521.
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 uses to connect to the database. The user must be a table space owner.
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.
Table space name	The name of the table space that you want to create on the IBM Content Navigator configuration database. This parameter is the ECMClient_TBLSPACE parameter in the database script, ORACLE_ONE_SCRIPT.sql. The table space name is also used for the following parameters: The name of the datafile is ECMClient_TBLSPACE The name of the tempfile is ECMClient_TBLSPACE@TEMP You might need to create the datafile table space or the tempfile table space in a specific location on the database server. Work with your Oracle database server administrator to modify and manually run the script on the database server.
Oracle JDBC driver	The oracle JDBC driver. Select the package from the menu.
(V3.0.10 iFix1 and later) SSL KeyStore or Oracle Wallet File Location	The directory location of the SSL KeyStore or Oracle Wallet file. (For WebSphere Application Server only.)
(V3.0.10 iFix1 and later) SSL KeyStore Type	Enter the KeyStore or Wallet type, which is based on the KeyStore or Wallet path that is specified in the SSL KeyStore/Oracle Wallet. An example is `JKS` or `PKCS12`. (For WebSphere Application Server only.)
(V3.0.10 iFix1 and later) SSL KeyStore Password	The password of the specified SSL KeyStore.(For WebSphere Application Server only.)
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: On Oracle WebLogic Server, the script is configureWLJDBC.py. On WebSphere Application Server, the script is configureWSJDBC.tcl. On AIX®, the default directory is /opt/IBM/ECMClient/configure/scripts/`script_name`. On Linux®, the default directory is /opt/IBM/ECMClient/configure/scripts/`script_name`. On Linux for System z®, the default directory is /opt/IBM/ECMClient/configure/scripts/`script_name`. On Windows, the default directory is C:\Program Files (x86)\IBM\ECMClient\configure\scripts\`script_name`.
Current database configuration	Specify whether your database is already 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 from encountering a connection failure to the database. For more information about 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 you complete the task.