An Automated PowerCenter Review Tool

Posted by: TARIK ZAAKOUR

An easy to use, simple tool that will analyze the Informatica PowerCenter XML file and produces the validation report about Workflow, Mapping and Session objects in the readable Excel format.

Data Integration Developer Tools Mappings & Mapplets Workflows

Download now

Overview
Features
Resources
Support
Comments

Overview

An Automated PowerCenter Review Tool helps the organizations using Informatica PowerCenter to check for Informatica Velocity best practices in the mappings and the workflow they develop. The tools take the Informatica PowerCenter workflow XML file as the input and documents the details about the PowerCenter Mapping / Workflow and Session objects in the readable Excel sheet. The Tool provides the following output sheets inside a single excel workbook:

Information: The general information about the user who is using the tool.
Global: Information about the Workflow Repository, Folder name, Workflow, mapping transformation names used in the workflow.
Naming Convention: Report about the names of the Workflow, Mapping and Session objects used in the workflow and their adherence to the specified naming standards.
Configuration Workflow: Report about the workflow objects used in the workflow and their adherence to the specified naming standards.
Configuration Session: Report about the session objects used in the workflow and their adherence to the specified naming standards.
Session Connection: Report about the session connections used in the workflow and their adherence to the specified naming standards.
Mapping Variable Parameter: Report about the mapping variables used in the workflow and their adherence to the specified naming standards.
Shortcuts: Report about the shortcut objects and their adherence to the specified naming standards.
Transformation Properties: Report about the transformation properties used in the workflow and their adherence to the specified naming standards.
Port Naming Convention: Report about the ports used in the mapping transformations and their adherence to the specified naming standards.

The objects marked in the green in the excel sheet indicate that the specified object follows the Informatica Velocity best practices.

Features

Automation of code review process.Removal of manual intervention in the code review process susceptible to human errors. Helps you save valuable developer time and achieve increased productivity.Improved and high quality deliverables.

System Requirements

Informatica PowerCenter 9.1 and above
Microsoft Excel
Any Database

Resources

User Guide

Support

tarik.zaakour@gmail.com

Comments (14) Comment can only be posted by Signed/Logged in user

Sort: Newest | Oldest

Unknown

Is this download corrupted? Please advise.

Aug 11 2020, 8:13 AM
Unknown

Hi Team,

This download is corrupted.Only 1 KB size download & it is empty.Please re-upload

Thanks

Sep 01 2019, 12:46 PM
| 1

Load replies
Unknown

Hi Tariq,

It downloaded only 1 KB size. I think, its corrupted. Can you please upload this again & confirm ?

Thanks,

Sep 01 2019, 12:34 PM
Unknown

Hi Tarik,First of all thanks a lot fo creating and sharing this automated tool.I tested it with java version 1.7, its working fine. But when i tested it with java version 1.8 its throwing the error unable to read DTD file because of some parameter issue.Do you have updated version of this tool to support 1.8 java? If yes, please share. As java has been updated to 1.8 offcially and 1.7 is archived by oracle itself, so in our mainstream laptops only that is allowed.

Jan 23 2018, 11:03 AM
pranav bhide

Hello Tarik, We are planning to use your automated Review tool.I have configured everything as mentioned in your PDF Document.I have used the test XML that has been provided in your ZIP file wf_m_test_validation.The batch script is running and succeeding but not creating any log or analysis file as expected. Thus Need your assistance in understanding where am I going wrong. I have already mailed you all the required files i.e config file ,list file and workflow xml on thursday28/12/2017. My Email ID is Pranavpbhide@eaton.com . Awaiting for your valuable response.,Pranav Bhide

Jan 03 2018, 10:14 AM
Prakash Rai

Hi Tarik,I am not able to generate the same kind of results for my workflow like when I am executing the given workflows. Only information and Global tabs have collected information in the Report generated.AIso would like to know if it is possible to customize "ListOfInformationToCheck" document based on the requirement. Thanks,Prakash

Jun 23 2017, 6:05 AM
Sandeep Karpurapu

Hi Tarik, Can you please help on the below error. I have given the commandvalidationObjetsPC.bat wf_m_test_validation.xml C:\temp\PCValidationMarketPlace\conf\config.properties.I'm getting the error Could not find or load main class com.tza.fr.etl.validation.validationObjects.I had Java 8 initially. Then I removed and installed Java 7. I have checked using the command echo %JAVA_HOME%. Im getting the Java version as 1.7.0 only.Can you please help me with the error

Apr 13 2017, 11:16 AM
Nagireddy Pagadala

