Getting Started - Informatica Power center

Getting Started

Before you can begin using PowerCenter, you must create the environment and perform the following administration tasks to allow access to the repository and the PowerCenter Server:

1. Configure the sources. If you extract data from relational sources, 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 runtime.

If you extract data from file sources, the files must be accessible to the PowerCenter Server and Client machines.

2. Configure the targets. Ask the database administrator to create user profiles with read and write access. These user profiles allow you to import target definitions into the repository and write to the targets at runtime.

If the target database does not exist, create it using the database administration tools included with your RDBMS. After you create the target database, you can use the Designer to design and create target tables.

For flat file targets, you need a target directory large enough to process the resulting files.

3. 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 multibyte character data. You select code pages for the repository, PowerCenter Client and PowerCenter Server.

4. 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.

5. Install the PowerCenter Client. Install the client software on a machine that accesses the sources, targets, and repository databases, as well as the PowerCenter Server.

6. Install and configure the Repository Server. Install and configure the Repository Server on a machine that accesses the repository database, the PowerCenter Client, and the PowerCenter Server.

7. 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.

8. 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.

9. Create the repository. After you configure connectivity between source, target, and repository databases, you can create the metadata repository. Connect to the Repository Server from within the Repository Server Administration Console to create the metadata repository. The Repository Server connects to the repository database and runs the SQL to create the repository tables. All the objects you create with PowerCenter are stored as metadata in the repository.

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

11. Register the PowerCenter Server. Before you can start the PowerCenter Server, you must register the PowerCenter Server so the Workflow Manager can direct the PowerCenter Server to the repository.