Table of Contents


  1. Introduction
  2. Configuring Hub Console Tools
  3. Building the Data Model
  4. Configuring the Data Flow
  5. Executing Informatica MDM Hub Processes
  6. Configuring Application Access
  7. MDM Hub Properties
  8. Viewing Configuration Details
  9. Search with Solr
  10. Row-level Locking
  11. MDM Hub Logging
  12. Table Partitioning
  13. Collecting MDM Environment Information with the Product Usage Toolkit
  14. Glossary

Operational Reference Store Connection Properties for Oracle

Operational Reference Store Connection Properties for Oracle

When you register an
Operational Reference Store
on Oracle, configure the following connection properties:
Database Display Name
Name for the
Operational Reference Store
that must appear in the
Hub Console
Machine Identifier
Prefix given to keys to uniquely identify records from the Hub Store instance.
Database hostname
IP address or name of the server that hosts the
Microsoft SQL Server
Oracle System Identifier that refers to the instance of the Oracle database running on the server. This field appears if you selected the
connection type.
Name of the Oracle service used to connect to the Oracle database. This field appears if the you selected the
connection type.
The TCP port of the Oracle listener running on the Oracle database server. The default is 1521.
Oracle TNS Name
Name by which the database is known on your network as defined in the
file of the application server.
For example:
You set the Oracle TNS name when you install the Oracle database. For more information about the Oracle TNS name, see the Oracle documentation.
Schema Name
Name of the
Operational Reference Store
Schema Name
and the
User Name
are both the names of the
Operational Reference Store
that you specified when you creates the
Operational Reference Store
. If you need this information, consult your database administrator.
Password associated with the user name for the
Operational Reference Store
For Oracle, this password is not case sensitive.
By default, this is the password that you specify when you create the
Operational Reference Store
DDM connection URL
Optional. URL for the
Dynamic Data Masking
server. Leave empty if you do not use
Dynamic Data Masking
You can also configure the following additional properties on the
Connection URL
Connect URL. The Connection Wizard generates the connect URL by default. The following examples show the format of the connect URL:
Service connection type:
SID connection type:
You can specify a custom URL of a service connection type. Example:
Create datasource after registration
Select to create the datasource on the application server after registration.
If you do not select the option, you must manually configure the data source.


We’d like to hear from you!