Informatica Getting Started - Create Users and Groups

Logging In to Informatica Administrator

Use the default administrator user name and password you entered in Domain. Otherwise, ask the Informatica administrator to perform the tasks in this section for you.

1.	Open Microsoft Internet Explorer or Mozilla Firefox.
2.	In the Address field, enter the following URL for the Informatica Administrator login page: http://<host>:<port>/administrator If you configure HTTPS for Informatica Administrator, the URL redirects to the HTTPS enabled site. If the node is configured for HTTPS with a keystore that uses a self-signed certificate, a warning message appears. To enter the site, accept the certificate. The Informatica Administrator login page appears.
3.	Enter the default administrator user name and password. Use the Administrator user name and password you recorded in Administrator.
4.	If the security domain is configured for LDAP, select Native.
5.	Click Login.
6.	If the Administration Assistant appears, click Administrator.

Creating a Group

In the following steps, you create a group and assign privileges to the group.

1.	In the Administrator tool, click the Security tab.
2.	In Groups, Actions > Create Group.
3.	Enter the following information for the group: Property Value Name TUTORIAL Description Group used for the PowerCenter tutorial.
4.	Click OK to save the group. The TUTORIAL group appears on the list of native groups in the Groups section of the Navigator. The Properties area contains the name, security domain, parent group, and description for the new group. The Users area contains no items in this example:
5.	Click the Privileges tab.
6.	Click Edit.
7.	In the Edit Roles and Privileges dialog box, click the Privileges tab.
8.	Expand the privileges list for the PowerCenter Repository Service that you plan to use.
9.	Click the box next to the Repository Service name to assign all privileges to the TUTORIAL group.
10.	Click OK. Users in the TUTORIAL group have the privileges to create workflows in any folder for which they have read and write permission.

Creating a User

The final step is to create a user account and add the user to the TUTORIAL group. You use this account throughout the rest of this tutorial.

1.	On the Security tab, click Users, Actions > Create User. The Create User dialog box appears.
2.	Enter a login name for the user account. You use this user name when you log in to the PowerCenter Client to complete the rest of the tutorial.
3.	Enter a password and confirm. You must retype the password. Do not copy and paste the password.
4.	Enter the full name of the user.
5.	Click OK to save the user account. The details for the new user account are in the Properties area. The Groups area contains no items in this example:
6.	Click the Overview tab.
7.	Click Edit.
8.	In the Edit Properties dialog box, click the Groups tab.
9.	Select the group name TUTORIAL in the All Groups column and click Add. The TUTORIAL group appears in Assigned Groups list.
10.	Click OK to save the group assignment. The user account has all the privileges for the TUTORIAL group.

Informatica Background

Informatica (NASDAQ: INFA) was founded in 1993 in Silicon Valley by Indian Entrepreneurs Gaurav
Dhillon and Diaz Nesamoney. its headquarters is in Redwood City, California. It was based on the
idea that data warehouses should not be "handcoded", but instead can be built more efficiently
with graphical tools.
Informatica is reported to be the most recognized data integration tools brands, and as having a
strong leadership position.
Informatica's products include PowerCenter, PowerExchange, B2B, Data Quality, Master Data
Management, and Ultra Messaging.
Introduction to Power Center
PowerCenter provides an environment that allows you to load data into a centralized location, such as a data warehouse or operational data store (ODS). You can extract data from multiple sources, transform the data according to business logic you build in the client application, and load the transformed data into file and relational targets.
PowerCenter also provides the ability to view and analyze business information and browse and analyze metadata from disparate metadata repositories.

Power Center includes Power center domain, Repository and Admin console.
Different services include Repository service, Web service, Reporting service, metadata manager service, integration service etc.

Informatica Getting started - Introduction

Introduction

PowerCenter provides an environment that allows you to load data into a centralized location, such as a data warehouse or operational data store (ODS). You can extract data from multiple sources, transform the data according to business logic you build in the client application, and load the transformed data into file and relational targets.

PowerCenter also provides the ability to view and analyze business information and browse and analyze metadata from disparate metadata repositories.

PowerCenter includes the following components:

	Informatica domain. The Informatica domain is the primary unit for management and administration within PowerCenter. The Service Manager runs on an Informatica domain. The Service Manager supports the domain and the application services. Application services represent server-based functionality. The domain supports PowerCenter and Informatica application services. PowerCenter application services include the PowerCenter Repository Service, PowerCenter Integration Service, Web Services Hub, and SAP BW Service. Informatica Services include the Data Integration Service, Model Repository Service, and the Analyst Service.
	PowerCenter repository. The PowerCenter repository resides in a relational database. The repository database tables contain the instructions required to extract, transform, and load data.
	Informatica Administrator. Informatica Administrator is a web application that you use to administer the Informatica domain and PowerCenter security.
	Domain configuration. The domain configuration is a set of relational database tables that stores the configuration information for the domain. The Service Manager on the master gateway node manages the domain configuration. The domain configuration is accessible to all gateway nodes in the domain.
	PowerCenter Client. The PowerCenter Client is an application used to define sources and targets, build mappings and mapplets with the transformation logic, and create workflows to run the mapping logic. The PowerCenter Client connects to the repository through the PowerCenter Repository Service to modify repository metadata. It connects to the Integration Service to start workflows.
	PowerCenter Repository Service. The PowerCenter Repository Service accepts requests from the PowerCenter Client to create and modify repository metadata and accepts requests from the Integration Service for metadata when a workflow runs.
	PowerCenter Integration Service. The PowerCenter Integration Service extracts data from sources and loads data to targets.
	Web Services Hub. Web Services Hub is a gateway that exposes PowerCenter functionality to external clients through web services.
	SAP BW Service. The SAP BW Service extracts data from and loads data to SAP NetWeaver BI. If you use PowerExchange for SAP NetWeaver BI, you must create and enable an SAP BW Service in the Informatica domain.
	Reporting Service. The Reporting Service runs the Data Analyzer web application. Data Analyzer provides a framework for creating and running custom reports and dashboards.
	Reporting and Dashboards Service.The Reporting and Dashboards Service runs the JasperReports application. You can view the PowerCenter and Metadata Manager reports from JasperReports Server. You can also launch the reports from the PowerCenter Client and Metadata Manager to view them in JasperReports Server.
	Metadata Manager Service. The Metadata Manager Service runs the Metadata Manager web application. You can use Metadata Manager to browse and analyze metadata from disparate metadata repositories. Metadata Manager helps you understand and manage how information and processes are derived, how they are related, and how they are used. Metadata Manager stores information about the metadata to be analyzed in the Metadata Manager repository.