PowerCenter Repository Service Overview
A PowerCenter repository is a collection of database tables that contains metadata. A PowerCenter Repository Service manages the PowerCenter repository. It performs all metadata transactions between the PowerCenter repository database and PowerCenter repository clients.
Create a PowerCenter Repository Service to manage the metadata in repository database tables. Each PowerCenter Repository Service manages a single repository. You need to create a unique PowerCenter Repository Service for each PowerCenter repository in a Informatica domain.
Creating and configuring a PowerCenter Repository Service involves the following tasks:
- •Create a database for the repository tables. Before you can create the repository tables, you need to create a database to store the tables. If you create a PowerCenter Repository Service for an existing repository, you do not need to create a new database. You can use the existing database, as long as it meets the minimum requirements for a repository database.
- •Create the PowerCenter Repository Service. Create the PowerCenter Repository Service to manage the repository. When you create a PowerCenter Repository Service, you can choose to create the repository tables. If you do not create the repository tables, you can create them later or you can associate the PowerCenter Repository Service with an existing repository.
- •Configure the PowerCenter Repository Service. After you create a PowerCenter Repository Service, you can configure its properties. You can configure properties such as the error severity level or maximum user connections.
Based on your license, the PowerCenter Repository Service can be highly available.