Hi Tarik,iam getting below error: can you help me here.C:\Users\nagireddy_pagadala\Desktop\InfNew\PCValidationMarketPlace\lancement>java -classpath ..\lib\log4j-1.2.8.jar;..\lib\poi-3.11-20141221.jar;..\lib\poi-examples-3.11-20141221.jar;..\lib\poi-excelant-3.11-20141221.jar;..\lib\poi-ooxml-3.11-20141221.jar;..\lib\poi-ooxml-schemas-3.11-20141221.jar;..\lib\poi-scratchpad-3.11-20141221.jar;..\lib\xmlbeans-2.5.0.jar;..\lib\jfreechart-1.0.1.jar;..\lib\jfreechart-1.0.1-demo.jar;..\lib\jcommon-1.0.0.jar;..\bin\PCValidationMarketPlace.jar com.tza.fr.etl.validation.validationObjects -f W_PE_PRODUCT_TITLE_FULLFILE.XML -cf C:\Users\nagireddy_pagadala\Desktop\InfNew\PCValidationMarketPlace\conf\config.propertiesException in thread "main" java.lang.UnsupportedClassVersionError: com/tza/fr/etl/validation/validationObjects : Unsupported major.minor version 51.0 at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClassCond(ClassLoader.java:631) at java.lang.ClassLoader.defineClass(ClassLoader.java:615) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141) at java.net.URLClassLoader.defineClass(URLClassLoader.java:283) at java.net.URLClassLoader.access$000(URLClassLoader.java:58) at java.net.URLClassLoader$1.run(URLClassLoader.java:197) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:190) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) at java.lang.ClassLoader.loadClass(ClassLoader.java:247)Could not find the main class: com.tza.fr.etl.validation.validationObjects. Program will exit.

Jan 18 2017, 11:59 AM
| 2

Load replies
Martin Ried

Hi Tarik,I liked your tool but there are some more things I'd like to validate.Did you ever think about making the sources available so others could add functionality?Regards,Martin

Oct 13 2016, 11:31 AM
| 1

Load replies
ANKIT SINGHAL

Hi, Can we customize this "ListOfInformationToCheck" to accomodate more check on the Transformation Properties where now it only check on the Tracing level.

Oct 04 2016, 10:38 AM
Unknown

Please ignore, resolved the issue.

May 03 2016, 8:49 PM
Saman Faraj

Many thanks for your prompt reply I used the sample xml bundled with softwarewf_m_test_validation.XMLKind RegardsSaman

Feb 17 2016, 10:28 AM
| 1

Load replies
Saman Faraj

Hi I am getting the same error 2016-02-16 16:09:30,298 INFO com.tza.fr.etl.validation.validationObjects - validationObjects.java:356 - Invoke mSetLogLevel2016-02-16 16:09:30,302 INFO com.tza.fr.etl.validation.validationObjects - validationObjects.java:170 - ###########2016-02-16 16:09:30,307 INFO com.tza.fr.etl.validation.validationObjects - validationObjects.java:171 - Start validating PowerCenter objects ...2016-02-16 16:09:30,311 INFO com.tza.fr.etl.validation.validationObjects - validationObjects.java:176 - PowerCenter Objects Validation Tool2016-02-16 16:09:30,317 INFO com.tza.fr.etl.validation.validationObjects - validationObjects.java:177 - Designed by Tarik Zaakour, Senior Architect and Informatica Certified Expert 2016-02-16 16:09:30,324 INFO com.tza.fr.etl.validation.validationObjects - validationObjects.java:178 - Email: tarik.zaakour@gmail.com2016-02-16 16:09:30,329 INFO com.tza.fr.etl.validation.validationObjects - validationObjects.java:179 - All Rights Reserved2016-02-16 16:09:30,334 INFO com.tza.fr.etl.validation.validationObjects - validationObjects.java:244 - Invoke mGenerateReport2016-02-16 16:09:30,614 INFO com.tza.fr.etl.validation.validationObjects - validationObjects.java:261 - Invoke mGenerateReportFirstSheet2016-02-16 16:09:30,661 INFO com.tza.fr.etl.validation.validationObjects - validationObjects.java:269 - ++++++++ Create the first Excel sheet2016-02-16 16:09:30,831 INFO com.tza.fr.etl.validation.validationObjects - validationObjects.java:214 - Invoke mParseXML2016-02-16 16:09:30,837 INFO com.tza.fr.etl.validation.repository - repository.java:96 - Invoke mInitRepository2016-02-16 16:09:30,840 INFO com.tza.fr.etl.validation.repository - repository.java:164 - Invoke mParseRepository2016-02-16 16:09:31,242 INFO com.tza.fr.etl.validation.repository - repository.java:199 - Invoke mGenerateReportGlobalSheet2016-02-16 16:09:31,247 INFO com.tza.fr.etl.validation.repository - repository.java:219 - ++++++++ Create the global Excel sheet2016-02-16 16:09:31,284 ERROR com.tza.fr.etl.validation.repository - repository.java:149 - ************* Error Message *******2016-02-16 16:09:31,290 ERROR com.tza.fr.etl.validation.validationObjects - validationObjects.java:203 - java.lang.NullPointerException at com.tza.fr.etl.validation.validationObjects.mParseXML(validationObjects.java:233) at com.tza.fr.etl.validation.validationObjects.main(validationObjects.java:183)

Feb 16 2016, 4:10 PM
| 1

Load replies
Unknown

Hi,I get this error: 2015-12-23 16:41:36,255 ERROR com.tza.fr.etl.validation.repository - repository.java:149 - ************* Error Message *******2015-12-23 16:41:36,258 ERROR com.tza.fr.etl.validation.validationObjects - validationObjects.java:203 - java.lang.NullPointerException at com.tza.fr.etl.validation.validationObjects.mParseXML(validationObjects.java:233) at com.tza.fr.etl.validation.validationObjects.main(validationObjects.java:183)Any suggestion?Thank you.

Dec 23 2015, 3:48 PM
| 2

Load replies