Integration Activity Log Template

Version 1

    The Activity Log integration template retrieves information from the Informatica Cloud activity log and produces a formatted output using a user-defined XSLT script. You can use this template to view a list of custom integration jobs, as well as any other tasks that recently ran. The output indicates if a task completed, completed with errors, or failed to complete.


    You can download this integration template from the Informatica Marketplace, here.



    • Download the plug-in to perform XSLT processing. The plug-in is the w_jxslt.xml file within the zip file that you downloaded from the Marketplace
    • Import the provided plug-in to your organization. Click Configuration > Plug-ins > New.
    • Configure the new plug-in, upload the plug-in file, and click Save.
    • Create a source file for authentication information for a valid Informatica Cloud account. Include the following field headers in the file and one row of data for the authentication information:


    Field   Headers




    Login   Details

    Informatica Cloud user name

    User ID

    Password for the account


    Step 1: Import Template and Set Display Properties

    Activity Log Template.png

    Click to view a larger image


    Step 2: Creating Custom Integration Task

    • Choose the integration template.
    • Select a flat file source connection and the source file with authentication information.
    • Select a flat file target connection and select Create Target to create an new file target for the task output.
    • On the Other Parameters page, define the attributes for the REST Calls (HTTP Method, HTTP URL) as shown below. Use the appropriate URL for your environment:

    Activity Log Template 2.png

    Click to view a larger image



    Sample XSLT Script

    <?xml version="1.0" encoding="ISO-8859-1"?>

    <xsl:stylesheet version="1.0" xmlns:xsl="">


    <xsl:template match="/">



    <h2>Activity Logs</h2>

       <table border="1">

         <tr bgcolor="#9acd32">



             <th>Start Time</th>

           <th>End Time</th>


           <th>Failed Target Rows</th>

           <th>Success Target Rows</th>

           <th>Failed Source Rows</th>

           <th>Success Source Rows</th>


         <xsl:for-each select="ActivityLogResponse/entries/ActivityLogEntry">


         <xsl:if test="success != 1">

           <xsl:attribute name="style">background-color:#FFCCCC;</xsl:attribute>


             <td><xsl:value-of select="type"/></td>

           <td><xsl:value-of select="objectName"/></td>

           <td><xsl:value-of select="startTime"/></td>

           <td><xsl:value-of select="endTime"/></td>

           <td><xsl:value-of select="success"/></td>

           <td><xsl:value-of select="failedSourceRows"/></td>

           <td><xsl:value-of select="successSourceRows"/></td>

           <td><xsl:value-of select="failedTargetRows"/></td>

           <td><xsl:value-of select="successTargetRows"/></td>










    • Row Limit (Activity Log). Enter the number of rows you want returned from the activity log.


    Additional Notes:

    • In some cases the output file might get truncated. If this happens delete the output file, edit and save the task, and run the task again.
    • If you don’t want to use the source file for storing a clear-text password, you can encrypt the password and decrypt it in the template. You can also code the password inside the template.