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

About the Schema

About the Schema

The schema is the data model that is used in the MDM Hub implementation.
The MDM Hub does not impose or require any particular schema. The schema exists inside the MDM Hub and is independent of the source systems providing data to the MDM Hub.
The process of schema design for your MDM Hub implementation is outside the scope of this document. It is assumed that you have developed a data model, using industry-standard data modeling methodologies, which caters to the requirements of your organization.
schema is a flexible, repository-driven model that supports the data structure of any vertical business sector. The
Hub Store
is the database that underpins the MDM Hub functionality. Every MDM Hub installation has a
Hub Store
, which includes one
MDM Hub Master Database
and one or more
Operational Reference Store
databases. Based on the configuration of your system, you can have multiple
Operational Reference Store
databases in an installation. For example, you could have a development
Operational Reference Store
, a testing
Operational Reference Store
, and a production
Operational Reference Store
Before you begin to implement the schema, you must understand the basic structure of the underlying MDM Hub schema and the components that comprise it.
You must use
Hub Console
tools to define and manage the consolidated schema. You cannot make changes directly to the database. For example, you must use the Schema Manager to define tables and columns.


We’d like to hear from you!