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

Configuring a Unicode Database (Oracle Only)

Configuring a Unicode Database (Oracle Only)

If you use Oracle databases in your MDM Hub implementation, you must configure the character set that you want to use. If your implementation uses mixed locale information, such as data from multiple countries with different character sets, you must configure the MDM Hub and the database to use Unicode Transfer Format (UTF-8) encoding. However, if the database contains data from a single locale, a UTF-8 database is probably not required.
  1. Create a UTF-8 database and choose the following settings:
    • database character set
      : AL32UTF8
    • national character set
      : AL16UTF16
    Oracle recommends to use AL32UTF8 as the database character set for Oracle 10g. For information about the previous Oracle releases, refer to the Oracle documentation.
  2. On both the server and the client, set
    to match the database character set.
    For example, if you are in the United States, set NLS_LANG to the following value:
    However, if you have a Japanese implementation, set NLS_LANG to the following value:
  3. Ensure that you configure regional font settings on the client.
    For example, if the data is from China, install Chinese fonts.
  4. If you use a multi-byte character set, to support Unicode values, change the following setting in the C_REPOS_DB_RELEASE table:
    column_length_in_bytes_ind = 0


We’d like to hear from you!