You were redirected to the closest matching page. If this looks correct, please consider bookmarking it for future reference.
Success
Manage your Success Plans and Engagements, gain key insights into your implementation journey, and collaborate with your CSMs
Customer Experience Accelerators
Accelerate your Purchase to Value by engaging with Informatica for Customer Success
My Engagements
All your Engagements at one place
 Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
 Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Experience Lounge
Self-guided, intuitive experience platform for outcome-focused product capabilities and use cases
 Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
SupportFlash
Monthly support newsletter
Product Availability Matrix
Product Availability Matrix statements of Informatica products
Product Lifecycle
End of Life statements of Informatica products
Pulse
Monitor the status of your Informatica services across regions
Events
Change Request Tracking
Marketplace
Trust Platform
English
  • Informatica Data Quality 10.2
  • All Products

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

Back Next

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.
0 COMMENTS
We’d like to hear from you!