Table of Contents

Search

  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

Databases in the Hub Store

Databases in the Hub Store

The
Hub Store
is a collection of databases that includes:
Element
Description
Master Database
Contains the
Informatica MDM Hub
environment configuration settings—user accounts, security configuration,
Operational Reference Store
registry, message queue settings, and so on. A given
Informatica MDM Hub
environment can have only one
Master Database
. The default name of the
Master Database
is CMX_SYSTEM.
In the
Hub Console
, the tools in the Configuration workbench (Databases, Users, Security Providers, Tool Access, and Message Queues) manage configuration settings in the
Master Database
.
Operational Reference Store
(
Operational Reference Store
)
Database that contains the master data, content metadata, the rules for processing the master data, the rules for managing the set of master data objects, along with the processing rules and auxiliary logic used by the
Informatica MDM Hub
in defining the best version of the truth (BVT). An 
Informatica MDM Hub
configuration can have one or more ORS databases. The default name of an
Operational Reference Store
is CMX_ORS.
Users for
Hub Store
databases are created globally—within the
Master Database
—and then assigned to specific
Operational Reference Store
s. The
Master Database
also stores site-level information, such as the number of incorrect log-in attempts allowed before a user account is locked out.

0 COMMENTS

We’d like to hear from you!