---
description: After installing Informatica server and client, Informatica server needs to be configured. The Informatica architecture is a Service Oriented Architecture (SOA). Therefore, before using Informatica to
title: How to Configure Client and Repository in Informatica
image: https://www.guru99.com/images/configure-informatica-client-repository.png
---

[Skip to content](#main)

**⚡ Smart Summary**

Configuring Informatica PowerCenter after installation means creating the Repository Service, generating repository contents, creating the Integration Service, adding the domain to each client tool, and creating users with domain and repository privileges.

- 🏢 **Domain first:** The Informatica domain is the administrative unit that owns every node, service and user account.
- 🗄️ **Repository Service:** Create it first, backed by a database user that holds connect and resource privileges.
- 📦 **Repository contents:** Contents are the metadata tables, and the service cannot start until they are created once.
- 🔄 **Operating mode:** Switch the Repository Service from exclusive back to normal so developers can connect.
- ⚙️ **Integration Service:** This service locks, fetches and executes workflows, and writes the workflow and session logs.
- 🔐 **Clients and users:** Each client adds the domain by gateway host and port, and every user needs explicit privileges.

Read More

![How to Configure Client and Repository in Informatica](https://www.guru99.com/images/configure-informatica-client-repository.png)

After installing the Informatica server and client, the Informatica server needs to be configured.

The Informatica architecture is a Service Oriented Architecture (SOA). Therefore, before using Informatica tools, the server and client components need to be installed and configured.

Prerequisites to configure clients, the Integration Service and the Repository Service:

- Informatica server and client should be [installed](https://www.guru99.com/install-informatica-powercenter.html).
- Informatica service should be up and running.
- Oracle or another compatible database must be installed, and the database service must be up.
- Database users must be created for the Repository Service.
- Domain administrator console credentials must be available (these are configured during server installation).

The following components need to be set up before you can start working in Informatica PowerCenter.

1. Informatica domain
2. Creating the Repository Service
3. Creating the Integration Service
4. Creating users

## What is an Informatica Domain?

An Informatica Domain is the basic administrative unit for various services and hosts.

Using the domain console you can perform various administrative tasks like adding a node, creating a Repository Service, creating an Integration Service, creating a Reporting Service, managing and creating users, monitoring services, and so on.

During installation of the Informatica server, the system prompts for setting up the domain credentials and database connection. That database is the [domain configuration repository](https://www.guru99.com/informatica-architecture-tutorial.html), which is separate from the PowerCenter repository created below.

You need to use the same credentials when you access the domain console.

## How to Open the Administrator Home Page

**Step 1)** From the program menu, open the Informatica Administrator home page.

[![Informatica Administrator shortcut in the Windows program menu]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig1.png)

This will open up the domain home page in the web browser.

**Troubleshooting** – if the home page does not open up, check whether the Informatica server process and the database service are up and running. If not, start them.

**Step 2)** Enter the domain credentials (these credentials are generated during server installation).

[![Informatica Administrator login page asking for domain user name and password]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig2.png)

**Step 3)** On successful login, the Informatica Administrator home page appears, as shown below.

[![Informatica Administrator home page with the Domain Navigator on the left]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig3.png)

## How to Create the Repository Service

It is the first service that needs to be created in the domain console. The prerequisite is to have a database user created in the database along with basic privileges (connect, resource), as this service maintains repository data in the database. You can create versioned objects in the repository using the enable version control option.

You can select Oracle, DB2, Sybase or [SQL Server](https://www.guru99.com/sql.html) databases to create a repository.

**Step 1)** Start the service creation wizard.

1. Right-click on the domain name
2. Select the new option
3. Select PowerCenter Repository Service.

[![Right-click menu on the domain showing New PowerCenter Repository Service]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig4.png)

**Step 2)** In the next screen:

1. Enter a name for the repository
2. Select the license
3. Select the node
4. Click on the Next button

[![New PowerCenter Repository Service wizard page for name, license and node]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig5.png)

**Step 3)** In the next screen:

1. Enter the database properties.
2. Select the option – enable version control, if the version control feature is required for Informatica development.
3. Select the finish button.

[![Repository database properties page with database type, user name and connection string]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig6.png)

**Note** – the connection string name is the name of the database instance service name.

**Step 4)** The Repository Service will be created, and will be listed under the domain tree.

[![Newly created PowerCenter Repository Service listed in the domain tree]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig7.png)

**Troubleshooting** – if there is an error during service creation, check whether the correct database credentials are provided, and whether the connection string is correct. After any changes are made to repository properties, recycle the Repository Service to make the changes effective.

## How to Create Repository Contents

After the Repository Service is created, repository contents need to be created (this is a one-time activity for a repository). Without repository contents, you cannot start the Repository Service. Repository content is basically the set of database tables that contains the details of objects created in Informatica.

