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 Properties

Operational Reference Store Properties

Properties of the
Operational Reference Store
databases include database vendor and version, as well as information from the C_REPOS_DB_RELEASE table.
The following list describes the
Operational Reference Store
properties that appear in the
Enterprise Manager
Database Product Name
Name of your database system.
Database Product Version
Database version used.
Environment ID
The environment ID.
TNS Name
TNS name of the
Operational Reference Store
Connect URL
URL to connect to the
Operational Reference Store
Database ID
The database ID.
Time difference between systems
Delta-detection value, in seconds, which determines if the incoming data is in the future.
Column length in bytes
For Oracle environments.
Used by SQL*Loader to determine if the database it is loading into is a UTF-8 database.
The default value is 1, which means that the database is UTF-8.
Load template
environments. The path on the database server for log files that the db2 load command generates when you are in logging mode.
MTIP regeneration required
If set to
, it indicates that the MTIP views will be regenerated before the match/ merge process.
The default value is
, which means that views will not be regenerated.
The Regenerate MTIPs button of the
Enterprise Manager
tool lets you regenerate MTIP views.
You must not regenerate MTIP views when the ORS is in production mode. Switch off production mode setting before trying to regenerate MTIPs from the
Enterprise Manager
Global no logging
For Oracle and IBM DB2 environments. This is used when tables are created to enable logging for database recovery. The default value is
, which means no logging.
Model Repository Service URL
Connection parameters that the
requires to connect to the Model Repository Service. You specify the connection parameters in the
Enterprise Manager


We’d like to hear from you!