An Automated PowerCenter Review Tool

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.

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

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

Sort: Newest | Oldest
  • 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.
  • 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
  • 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,PrakashCapture.PNG
  • 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
  • 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.
     |   2
     Load replies
  • 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
     |   1
     Load replies
  • Hi, Can we customize this "ListOfInformationToCheck" to accomodate more check on the Transformation Properties where now it only check on the Tracing level.
  • Please ignore, resolved the issue.
  • Many thanks for your prompt reply I used the sample xml bundled with softwarewf_m_test_validation.XMLKind RegardsSaman
     |   1
     Load replies
  • 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)
     |   1
     Load replies
  • 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.
     |   2
     Load replies
Recommended Products