Table of Contents

Search

  1. Installation Overview
  2. Before You Install the Services
  3. Service Installation
  4. After You Install the Services
  5. Client Installation
  6. Uninstallation
  7. Starting and Stopping Informatica Services
  8. Connecting to Databases from Windows
  9. Connecting to Databases from UNIX
  10. Updating the DynamicSections Parameter of a DB2 Database
  11. Installation and Configuration Checklist
  12. Split Domain Configuration for Metadata Manager

Installation and Configuration Guide

Installation and Configuration Guide

Prepare Databases for the Informatica Domain

Prepare Databases for the Informatica Domain

To prepare the databases for the Informatica domain, perform the following tasks:
  • Set up a database and user account for the domain configuration repository and for the repository databases associated with the application services.
  • Verify the database requirements for the databases that you need:
    • Domain configuration repository. Stores configuration and user information in a domain configuration repository.
    • Data object cache database. Stores cached logical data objects and virtual tables for the Data Integration Service.
    • Exception management audit database. Stores data that describes the work that Analyst tool users perform on Human task instances.
    • Metadata Manager repository. Stores the Metadata Manager warehouse and models.
    • Model repository. Stores data and metadata corresponding to Informatica services and clients.
    • PowerCenter repository. Stores a collection of database tables that contain metadata.
    • Profiling warehouse. Stores profiling and scorecard results.
    • Reference data warehouse. Stores the data values for reference table objects that you define in a Model repository.
    • Workflow database. Stores run-time metadata for workflows.
  • Install the database clients on the machine where each service runs based on the databases that the service accesses.
  • Configure database client environment variables on the machines that run the following services:
    • Data Integration Service
    • PowerCenter Integration Service
    • PowerCenter Repository Service