You
must create JDBC data sources for each database that Case Analyzer uses if the Case Analyzer store is not in the same
database as the object store. Otherwise, Case Analyzer can use the existing data
sources for the object store and you can skip this topic. Content Platform Engine and the caupgrade tool
use this data source information to connect to and update the database.
Be sure that you have available
the Installation and Upgrade Worksheet that was completed during your
planning activities.
To configure the JDBC settings for Case Analyzer databases:
- Open your completed Installation and Upgrade Worksheet
file.
Tip: In
the worksheet file, verify that the command is enabled. To view only Content Platform Engine values, filter by CM:Configure
Object Store JDBC Data Sources (object store 1). in the Installation
or Configuration Program column.
- If your configuration profile is not open in
Configuration Manager, open it by selecting and navigating to your profilename.cfgp file.
- Create a task for the Case Analyzer JDBC
data source.
Tip: If the Case Analyzer database data sources you
are creating share common information such as database server and
port, you can copy an existing Configure Object Store JDBC Data Sources
task and edit it instead of entering the information again.
- Right-click any task name in
the profile pane, such as Configure Object Store JDBC Data
Sources, and select . The New_Configure JDBC Data Sources task
is added to the profile.
- Right-click New_Configure JDBC Data Sources,
and select Rename Task.
- Enter a useful name for the task, such as Configure Case Analyzer database 2 JDBC
Data Sources.
- Click OK.
- Right-click the Configure Case Analyzer
database 2 JDBC Data Sources task in the profile pane,
and select Edit Selected Task.
- Enter the property values for the JDBC data sources that are
appropriate for the database.
- Select to save your changes.
- Optional: WebSphere® and WebLogic only. Click Test
Database Connection to test the connection to the database
by using the database user name, database server name, database name,
port number, and password that you provided. The test
does not create the data sources.
- Ensure that the task is enabled. When the task
is disabled, the task name includes the text (disabled).
To enable the task, right-click Configure Case Analyzer
2 JDBC Data Sources (disabled) in the profile pane, and
choose Enable Selected Task from the context
menu.
- Apply the JDBC property settings by right-clicking Configure
database 2 JDBC Data Sources in the profile pane, and
selecting Run Task. Running the
configuration task can take a few minutes. The task execution status
messages are displayed in the Console pane below the bootstrap properties.
- (JBoss only) Start the
application server instance.
- Repeat this procedure to add the data sources for each Case Analyzer database in your environment.