Table of Contents

Search

  1. Preface
  2. Part 1: Installation Getting Started
  3. Part 2: Before You Install the Services
  4. Part 3: Run the Services Installer
  5. Part 4: After You Install the Services
  6. Part 5: Informatica Client Installation
  7. Part 6: Uninstallation
  8. Appendix A: Starting and Stopping Informatica Services
  9. Appendix B: Connecting to Databases from UNIX or Linux
  10. Appendix C: Connecting to Databases from Windows
  11. Appendix D: Updating the DynamicSections Parameter of a DB2 Database

Installation for PowerCenter and Data Quality

Installation for PowerCenter and Data Quality

Databases

Databases

Some application services require databases to store metadata and to write run-time results. You need to create databases for the application services in the domain.
You can create the following databases:
Domain configuration repository database
The domain configuration repository stores configuration and user information from a domain.
Reference data warehouse database
The reference data warehouse stores the data values for reference table objects that you define in a Model repository. Configure a Content Management Service to identify the reference data warehouse and the Model repository.
Data object cache database
The data object cache stores cached logical data objects and virtual tables for the Data Integration Service. Data object caching enables the Data Integration Service to access pre-built logical data objects and virtual tables.
Profiling warehouse database
The profiling warehouse stores profiling and scorecard results. You need a profiling warehouse to perform profiling and data discovery.
Workflow database
The workflow database stores run-time metadata for workflows using the Data Integration Service.
Metadata Manager repository database
The Metadata Manager repository is a centralized location in a relational database that stores metadata from disparate metadata sources. It also stores the Metadata Manager warehouse and the models for each metadata source type.
Model repository database
The Model repository stores data and metadata from the Informatica services and clients. Informatica client tools, such as Analyst tool and the Developer tool stores the data into the Model repository.
Monitoring Model repository database
The Monitoring Model repository stores statistics for ad hoc jobs, applications, logical data objects, SQL data services, web services, and workflows created by Informatica clients and application services.
PowerCenter repository database
The PowerCenter repository stores data and metadata from the PowerCenter services and clients. The PowerCenter Repository Service manages the repository and performs all metadata transactions between the repository database and repository clients.
You need to create databases and database users required by application services.