Scribd Logo
Upload

Welcome to Scribd!

  • 10 views

    CE Module 3 Labs

    Uploaded by

    tawitron
    This document discusses using Informatica Cloud Integration Templates to build and share reusable integration workflows. It provides steps to create a template from scratch using Mapping Architect for Visio (MAV) that aggregates data using the PowerCenter Aggregator transformation. It then publishes the template from MAV and imports it into Informatica Cloud Services (ICS) to configure properties and consume the template in a custom integration task, validating the mapping between a source CSV file and targets in Salesforce and another CSV file.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    CE Module 3 Labs

    Uploaded by

    tawitron
    10 views8 pages
    This document discusses using Informatica Cloud Integration Templates to build and share reusable integration workflows. It provides steps to create a template from scratch using Mapping Architect for Visio (MAV) that aggregates data using the PowerCenter Aggregator transformation. It then publishes the template from MAV and imports it into Informatica Cloud Services (ICS) to configure properties and consume the template in a custom integration task, validating the mapping between a source CSV file and targets in Salesforce and another CSV file.

    Original Title

    CE Module 3 labs

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document discusses using Informatica Cloud Integration Templates to build and share reusable integration workflows. It provides steps to create a template from scratch using Mapping Architect for Visio (MAV) that aggregates data using the PowerCenter Aggregator transformation. It then publishes the template from MAV and imports it into Informatica Cloud Services (ICS) to configure properties and consume the template in a custom integration task, validating the mapping between a source CSV file and targets in Salesforce and another CSV file.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    10 views8 pages

    CE Module 3 Labs

    Uploaded by

    tawitron
    This document discusses using Informatica Cloud Integration Templates to build and share reusable integration workflows. It provides steps to create a template from scratch using Mapping Architect for Visio (MAV) that aggregates data using the PowerCenter Aggregator transformation. It then publishes the template from MAV and imports it into Informatica Cloud Services (ICS) to configure properties and consume the template in a custom integration task, validating the mapping between a source CSV file and targets in Salesforce and another CSV file.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 8

    Informatica® Cloud

    Enterprise Edition

    Module 3 Lab Exercises

    Informatica Cloud Services On-Demand Training 1


    Module 3 Lab 1: Adding a Custom Integration
    Template
    Summary:

    Informatica Cloud Integration Templates allow customers and partners to build, and share full-
    scale "integration apps" on demand. Cloud Integration Templates also save time by using pre-
    defined mappings for specific processes, which reduces the number of steps required to execute
    sophisticated integration workflows. You can even tweak these processes according to your
    specific needs and dramatically reduce your deployment time and costs.

    Consuming Existing Templates:

    1. Download from Marketplace


    a. Indexed Documents
    2. Export from existing Data Synchronization task from ICS
    3. Export from PowerCenter.

    Scenario:

    Aggregate data using the PowerCenter Aggregator transformation. This supports


    all aggregation functions (SUM, MIN, AVG, MAX, COUNT etc)

    Goals:
    In this lab, you will practice:
     Create cloud Template from scratch using Mapping Architect for Visio
    (MAV).
     Publish the template from MAV
     Importing a Integration Template into ICS.
     Configuring the integration template properties.
     Consume the template in Custom Integration Task.

    Duration:
    This lab should take approximately 25 minutes.

    Instructions
    1. Launch the Application - Mapping Architect for Visio (MAV).

    2 Informatica Cloud Services On-Demand Training


    1) Click on Enable Macros button

    2) Click on the Add-Ins tab

    2. Create a new data integration template in the org.

    1) Drag and Drop the following PowerCenter stencils in the workspace.

    Informatica Cloud Services On-Demand Training 3


    2) Edit the display properties for each transformation:

    Sources and Targets


    Type Instance Name Attributes
    Source Table=src
    Source Definition src

    Target Table=tgt
    Target Definition tgt

    4 Informatica Cloud Services On-Demand Training


    Transformations
    Type Instance Name Attributes
    Source Qualifier sq1 Source Filter=
    Filter filter Filter Condition=$flt$
    Sorted Input=NO
    Aggregator agg1 Expression Text=$aggcolmap$;
    GroupBy=$gpby$

    Parameters
    Name
    $flt$
    $aggcolmap$
    $gpby$

    Edit the Link properties for each Link:


    From To Link Rule
    filter agg1 All Ports
    agg1 tgt Pattern:_OUT$
    sq1 filter All Ports
    src sq1 All Ports

    Informatica Cloud Services On-Demand Training 5


    3) Validate the mapping

    4) Publish the template

    5) Click OK to save the template.

    Instructions
    1. Log into ICS org
    2. Import the template

    6 Informatica Cloud Services On-Demand Training


    Name Valid Connection Display Logical Input
    Types Order Connection Control
    $src1$ Flat File or Relational
    Database
    $tgt1$ Salesforce 1 Valid_Results
    $tgt2$ Flat File or Relational 2 Invalid_Results
    Database
    $nullcheck$ 1 Condition
    $validcheck$ 2 Expression

    3. Create a new data integration template in the org.


    1) Enter SXX_SimpleAggregation (where XX is your student number)
    in the Task Name field.
    2) Select your secure agent (or EC2-Training1, if you are using the training
    environment’s agent).
    3) In the Integration Template field, click the Select button and select the
    Integration Template you created in the previous lab.
    4) Click Next.

    4. Specify Source information.


    1) Select SXX_LocalCSVFiles (where xx is your student number) from the
    Connection menu (or, select Lab Files, if you are using the training
    environment agent).
    2) Select Leads.csv from the Source Object menu.
    3) Click Next.
    5. Specify targets information.

    Informatica Cloud Services On-Demand Training 7


    1) Select SXX_SFDCDeveloper from the ValidResults Connection menu.
    2) Select Lead from the Valid Target Object menu.
    3) Select SXX_LocalCSVFiles (where xx is your student number) from the
    Connection menu (or, select Lab Files, if you are using the training
    environment agent) from the InvalidResults Connection menu.
    4) Select the Create Target button in the Invalid Target Object field and
    create a file called InvalidLeads.csv:

    5) Click Next.

    8 Informatica Cloud Services On-Demand Training

    You might also like