In this section, you configure four database connections, one each for Publishing, Switching A, Switching B, and Production schemas.
To configure your database connections:
In the CIM MAIN MENU, select [1] Database Configuration.
In the SELECT A DATASOURCE TO CONFIGURE menu, select [P] Publishing.
In the CONFIGURE DATASOURCE PUBLISHING menu, select [C] Connection Details.
In the ENTER CONNECTION DETAILS menu, select your database type.
Enter the following information for the database account you want to use for the Publishing schema:
User name
Password
Re-enter password
Host name
Port number
Database name
Database URL
Note: CIM will provide a Database URL for you, based on the information that you have already entered.
Driver path
JNDI name
Note: CIM provides a default JNDI name of
ATGPublishingDSfor the Publishing schema.(DB2 Only) Driver license path
In the CONFIGURE DATASOURCE PUBLISHING menu, select [T] Test Connection.
CIM tests the connection to verify that it is healthy.
In the CONFIGURE DATASOURCE PUBLISHING menu, select [S] Create Schema.
In the CREATE SCHEMA menu, select [C] Create Schema.
In the CONFIGURE DATASOURCE PUBLISHING menu, select [I] Import Initial Data.
In the IMPORT DATA menu, select [I] Import Data.
Enter a password for the merchandising user, for example,
Merch123.Re-enter the merchandising user password.
Enter a password for the publishing admin user, for example,
Admin123.Re-enter the publishing admin user password.
Data importing begins for the publishing schema. Note that this process can take time, depending on your environment.
In the CONFIGURE DATASOURCE PUBLISHING menu, select [O] Configure Another Datasource.
In the SELECT A DATASOURCE TO CONFIGURE menu, select [C] Production Core.
In the CONFIGURE DATASOURCE PRODUCTION CORE menu, select [C] Connection Details.
In the RE-USE VALUES FROM PREVIOUS DATASOURCE menu, select [2] None/Use Existing.
In the ENTER CONNECTION DETAILS menu, select your database type.
Enter the connections details for the database account you want to use for the Production Core schema. The default JNDI name that CIM provides for the Production Core schema is
ATGProductionDS.In the CONFIGURE DATASOURCE PRODUCTION CORE menu, select [T] Test Connection.
CIM tests the connection to verify that it is healthy.
In the CONFIGURE DATASOURCE PRODUCTION CORE menu, select [S] Create Schema.
In the CREATE SCHEMA menu, select [C] Create Schema.
In the CONFIGURE DATASOURCE PRODUCTION CORE menu, select [I] Import Initial Data.
In the IMPORT DATA menu, select [I] Import Data.
Repeat steps 15 to 25 for the remaining two datasources. Be sure to configure the datasources in this order:
[S] Switching A
[B] Switching B
In the CONFIGURE DATASOURCE SWITCHING B menu, select [O] Configure Another Datasource.
In the SELECT A DATASOURCE TO CONFIGURE menu, select [D] Done.
Continue with the section Configuring Your Oracle Commerce Platform Server Instances.
