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.
The workflow database stores run-time metadata for workflows using the Data Integration Service.
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.