**Step 1)** Select the Repository Service under the domain tree.

[![Repository Service selected in the Domain Navigator before creating contents]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig8.png)

**Step 2)** After selecting the Repository Service:

1. Select the Actions menu on the right side of the page
2. Select the repository contents option
3. Select the create option

[![Actions menu expanded to Repository Contents and Create]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig9.png)

**Step 3)** In the next screen:

1. Select the options of local/global repository (we are keeping it unchecked to create a local repository)
2. Select version control (if required; we are keeping it unchecked to skip the version control feature)
3. Click OK.

[![Create repository contents dialog with global repository and version control check boxes]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig10.png)

**Step 4)** Once repository content is created, change the Repository Service from exclusive to normal mode.

**Note** – if the Repository Service is in exclusive mode, users would not be able to connect to the repository. Exclusive mode allows a single user at a time, which is what makes creating or deleting contents safe; normal mode is the multi-user state developers connect to.

Select the edit property option of the repository.

[![Edit button on the Repository Service properties panel]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig11.png)

**Step 5)** In the properties dialog:

1. Select the mode from exclusive to normal
2. Select the OK button.

[![Repository Service properties dialog with the operating mode set to Normal]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig12.png)

Once done, the Repository Service will be running in normal mode.

**Don't Miss:**

- [INFORMATICA Transformations Tutorial & Filter Transformation](https://www.guru99.com/introduction-transformations-informatica-and-filter-transformation.html)
- [Source Qualifier Transformation in Informatica with EXAMPLE](https://www.guru99.com/source-qualifier-transformation-informatica.html)
- [Performance Tuning in Informatica: Complete Tutorial](https://www.guru99.com/performance-tuning-transformation-informatica.html)
- [Informatica Tutorial](https://www.guru99.com/informatica-tutorials.html)

## How to Create the Integration Service

The Integration Service is responsible for the execution of [workflows](https://www.guru99.com/workflows-informatica.html). Whenever any workflow is executed from Workflow Manager, a scheduler or the command prompt, the Integration Service receives a request. This service locks the respective workflow, fetches the details about the workflow, mapping and session from the Informatica repository, and executes the workflow. This service is also responsible for creating workflow logs, reading parameter files, creating process threads to execute workflows, executing any other task created in Workflow Manager, and so on.

The two services divide the work as follows.

| Service | What it is responsible for |
| --- | --- |
| Repository Service | Stores and serves the metadata – mappings, sessions, workflows and folders – held in the repository database. |
| Integration Service | Reads that metadata and actually runs the workflows and sessions, writing session and workflow logs. |

To create the Integration Service:

**Step 1)** Start the service creation wizard.

1. Right-click on the Domain Navigator tree
2. Select the new option
3. Select PowerCenter Integration Service

[![Domain Navigator right-click menu showing New PowerCenter Integration Service]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig13.png)

**Step 2)** In this step we will:

1. Enter the Integration Service name
2. Select the license
3. Select a node and click next.

[![New Integration Service wizard page for service name, license and node]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig14.png)

**Step 3)** On the next page:

1. Select the Repository Service
2. Enter the Informatica Administrator user name and password.
3. Select Finish.

[![Integration Service wizard page linking the service to a Repository Service]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig15.png)

**Step 4)** To enable the Integration Service:

1. Click on the Integration Service in the domain tree and select the Actions option.
2. Select the Enable Service option

[![Actions menu with the Enable Service option for the Integration Service]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig16.png)

When both the Integration Service and the Repository Service are created and enabled, they should be in running status, as the domain tree confirms below.

[![Domain tree showing the Repository Service and Integration Service both available]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig17.png)

## How to Configure the Client and Domain

Before you start using the Informatica Integration Service and Repository Service of the Informatica server, you have to configure the Informatica domain at the client. To add the domain at the client, the following steps are required.

**Step 1)** Open the Informatica PowerCenter Designer client. The same Repository menu exists in Repository Manager and Workflow Manager, so this dialog can be reached from any client tool.

1. Select the Repository menu
2. Select Configure Domains

[![Repository menu opened in the PowerCenter client with Configure Domains highlighted]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig18.png)

**Step 2)** Select the add new domain option.

[![Configure Domains window with the add domain button]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig19.png)

**Step 3)** In the add domain window:

1. Enter the domain name
2. Enter the gateway host
3. Enter the gateway port (the port number is assigned during the Informatica server installation process)
4. Select OK

[![Add Domain dialog with domain name, gateway host and gateway port fields]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig20.png)

**Step 4)** The repository will be listed on the right side of the window. Select the checkbox and select OK.

[![Configure Domains window listing the discovered repository with a selection check box]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig21.png)

The repository will then be listed in the Repository Manager navigation tree.

[![Repository Manager navigator showing the added repository entry]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig22.png)

