Informatica PowerCenter Project Setup Automation

Informatica PowerCenter Project Setup Automation

Posted by: Priyanka Koul

An automated process of repository folder setup and user management with LDAP authentication that has potential of saving up to 99% of your time.

Overview

User Management in PowerCenter environment is not just a nontrivial task, it is time consuming as well. A typical PowerCenter User Management includes following.
  • User Creation
  • Creating Groups
  • Granting Roles to Groups
  • Adding Users to the Group
  • Creating Folders in PowerCenter Repository
  • Assigning Permission & Tagging Groups to Folder
The attached Script can automate all the above-mentioned steps and saves considerable amount (as much as 99%) of your time.

Features

Zero Manual Work and Incredible Turnaround.Standardized setup: Processing of user id's and Description will be consistent for all projects.Zero tool shift scenario : Complete setup can be done in one step through Putty terminal.Existing limitations of Informatica Admin Console like addition of multiple users to a group taken care using script. Standardization of permission to change management group.Standardization of permission to application group.Consistency in names of application folder, group, process id and setup.

  • Informatica PowerCenter 9.1 and 9.5.

Resources

Support

Priyanka Koul works as Data Integration and Infrastructure Specialist. As an Informatica Administrator, Priyanka has worked on upgrade project for Informatica 9.x platform and has keen insight on upcoming Enterprise Information Integration technologies. She holds Six Sigma Green Belt Certification for process automation in UNIX platform administration.