PowerCenter - Repository Service (Process)

Card Puncher Data Processing


The Repository Service manages connections to the repository from client applications.

The Repository Service is a separate, multi-threaded process that retrieves, inserts, and updates metadata in the repository database tables.



From the PowerCenter - Administration Console:

Powercenter Repository Service


You install the Repository Service when you install PowerCenter - Services. After you install the PowerCenter Services, you can use the PowerCenter - Administration Console to manage the Repository Service.

Operating Mode

Powercenter Repository Service Operating Mode

To switch a Repository Service from Normal to Exclusive mode and vice versa, you can use the infacmd command updateRepositoryService.

  • Disable the repository service using infacmd DisableService
infacmd.sh DisableService -dn Domain_name -un user_name -pd password -sn repository_name -mo Abort
  • Update the Repository Service to Exclusive using UpdateRepositoryService
infacmd.sh updateRepositoryService -dn Domain_name -un user_name -pd password -sn repository_name  -so OperatingMode=Exclusive
  • And switch to normal mode using Operating Mode as Normal.
infacmd.sh updateRepositoryService -dn Domain_name -un user_name -pd password -sn repository_name  -so OperatingMode=Normal


The Repository Service accepts connection requests from the following PowerCenter applications:

  • PowerCenter - Client. Use the Designer and Workflow Manager to create and store mapping metadata and connection object information in the repository. Use the Workflow Monitor to retrieve workflow run status information and session logs written by the Integration Service. Use the Repository Manager to organize and secure metadata by creating folders, users, and groups.
  • pmrep command line to perform repository metadata administration tasks and service-related functions.
  • PowerCenter - Integration Service. When you start the Integration Service, it connects to the repository to schedule workflows. When you run a workflow, the Integration Service retrieves workflow task and mapping metadata from the repository. The Integration Service writes workflow status to the repository.
  • PowerCenter - Web Services Hub. When you start the Web Services Hub, it connects to the repository to access web-enabled workflows. The Web Services Hub retrieves workflow task and mapping metadata from the repository and writes workflow status to the repository.
  • Powercenter - Sap BW service. Listens for RFC requests from SAP NetWeaver BW and initiates workflows to extract from or load to SAP BW.

Discover More
Powercenter Component
PowerCenter - Architecture/Components

Architecture for 8.x version of Informatica PowerCenter. PowerCenter provides an environment that allows you to load data into a centralized location, such as a data warehouse or operational data store...
Card Puncher Data Processing
PowerCenter - Changes in Informatica Terminology (Term used)

in 7.1.x versions of Informatica PowerCenter in 8.x version of Informatica PowerCenter Informatica Repository Informatica Repository The Informatica Repository is managed by the Repository Service....
Edlivery Oracle Bi
PowerCenter - Installation and Configuration (8.6.1 for Windows 32Bit)

This article talk the installation of PowerCenter from Informatica on: Windows 32 bit Oracle Database Oracle Business Intelligence Application version installation The oracle database...
Powercenter Integration Service
PowerCenter - Integration Service

The PowerCenter Integration Service is an application service that runs workflows and sessions for the PowerCenter Client. The Integration Service reads workflow information from the repository. The...
Powercenter Log
PowerCenter - Logging

The Service Manager provides accumulated log events from each service in the domain. You can view logs in: the Administration Console and the Workflow Monitor. PowerCenter_Home\server\infa_shared\SessLogs...
Powercenter Repository Adminconsole
PowerCenter - Repository

A repository is a logic unit of a domain. The repository contains the instructions required to: extract, transform, and load data and store administrative information such as : permissions,...
Powercenter 901 Installation Port Configuration
PowerCenter - Services

Informatica Cluster Service ICS_ The port number you specify for the domain and for each component in the domain must be unique. The port number for the domain and domain components cannot be within...
Card Puncher Data Processing
PowerCenter - User and Group

With the Administration Console, you normally perform the following tasks: Create a group with all privileges on a Repository Service. The privileges allow users in to design mappings and run workflows...
Powercenter Workflow Monitor
PowerCenter - Workflow Monitor

You can monitor workflows and tasks in the Workflow Monitor. You can view details a or task in Gantt Chart view or Task view. You can : run, stop, abort, and resume workflows from the...

Share this page:
Follow us:
Task Runner