## How to Create a User

To create [mappings](https://www.guru99.com/mappings-informatica.html) in Informatica Designer and to perform various tasks such as executing workflows, managing repository folders and monitoring workflows, a valid Informatica user is required, and the user must have privileges. A user can be an administrator user or a developer user based on the roles assigned to it. You can create any number of users based on requirement.

To create an Informatica user:

**Step 1)** In the Informatica Administrator home page, select the Security tab.

[![Security tab in the Informatica Administrator navigation bar]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig23.png)

**Step 2)** In this step we will:

1. Select the Users tab
2. Select the Actions menu
3. Select the create user option

[![Users tab with the Actions menu open on Create User]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig24.png)

**Step 3)** On the create user page:

1. Enter the desired login name
2. Enter the desired password
3. Confirm the password
4. Select OK

[![Create User form with login name and password fields]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig25.png)

**Step 4)** The user must have privileges on the domain and the repository. To assign the privileges:

1. Click on the user name
2. Select the Privileges tab
3. Select the domain.

[![Privileges tab for the new user showing the domain entry]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig26.png)

**Step 5)** In the edit roles window:

1. Select the check box of the domain
2. Select the check box for the Repository Service
3. Select OK.

This will assign repository and domain privileges to the user, as the edit roles window below shows.

