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

Verify Database Requirements

Verify Database Requirements

Verify that the database server has adequate disk space for the domain configuration repository and for the other databases required by the application services.
The following table describes the database requirements for the domain configuration repository and for the other databases required by the application services:
Database
Requirements
Informatica domain configuration repository
The domain configuration repository supports the following database types:
  • IBM DB2 UDB
  • Microsoft SQL Server
  • Microsoft Azure SQL Database
  • Oracle
  • Sybase ASE
Allow 200 MB of disk space for the database.
Data object cache database
The data object cache database supports the following database types:
  • IBM DB2 UDB
  • Microsoft SQL Server
  • Microsoft Azure SQL Database
  • Oracle
Allow 200 MB of disk space for the database.
Allocate more space based on the amount of data you want to cache.
Metadata Manager repository
The Metadata Manager repository supports the following database types:
  • IBM DB2 UDB
  • Microsoft SQL Server
  • Microsoft Azure SQL Database
  • Oracle
Allow 1 GB of disk space for the database.
Model repository
The Model repository supports the following database types:
  • IBM DB2 UDB
  • Microsoft SQL Server
  • Microsoft Azure SQL Database
  • Oracle
Allow 3 GB of disk space for DB2. Allow 200 MB of disk space for all other database types.
Allocate more space based on the amount of metadata you want to store.
PowerCenter repository
The PowerCenter repository supports the following database types:
  • IBM DB2 UDB
  • Microsoft SQL Server
  • Microsoft Azure SQL Database
  • Oracle
  • Sybase ASE
Allow 35 MB of disk space for the database.
Allocate more space based on the amount of metadata you want to store.
Profiling warehouse
The profiling warehouse supports the following database types:
  • IBM DB2 UDB
  • Microsoft SQL Server
  • Microsoft Azure SQL Database
  • Oracle
Allow 10 GB of disk space for the database.
Reference data warehouse
The reference data warehouse supports the following database types:
  • IBM DB2 UDB
  • Microsoft SQL Server
  • Microsoft Azure SQL Database
  • Oracle
Allow 200 MB of disk space for the database.
Workflow database
The workflow database supports the following database types:
  • IBM DB2 UDB
  • Microsoft SQL Server
  • Microsoft Azure SQL Database
  • Oracle
Allow 200 MB of disk space for the database.
Allocate space based on the amount of metadata you want to store.