6 Replies Latest reply on Sep 25, 2020 12:03 AM by Asmita Kesarwani

    How to Integrate Jenkins with Informatica Power Center for Workflow Execution

    Miti Gangele New Member

      How to Integrate Jenkins with Informatica Power Center for Workflow Execution.

        • 1. Re: How to Integrate Jenkins with Informatica Power Center for Workflow Execution
          Nico Heinze Guru

          Too unspecific. What kind of integration do you look for? Running, monitoring, and controlling workflow execution during DWH loads? Running some workflows during some deployment process? Something else?

           

          Despite me being completely lacking any experience about Jenkins, there are several technical options how you can integrate PowerCenter workflows into any other software.

           

          First Informatica provides the command-line utility pmcmd to interact with each Integration Service. Information about pmcmd and its capabilities can be found in the Command Reference guide, part of the Documentation Set for PowerCenter and the Informatica platform.

           

          Next one PowerCenter option is the so-called Web Service Hub. While you need it in order to provide SOAP web services via PowerCenter workflows, it also offers a SOAP based pmcmd-like interface to Integration Services on your PowerCenter server(s).

           

          Next you have the so-called Operations API (formerly known as the Load Manager API, short LMAPI), available in C and in Java. You can integrate this into your C or Java based applications in order to interact with Integration Services and hence with PowerCenter workflows.

           

          Regards,

          Nico

          • 2. Re: How to Integrate Jenkins with Informatica Power Center for Workflow Execution
            Asmita Kesarwani Guru

            PowerCenter (PC) is not certified nor is it integrated to run with any external version control system like Jenkins.


            As a potential workaround, you might be able to create some scripts that will execute export/import of XML of the session/mapping objects. Then use Jenkins to version control the XML files.


            So the basic idea is to store the XML files in GIT and retrieve them later (through Jenkins) for import back into PowerCenter. There is no out of the box integration between PowerCenter and these tools. Export/import through XML is supported by us, however, you need to develop the scripts to accomplish these tasks.

             

            Hope this helps.

             

            Thanks,

            Asmita

            1 of 1 people found this helpful
            • 3. Re: How to Integrate Jenkins with Informatica Power Center for Workflow Execution
              Miti Gangele New Member

              Thanks for your response.

               

              I am looking for if somebody integrated command line utility with Jenkins(Basically PMCMD for workflow execution).

               

              If yes ,Jenkins should be installed on the same server? what are the steps to integrate.

               

              Can any one explain?

               

              Regards,

              Miti

              • 4. Re: How to Integrate Jenkins with Informatica Power Center for Workflow Execution
                Asmita Kesarwani Guru

                You may have an independent Jenkins server, which is used by the whole enterprise.

                 

                Assuming that this server does not contain the PC software on it. As long as you are able to install only the PC command line utilities on this server, you can still execute these scripts (deployment and execution scripts) from this Jenkins server, where Informatica installation is not existent.

                 

                Hope this helps.

                 

                Thanks,

                Asmita

                 

                 

                • 5. Re: How to Integrate Jenkins with Informatica Power Center for Workflow Execution
                  Nico Heinze Guru

                  A word of explanation to this:

                  The so-called "command-line client" is a stripped-down version of the PowerCenter installation. It's available upon request from Informatica Shipping (or from Global Customer Support, they forward all so-called Shipping Requests internally to INFA Shipping anyway) and allows you to run the command-line tools on any supported operating system (even on Windows 10 which is not supported for "real" PowerCenter server installations). No charge included, the Command-Line Client does not count towards license usage.

                   

                  Regards,

                  Nico

                  • 6. Re: How to Integrate Jenkins with Informatica Power Center for Workflow Execution
                    Asmita Kesarwani Guru

                    Yes Miti, Command Line does not require any additional license.

                    Thanks Nico for more detail on the same.