[![Edit Roles window with domain and Repository Service check boxes selected]()](https://www.guru99.com/images/informatica/083115_0522_HowtoConfig27.png)

Now you will be able to connect to the repository using the client tools.

This completes the exercise of Repository Service creation, Integration Service creation, domain configuration, user creation and adding a repository in the client.

## FAQs

🗃️ What is the difference between the domain configuration database and the repository database?

The domain configuration database stores node, service and user metadata for the whole domain and is created during server installation. The repository database is separate and holds PowerCenter objects such as mappings, sessions and workflows.

🚦 Why must repository contents be created before the service can start?

Repository contents are the metadata tables themselves. Until they exist, the Repository Service has no schema to read or write, so it cannot move into a usable running state for developers.

🔗 What value belongs in the connection string field?

The connection string is the database instance service name that the Repository Service uses to reach its schema. For Oracle this is the service name; an incorrect value is the most common cause of service creation failure.

🌐 Which port does the Informatica Administrator tool use?

The Administrator tool listens on port 6008 by default. The gateway host and gateway port you enter on each client must match the values chosen during server installation, not the browser console address.

🧩 Can one domain contain more than one Repository Service?

Yes. A domain can host several PowerCenter Repository Services and Integration Services across its nodes. Each Integration Service is associated with one Repository Service, which is chosen on the last page of the creation wizard.

🛡️ What is the difference between a privilege and a role?

A privilege grants a single action, such as running a workflow. A role bundles privileges together so the same set can be granted repeatedly. The Privileges tab assigns both per domain and per service.

🤖 How is AI used in Informatica administration today?

Informatica ships CLAIRE, its AI engine, which profiles data, recommends transformations and flags anomalies in job behaviour. Administrators also apply machine learning to service logs to predict failures before workflows break.

🧑‍💻 Can GitHub Copilot help automate repository and service setup?

Copilot can draft the infacmd and pmrep command lines, shell wrappers and parameter files that repeat this console procedure. Always review generated commands against Informatica documentation before running them against a live domain.

#### Summarize this post with:

ChatGPTPerplexityGrokGoogle AI

**Stay Updated on AI** **Get Weekly AI Skills, Trends, Actionable Advice.**

##### Sign up for the newsletter

Subscribe for Free

You have successfully subscribed.  
Please check your inbox.

![AI-Newsletter]() Chosen by over **350,000+** professionals

[Scroll to top](#wrapper)

×

Search for:

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://www.guru99.com/#organization","name":"Guru99","sameAs":["https://www.facebook.com/Guru99Official","https://twitter.com/guru99com"],"logo":{"@type":"ImageObject","@id":"https://www.guru99.com/#logo","url":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","contentUrl":"https://www.guru99.com/images/guru99-logo-v1-150x59.png","caption":"Guru99","inLanguage":"en-US"}},{"@type":"WebSite","@id":"https://www.guru99.com/#website","url":"https://www.guru99.com","name":"Guru99","publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https://www.guru99.com/images/configure-informatica-client-repository.png","url":"https://www.guru99.com/images/configure-informatica-client-repository.png","width":"700","height":"250","caption":"Configure Informatica Client & Repository","inLanguage":"en-US"},{"@type":"BreadcrumbList","@id":"https://www.guru99.com/configure-clients-and-repositories-informatica.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":"1","item":{"@id":"https://www.guru99.com","name":"Home"}},{"@type":"ListItem","position":"2","item":{"@id":"https://www.guru99.com/informatica","name":"Informatica"}},{"@type":"ListItem","position":"3","item":{"@id":"https://www.guru99.com/configure-clients-and-repositories-informatica.html","name":"How to Configure Client and Repository in Informatica"}}]},{"@type":"WebPage","@id":"https://www.guru99.com/configure-clients-and-repositories-informatica.html#webpage","url":"https://www.guru99.com/configure-clients-and-repositories-informatica.html","name":"How to Configure Client and Repository in Informatica","dateModified":"2026-10-10T16:34:40+05:30","isPartOf":{"@id":"https://www.guru99.com/#website"},"primaryImageOfPage":{"@id":"https://www.guru99.com/images/configure-informatica-client-repository.png"},"inLanguage":"en-US","breadcrumb":{"@id":"https://www.guru99.com/configure-clients-and-repositories-informatica.html#breadcrumb"}},{"@type":"Person","@id":"https://www.guru99.com/author/editorial","name":"Editorial Team","url":"https://www.guru99.com/author/editorial","image":{"@type":"ImageObject","@id":"https://www.guru99.com/images/favicon-new-logo.png","url":"https://www.guru99.com/images/favicon-new-logo.png","caption":"Editorial Team","inLanguage":"en-US"},"sameAs":["https://www.guru99.com/editorial-team"],"worksFor":{"@id":"https://www.guru99.com/#organization"}},{"articleSection":"Informatica","headline":"How to Configure Client and Repository in Informatica","description":"After installing Informatica server and client, Informatica server needs to be configured. The Informatica architecture is a Service Oriented Architecture (SOA). Therefore, before using Informatica to","keywords":"informatica","speakable":{"@type":"SpeakableSpecification","cssSelector":[".entry-title",".summary"]},"@type":"Article","author":{"@id":"https://www.guru99.com/author/editorial","name":"Editorial Team"},"dateModified":"2026-10-10T16:34:40+05:30","image":{"@id":"https://www.guru99.com/images/configure-informatica-client-repository.png"},"copyrightYear":"2026","name":"How to Configure Client and Repository in Informatica","subjectOf":[{"@type":"FAQPage","mainEntity":[{"@type":"Question","name":"What is the difference between the domain configuration database and the repository database?","acceptedAnswer":{"@type":"Answer","text":"The domain configuration database stores node, service and user metadata for the whole domain and is created during server installation. The repository database is separate and holds PowerCenter objects such as mappings, sessions and workflows."}},{"@type":"Question","name":"Why must repository contents be created before the service can start?","acceptedAnswer":{"@type":"Answer","text":"Repository contents are the metadata tables themselves. Until they exist, the Repository Service has no schema to read or write, so it cannot move into a usable running state for developers."}},{"@type":"Question","name":"What value belongs in the connection string field?","acceptedAnswer":{"@type":"Answer","text":"The connection string is the database instance service name that the Repository Service uses to reach its schema. For Oracle this is the service name; an incorrect value is the most common cause of service creation failure."}},{"@type":"Question","name":"Which port does the Informatica Administrator tool use?","acceptedAnswer":{"@type":"Answer","text":"The Administrator tool listens on port 6008 by default. The gateway host and gateway port you enter on each client must match the values chosen during server installation, not the browser console address."}},{"@type":"Question","name":"Can one domain contain more than one Repository Service?","acceptedAnswer":{"@type":"Answer","text":"Yes. A domain can host several PowerCenter Repository Services and Integration Services across its nodes. Each Integration Service is associated with one Repository Service, which is chosen on the last page of the creation wizard."}},{"@type":"Question","name":"What is the difference between a privilege and a role?","acceptedAnswer":{"@type":"Answer","text":"A privilege grants a single action, such as running a workflow. A role bundles privileges together so the same set can be granted repeatedly. The Privileges tab assigns both per domain and per service."}},{"@type":"Question","name":"How is AI used in Informatica administration today?","acceptedAnswer":{"@type":"Answer","text":"Informatica ships CLAIRE, its AI engine, which profiles data, recommends transformations and flags anomalies in job behaviour. Administrators also apply machine learning to service logs to predict failures before workflows break."}},{"@type":"Question","name":"Can GitHub Copilot help automate repository and service setup?","acceptedAnswer":{"@type":"Answer","text":"Copilot can draft the infacmd and pmrep command lines, shell wrappers and parameter files that repeat this console procedure. Always review generated commands against Informatica documentation before running them against a live domain."}}]}],"@id":"https://www.guru99.com/configure-clients-and-repositories-informatica.html#schema-1151711","isPartOf":{"@id":"https://www.guru99.com/configure-clients-and-repositories-informatica.html#webpage"},"publisher":{"@id":"https://www.guru99.com/#organization"},"inLanguage":"en-US","mainEntityOfPage":{"@id":"https://www.guru99.com/configure-clients-and-repositories-informatica.html#webpage"}}]}
```