Table of Contents

Search

  1. Preface
  2. Part 1: Installation Getting Started
  3. Part 2: Before You Install the Services
  4. Part 3: Run the Services Installer
  5. Part 4: After You Install the Services
  6. Part 5: Informatica Client Installation
  7. Part 6: Uninstallation
  8. Appendix A: Starting and Stopping Informatica Services
  9. Appendix B: Managing Distribution Packages
  10. Appendix C: Connecting to Databases from UNIX or Linux
  11. Appendix D: Connecting to Databases from Windows
  12. Appendix E: Updating the DynamicSections Parameter of a DB2 Database

Installation for PowerCenter and Data Quality

Installation for PowerCenter and Data Quality

Model Repository Database Requirements

Model Repository Database Requirements

Informatica services and clients store data and metadata in the Model repository. Configure a monitoring Model repository to store statistics for ad hoc jobs, applications, logical data objects, SQL data services, web services, and workflows. Before you create the Model Repository Service, set up a database and database user account for the Model repository. It is recommended that you use different database configuration for Model repository and monitoring Model repository.
The Model repository supports the following database types:
  • IBM DB2 UDB
  • Microsoft SQL Server
  • Microsoft Azure SQL Database
  • Oracle
  • PostgreSQL
When you configure Microsoft SQL Server, you can choose to configure the Microsoft Azure SQL Database as the Model repository.
If you specify the Windows NT credentials for the Model repository database on Microsoft SQL Server, you must also specify the connection string syntax to include the authentication method as NTLM.
Allow 3 GB of disk space for DB2. Allow 200 MB of disk space for all other database types.
For more information about configuring the database, see the documentation for your database system.

0 COMMENTS

We’d like to hear from you!