Print Friendly and PDF

Cloud Data Integration
for Developers

onDemand | IDMC Data Integration | Self-Paced | July 2025 Release

Course Overview

Master Informatica's Cloud Data Integration (CDI), its architecture, data integration services, and cloud mapping design. Explore techniques such as data transformations, mapplets, and taskflows, and dive into REST API connectivity and web service integrations for effective data management and automation. Through practical labs, learners will gain hands-on experience in building, deploying, and managing data workflows tailored to their business needs.
This course is applicable to July 2025 Release.

Important note regarding this onDemand course: Many students will need their personal laptop/PC to set up the lab environment and perform lab exercises. Laptops provided by your employer may not allow downloading external tools. To execute labs in full, students need to download and install the following tools. See Agenda below to view more details. If you are unable to complete this training due to these requirements, please consider Live Training.

  • Informatica Cloud Secure Agent
  • Microsoft SQL Server
  • Postman 


Objectives

After successfully completing this course, students should be able to:

  • Describe Informatica Cloud Architecture
  • Use Cloud Mapping Designer to create Mappings
  • Work with Data Integration Transformations
  • Define and execute Data Integration Mappings
  • Create Mapplets and work with them
  • Configure Mapping Tasks
  • Parameterize Mappings
  • Handle Exceptions in Mappings
  • Define a Synchronization task
  • Create a Data Transfer task
  • Create a Replication task
  • Configure Taskflows
  • Configure Mappings to Run using Web Services
  • Use IDMC REST APIs

Target Audience

  • Developer
To execute all labs within this course, students should download and install the following:
    • Informatica Cloud Secure Agent: 
      The Informatica Cloud Secure Agent is required to create connections to connect to various data sources with IICS.

    • Microsoft SQL: 
      Some of the course lab exercises are dependent on the Microsoft SQL database. You must install and configure Microsoft SQL database to perform these labs. If you do not have Microsoft SQL installed on your system, you can skip the labs that are Microsoft SQL database dependent and continue with the rest of the course and lab exercises.
    • Postman: 
      The postman application is required to perform REST APIs call and execute IDMC task using API.

Steps required to set up the lab environment are provided in the Getting Started lab guides for the course. Students must perform the Getting Started labs before executing the course lab exercises.



Agenda
Module 1: Informatica Intelligent Data Management Cloud Overview
  • Informatica Intelligent Data Management Cloud (IDMC) as an iPaaS solution
  • Using IDMC for ETL
  • Informatica Cloud Terminologies
  • Informatica Cloud Architecture
  • IDMC Interface Walkthrough
  • IDMC Services
  • Lab: Navigate the IDMC Interface
Module 2: Introduction to Data Integration Service
  • Discuss Data Integration Service
  • Pre-requisites to work with the Data Integration Service
  • Describe CDI Assets
  • Types of Runtime Environments
  • Define Connections
  • Lab: Install the Secure Agent
  • Lab: Create Flat File Connections
  • Lab: Create a Salesforce Connection
  • Lab: Create SQL Server Connections
  • Lab: Create a Connection to an AWS S3 bucket
Module 3: Basics of Cloud Mapping Designer
  • Cloud Mapping Designer Overview
  • Mapping Designer Terminologies
  • Mappings
  • Mapping Templates
  • CLAIRE Recommendations and Copilot
  • Mapplets
  • Transformations
  • Field Rules
  • Best Practices Guidelines
  • Lab: Build and Execute a Mapping to Load Data
Module 4: Data Integration Transformations
  • Joiner Transformation
  • Expression Transformation
  • Filter Transformation
  • Union Transformation
  • Sorter Transformation
  • Rank Transformation
  • Lookup Transformation
  • Router Transformation
  • Aggregator Transformation
  • Lab: Shipping Classification with Joiner, Expression, and Filter Transformations
  • Lab: Data Merging and Sorting with Union and Sorter Transformations
  • Lab: The Importance of Field Rules
  • Lab: Data Enrichment and Optimization Using Lookup and Expression Transformations
