How to Configure Client and Repository in Informatica

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 tools, server and client components needs to be installed and configured.

Prerequisite to configure clients, integration service and repository service.

  • Informatica server and client should be installed.
  • Informatica service should be up and running.
  • Oracle or other compatible databases must be installed, and database service must be up.
  • Database users must be created for repository service.
  • Domain administrator console credentials must be available (it is configured during server installation)

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

  1. Informatica domain
  2. creating repository service
  3. creating integration service
  4. Creating users

What is Informatica domain?

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

Using domain console you can perform various administrative tasks like adding a node, creating repository service, creating integration service, creating reporting service, managing & creating users, monitoring services, etc.

During installation of Informatica server, system prompts for setting up the domain credentials and database connection.

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

 Open the Administrator Home Page

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

Troubleshooting– if the home page doesn’t open up, check whether Informatica server process and database service are up and running. If not, start the same.

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

 Open the Administrator Home Page

Step 3) On successful login the Informatica administrator home page will appear.

 Open the Administrator Home Page

How to Create Repository Service

It is the first service that needs to be created in the domain console. The pre-requisite 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 databases to create a repository

Step 1)

  1. Right-click on the domain name
  1. Select new option
  1. Select PowerCenter repository service.

Create Repository Service

Step 2) In the next screen

  1. Enter Name for the repository
  2. Select License
  3. Select Node
  4. Click on Next Button

Create Repository Service

Step 3) In the next screen,

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

Create Repository Service

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

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

Create Repository Service

Troubleshooting – if there is an error during service creation, check whether the correct database credentials are provided, and connection string is correct. After any changes 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 needs to be created (this is one time activity for a repository). Without repository contents, you cannot start the repository service. Repository content is basically database tables which contains the details of objects created in Informatica.

Step 1) Select the repository service under the domain tree.

Create Repository Contents

Step 2) After selecting the repository service.

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

Create Repository Contents

Step 3) In the next screen

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

Create Repository Contents

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

Select the edit property option of repository

Create Repository Contents

Step 5)

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

Create Repository Contents

Once done, the repository service will be running in normal mode.

How to create Integration Service

The integration service is responsible for the execution of workflows. Whenever, any workflow is executed from workflow manager, scheduler or command prompt, the integration service receives a request. This service locks the respective workflow, fetches the details about the workflow, mapping & 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, execute any other task created in workflow manager, etc.

To Create Integration Service

Step 1)

  1. Right click on the domainnavigator tree
  2. Select new option
  3. Select PowerCenter integration service

Create Integration Service

Step 2) In this step we will,

  1. Enter integration service name
  2. Select the license
  3. Select a node and click next.

Create Integration Service

Step 3) On the next page

  1. Select the repository service
  2. Enter Informatica Administrator username and password.
  3. Select Finish.

Create Integration Service

Step 4)To enable Integration service.

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

Create Integration Service

When both integration service and repository services are created and enabled, they should be in running status.

Create Integration Service

How to Configuring client and domain

Before you start using the Informatica integration and repository service of the Informatica server, you have to configure the Informatica domain at the client. To add the domain at client following steps are required.

Step 1) Open the Informatica repository designer

  1. Select repository menu
  2. Select configure domains

Configuring Client and Domain

Step 2) Select the add new domain option

Configuring Client and Domain

Step 3) In the add domain window

  1. Enter Domain name
  2. Enter Gateway host
  3. Enter Gateway port ( the port no is assigned during the Informatica server installation process)
  4. Select ok

Configuring Client and Domain

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

Configuring Client and Domain

The repository will be listed in the repository manager navigation tree.

Configuring Client and Domain

How to create user

To create mappings in Informatica designer and to perform various tasks like, executing workflows, managing repository folders, monitoring workflows, etc. a valid Informatica user is required, and the user must have privileges. A user can be administrator user or developer user based on the roles assigned to it. You can create any no. of users based upon requirement.

To create Informatica user

Step 1) In the Informatica Administrator home page Select security tab

Create Informatica User

Step 2) In this step we will,

  1. Select user tab
  2. Select action menu
  3. Select create user option

Create Informatica User

Step 3) On create user page

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

Create Informatica User

Step 4)The user must have privilege to domain and repository, to assign the privilege

  1. Click on username
  2. Select privileges tab
  3. Select the domain.

Create Informatica User

Step 5) In the edit role window

  1. Select check box of domain
  2. Select check box for repository service
  3. Select ok.

This will assign repository and domain privilege to the user.

Create Informatica User

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

This completes the exercise of repository service creation, integration service creation, domain configuration, user creation and adding a repository in the client.