Installation and Configuration Guide

Back Next

Create the Operational Reference Store

Create an Operational Reference Store with the schema name

supplier_hub

. When entering database parameters, use the parameters that you specified when you created the Oracle database instance.

You must use the name supplier_hub. If you use a different name, the integration with Product 360 does not work.

Navigate to the following directory:

<MDM installation directory>/hub/server/bin

Run one of the following commands:

On Windows.

sip_ant.bat create_ors

On Linux.

sip_ant.sh create_ors

Enter values for the Operational Reference Store parameters.

The prompts display default text in brackets. Press

Enter

to use the default value and go to the next prompt.

Parameter	Description
Oracle Connection Type	Enter the type that you specified for the Oracle database instance.
Operational Reference Store DB host name	Enter the IP address of the host running Oracle.
Operational Reference Store DB port number	Enter the port number that Oracle uses.
Operational Reference Store DB service name	If the Oracle Connection Type=service, enter the name of the Oracle service that you specified for the Oracle database instance.
Oracle Net connect identifier	Enter the TNS name that you specified for the Oracle database instance.
Connect URL	Use the default URL unless you are required to change the URL for business reasons or technical reasons.
Operational Reference Store DB user name (schema name)	Enter supplier_hub .
Operational Reference Store DB user password	Enter a password to assign to the supplier_hub user.
Locale name	Enter the language to use.
DBA user name	Enter the user name for the Oracle database instance.
DBA password	Enter the password for this user.
MDM index tablespace	Use the default value. Creates a tablespace to contain the index components for the Operational Reference Store.
MDM temporary tablespace	Use the default value. Creates a tablespace to contain the temporary components for the Operational Reference Store.
Oracle temporary tablespace	Use the default value. Creates a tablespace to contain the temporary components for the database instance.