Content Management Service
The Content Management Service manages reference data for data domains that use reference tables. It uses the Data Integration Service to run mappings to transfer data between reference tables and external data sources. When you create the service, you need to associate other application services with it.
The following table summarizes the dependencies for products, services, and databases that are associated with the Content Management Service:
Dependency | Summary |
|---|
Products | The following products use the Content Management Service: - - Big Data Quality
- - Enterprise Data Catalog
- - Enterprise Data Lake
|
Services | The Content Management Service requires a direct association with the following services: - - Model Repository Service
- - Data Integration Service
|
Databases | The Content Management Service uses the following database: - - Reference data warehouse. Stores data values for the reference table objects that you define in the Model repository. When you add data to a reference table, the Content Management Service writes the data values to a table in the reference data warehouse.
|
Installer | You can create the Content Management Service when you install Enterprise Data Catalog. |
Rules and Guidelines
Consider the following rules and guidelines for Content Management Service creation:
- •You must create the Content Management Service on the same node as the Data Integration Service.
Reference Data Warehouse Requirements
The reference data warehouse stores the data values for reference table objects that you define in a Model repository. You configure a Content Management Service to identify the reference data warehouse and the Model repository.
You associate a reference data warehouse with a single Model repository. You can select a common reference data warehouse on multiple Content Management Services if the Content Management Services identify a common Model repository. The reference data warehouse must support mixed-case column names.
The reference data warehouse supports the following database types:
- •IBM DB2 UDB
- •Microsoft SQL Server
- •Oracle
Allow 200 MB of disk space for the database.
Note: Ensure that you install the database client on the machine on which you want to run the Content Management Service.
IBM DB2 Database Requirements
Use the following guidelines when you set up the repository on IBM DB2:
- •Verify that the database user account has CREATETAB and CONNECT privileges.
- •Verify that the database user has SELECT privileges on the SYSCAT.DBAUTH and SYSCAT.DBTABAUTH tables.
- •Informatica does not support IBM DB2 table aliases for repository tables. Verify that table aliases have not been created for any tables in the database.
- •Set the tablespace pageSize parameter to 32768 bytes.
- •Set the NPAGES parameter to at least 5000. The NPAGES parameter determines the number of pages in the tablespace.
Microsoft SQL Server Database Requirements
Use the following guidelines when you set up the repository on Microsoft SQL Server:
- •Verify that the database user account has CONNECT and CREATE TABLE privileges.
Oracle Database Requirements
Use the following guidelines when you set up the repository on Oracle:
- • Verify that the database user has the following privileges:
- - ALTER SEQUENCE
- - ALTER TABLE
- - CREATE SEQUENCE
- - CREATE SESSION
- - CREATE TABLE
- - CREATE VIEW
- - DROP SEQUENCE
- - DROP TABLE
- •Informatica does not support Oracle public synonyms for repository tables. Verify that public synonyms have not been created for any tables in the database.