Module 5: Macro Introduction and Overview
  • Expression Macros
  • Vertical Macros
  • Horizontal Macros
  • Lab: Delta Detection Using the Joiner Transformation
Module 6: Mapplets
  • Mapplets Overview
  • Active and Passive Mapplet
  • Types of IDMC Mapplets
  • Mapplets Input and Output
  • Parameters in Mapplets
  • PowerCenter Mapplet
  • Create a Mapplet in IDMC
  • Mapplet Transformation
  • Lab: Enhance Mapping Efficiency with Reusable Mapplets and Conditional Data Routing
  • Lab: Summarize Sales Data with Mapplet and Aggregator Transformations
Module 7: Mapping Task
  • Mapping Task Overview
  • Create and Run a Mapping Task
  • Lab: Update Else Insert Logic in a Mapping
Module 8: Parameterization
  • What is Parameterization
  • Parameterization use case
  • Steps to add Parameters to a Mapping
  • Creating Parameters in a mapping
  • Parameter Types
  • Using Parameter files
  • In-Out Parameter in Mapplet
  • Parameter File Directory
  • Parameter Best Practices
  • Lab: Flexible Mapping Solutions: Parameterize Thresholds and Regional Connections
  • Lab: Incremental Data Loading with In-Out Parameters
Module 9: Exception Handling
  • Handle errors in Mappings and Mapping Tasks
  • Lab: Enhance Data Mappings with Custom Error Handling and Routing
Module 10: Synchronization Task
  • Overview
  • Definition Step
  • Source Step
  • Target Step
  • Data Filters Step
  • Field Mapping Step
  • Schedule Step
  • Lab: Create a Synchronization Task to Insert Data into Salesforce
  • Lab: Create a Synchronization Task to Transform and Load Data Using Expressions, Filtering, and Lookup Techniques
  • Lab: Load Data to Salesforce using a Saved Query in a Synchronization Task
  • Lab: Use the Upsert Operation in a Synchronization Task to Insert or Update Data in a SQL Server Table
Module 11: Data Transfer Task
  • Overview
  • Definition Step
  • Source Step
  • Second Source Step
  • Target Step
  • Field Mapping Step
  • Runtime Options Step
  • Lab: Backup Customer and Order Information using a Data Transfer Task
Module 12: Replication Task
  • Overview
  • Features
  • Source and Target Options
  • Other Replication Task Options
  • Resetting the Target Table
  • Generating Non-Unique Index
  • Lab: Replicate Salesforce Tables to Flat Files
Module 13: Taskflows
  • Overview
  • Linear Taskflows
  • Taskflow Steps
  • Taskflow Templates
  • Parameters in Taskflow
  • Error handling in Taskflows
  • Lab: Create a Linear Taskflow to run multiple Tasks in Sequence
  • Lab: Create a Taskflow with Conditional Logic
Module 14: Web Services
  • Overview
  • Business Services
  • Web Service Transformation
  • Lab: Transform Billing Data with Web Services: Number-to-Words Conversion
Module 15: IDMC REST APIs
  • REST API Overview
  • Informatica Cloud REST API
  • List of supported REST API Versions
  • Use REST APIs
  • Create REST V2 Connector
  • Lab: Create a Mapping Using a REST V2 Connector to Retrieve Weather Information
  • Lab: Use Informatica CDI to login to the Platform API and Run a Job

Enroll Now

Back to Course Overview

Power User Axon for Community Users (Instructor Led or onDemand) Axon Content Curation (Instructor Led) Axon for Power Users (Instructor Led) Axon Data Governance (Professional Certification) Axon Data Governance (Professional Certification) Axon Data Governance (Professional Certification) Some more content to make this bigger asdf asdf asdf

Informatica offers programs to extend learning in convenient and economic packages. Programs include self-paced subscriptions as well as bundled instructor led training and certifications. Each program is curated around a specific skillset to enable customer success.

365University Data Governance Annual Subscription

Informatica MasterPass Education Subscription

Informatica Learning Library

Data Governance & Privacy Journey Master

View Full Course Offerings