In this section, you configure five database connections, one each for the Publishing, Staging, Production Core, Switching A, and Switching B schemas.
To configure your database connections:
In the CIM MAIN MENU, select [2] 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.
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 [S] Staging.
In the CONFIGURE DATASOURCE STAGING 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 Staging schema. The default JNDI name that CIM provides for the Staging schema is
ATGStagingDS.In the CONFIGURE DATASOURCE STAGING menu, select [T] Test Connection.
CIM tests the connection to verify that it is healthy.
In the CONFIGURE DATASOURCE STAGING menu, select [S] Create Schema.
In the CREATE SCHEMA menu, select [C] Create Schema.
In the CONFIGURE DATASOURCE STAGING menu, select [I] Import Initial Data.
In the IMPORT DATA menu, select [I] Import Data.
Repeat steps 15 to 25 for the remaining datasources. Be sure to configure the datasources in this order:
[C] Production Core
[A] 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 and Creating the EAC Applications.
