Integration of QTP with Informatica

Integration of QTP with Informatica Workflows

INFA Workflows can be integrated with QTP to check the timing of Execution, Number of Records affected in the respective session etc.

This process is achieved by using UNIX Scripts. UNIX scripts invoke the Informatica sessions using PMCMD Informatica commands.

First task is to get the automation scripts for Integrating UNIX and QTP.

Secondly, we can execute the UNIX scripts to run the Informatica Workflows and get the desired result.

Lastly, read the log files generated in this process and get the process information.

Step 1: Integration of UNIX and QTP

Basic Requirements:

1. PuTTY – Telnet Implementation should be installed in the system.

2. QTP should be installed on the system.

NOTE: To connect PuTTY and QTP, We need to have Terminal Emulator Add In installed in QTP.
Emulating PuTTY:

1. Click on QTP

2. Verify that Terminal Emulator Ad In is selected

3. Click OK.

4. Once QTP is opened, Click Tools -> Options -> Terminal Emulator

5.  Below screen should appear. Click Next for the same.

6. We configure a new user defined setting and set PuTTY and Emulator. Once done, we can always modify the existing as below.

7.  Click on Object spy and select the screen that comes after connecting through PuTTY. This needs to be done for the Main Window Class and Text Window Class.

8. Change the Screen Offset to Top -> 1 and Left -> 1. Click Next

9. Wizard is complete. Select the Emulator as PuTTY and click on Validate. It should display OK in Green. This shows that PuTTY has been successfully integrated with QTP.

10. Open QTP Test by following: File -> New -> Test.

11. Next we need to record one complete sequence of operation through Putty.

12. Click the Record button at Top Left of QTP and follow the below sequence.

·         Open PuTTY

·         Login to the desired Unix Server

·         Enter the User Id and Password

·         Go to the desired directory

·         Execute the KSH job

·         Exit from the server

13. Once Recording is complete, script will be populated in the QTP Editor. Now click on the Stop button to stop the scripting.

14. Add respective Wait Commands to introduce any delays in opening of the PuTTY or connecting to the servers.

15. Now the automated scripts can be executed for the testing purpose by providing different data set results.

Step 2: Executing UNIX scripts

1. KSH script can be build to call the Informatica workflows to execute, schedule or unschedule.

2. Following script will invoke the particular session in the Workflow:

pmcmdstarttask       -sv<<Integration Service>>

          -d <<Domain Name>>

-u <<User Id>>

-p << Password>>

-usd<< User Service Domain>.

-f <<Directory from where workflows are executed>>

-w <<Workflow Name>>

-wait <<Session Name>>

3. Following script will invoke the particular Workflow:

pmcmdstartworkflow -sv<<Integration Service>>

          -d <<Domain Name>>

-u <<User Id>>

-p << Password>>

-usd<< User Service Domain>.

-f <<Directory from where workflows are executed>>

-wait <<Workflow Name>>

4. Execution this script will ensure that the Workflows have executed and generated the logs at the defined directory.

Step 3: Fetching Execution Log

1. Workflows populate the log at the set paths on UNIX box that are provided in the Workflow Manager.

2. These logs can then be used as inputs to parse the following information:

          Session Start Time

          Session End Time

          Number of Records Affected

          Number of Records Rejected

3. This information can be obtained for all the respective sessions of a Workflow.

4. These information can be collated to generate the report for the respective workflows.

Posted in: QTP Testing