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

Databases

Databases

When you plan the Informatica domain, you also need to plan the required relational databases. The domain requires a database to store configuration information and user account privileges and permissions. Some application services require databases to store information processed by the application service.

Domain

Use the following table to record the database information that you need for the domain:
Database Information
Description
Value
Domain configuration database type
Database type for the domain configuration repository.
The domain configuration repository supports IBM DB2 UDB, Microsoft SQL Server, Oracle, or Sybase ASE.
Domain configuration database host name
The name of the machine hosting the database.

Content Management Service

Use the following table to record the database information that you need for the Content Management Service:
Database Information
Description
Value
Reference data warehouse database type
Database type for the reference data warehouse.
The reference data warehouse supports IBM DB2 UDB, Microsoft SQL Server, or Oracle.
Reference data warehouse database host name
The name of the machine hosting the database.

Data Integration Service

Use the following table to record the database information that you need for the Data Integration Service:
Database Information
Description
Value
Data object cache database type
Database type for the data object cache database.
The data object cache database supports IBM DB2 UDB, Microsoft SQL Server, or Oracle.
Data object cache database host name
The name of the machine hosting the database.
Profiling warehouse database type
Database type for the profiling warehouse.
The profiling warehouse supports IBM DB2 UDB, Microsoft SQL Server, or Oracle.
Profiling warehouse database host name
The name of the machine hosting the database.
Workflow database type
Database type for the workflow database.
The workflow database supports IBM DB2 UDB, Microsoft SQL Server, or Oracle.
Workflow database host name
The name of the machine hosting the database.

Metadata Manager Service

Use the following table to record the database information that you need for the Metadata Manager Service:
Database Information
Description
Value
Metadata Manager repository database type
Database type for the Metadata Manager repository.
The Metadata Manager repository supports IBM DB2 UDB, Microsoft SQL Server, or Oracle.
Metadata Manager repository database host name
The name of the machine hosting the database.

Model Repository Service

Use the following table to record the database information that you need for the Model Repository Service:
Database Information
Description
Value
Model repository database type
Database type for the Model repository.
The Model repository supports IBM DB2 UDB, Microsoft SQL Server, or Oracle.
Model repository database host name
The name of the machine hosting the database.

PowerCenter Repository Service

Use the following table to record the database information that you need for the PowerCenter Repository Service:
Database Information
Description
Value
PowerCenter repository database type
Database type for the PowerCenter repository.
The PowerCenter repository supports IBM DB2 UDB, Microsoft SQL Server, Oracle, or Sybase ASE.
PowerCenter repository database host name
The name of the machine hosting the database.