Before we can begin using PowerCenter fro design and development, we must setup/create the environment and perform the following administration tasks to allow access to the Repository and the PowerCenter Server.

Install and configure the PowerCenter Server:

Install the PowerCenter Server on a Windows or UNIX system that accesses the sources, targets, and the repository database.

Install the PowerCenter Client:

Install the client software on all the machines (developer’s machines) that needs to accesses the sources, targets, and repository databases, as well as the PowerCenter Server.

Choose globalization settings and data movement modes:

 The data movement mode you use depends on whether you want the PowerCenter Server to process single-byte data or multi-byte character data. You select code pages for the repository, PowerCenter Client and PowerCenter Server.

Create Repository database:

Create a database for the repository. Users accessing the repository database need full rights in that database. If you upgrade the repository to a new version, you need database rights to drop or modify these tables.

IBM DB2, Oracle, Sybase and MS SQL server databases can be used as repository database for any version of Informatica Powercenter.

Create repository users and groups:

Create groups and user profiles, then assign privileges and permissions that determine tasks that users can perform. 

You can create a repository user profile for everyone working in the repository, each with a separate user name and password. You can also create user groups and assign each user to one or more groups. Then, grant repository privileges to each group, so users in the group can perform tasks within the repository (such as use the Designer or create workflows).

The repository user profile is not the same as the database user profile. While a particular user might not have access to a database as a database user, that same person can have privileges to a repository in the database as a repository user.

Informatica tools include two types of security:

♦ Privileges. Repository-wide security that controls which task or set of tasks a single user or group of users can access.

♦ Permissions. Security assigned to individual folders within the repository.

PowerCenter uses the following privileges:

♦ Use Designer

♦ Browse Repository

♦ Use Repository Manager

♦ Use Workflow Manager

♦ Workflow Operator

♦ Administer Repository

♦ Administer Server

♦ Super User

You can perform various tasks for each privilege. Privileges depend on your group membership. Every repository user belongs to at least one group. For example, the user who administers the repository belongs to the Administrators group. By default, you receive the privileges assigned to your group. While it is most common to assign privileges by group, the repository administrator, who has either the Super User or Administer Repository privilege, can also grant privileges to individual users.

An administrator can perform the following tasks

♦ Create groups.

♦ Assign privileges to groups.

♦ Create users and assign them to groups.

In the following steps, you will perform the following tasks:

1. Connect to the repository as an Administrator. If necessary, ask your administrator for the user name and password. Otherwise, ask your administrator to complete the lessons in this chapter for you.

2. Create a group called Group 1. To do this, you need to log in to the repository as the Administrator.

3. Assign privileges to the Group 1 group.

4. Create a new user.

Connecting to the Repository:

To perform the following tasks, you need to connect to the repository. If you are already connected to the repository, disconnect and connect again to log in as the Administrator. Otherwise, ask your administrator to perform the tasks in this chapter for you.

To connect to the Repository,

1. Launch the Repository Manager.

A list of all repositories appears in the Navigator.

2. Double-click on the repository .

3. Enter the repository user name and password for the Administrator user. Click Connect.

The dialog box expands to enter additional information.

4. Enter the host name and port number needed to connect to the repository database.

5. Click Connect.

You are now connected to the repository as the Administrator user.

Configure the sources and targets:

There will always be a need to access or connect to relational data source either as a source, target or lookup. If you need to extract data from relational sources, based on the organization’s policies and procedures, ask the database administrator to create user profiles with read access. These user profiles allow you to import source definitions into the repository and access the sources at run time.

If you extract data from file sources, the files must be accessible to the PowerCenter Server and Client machines. If the files are available on different servers, these files should be moved to PowerCenter’s source and target directories using FTP UNIX scripts or bat scripts. 

With BigData in picture, there are lot of different source types which needs to be created. PowerCenter BDM can be used to generate and consume all these types of sources and targets.

Configure connectivity. Configure network, native, and ODBC connectivity. Create ODBC data sources to connect to the PowerCenter Clients to the sources and targets. You must also have network connections between all databases and PowerCenter Servers.