ExistBI deliver the following 2-day live instructor-led onsite or virtual Informatica IICS Cloud Data Integration Services 101 training. An introduction to Informatica Intelligent Cloud Services (IICS) Cloud Data Integration services intended for users who wish to integrate data across cloud-based applications and on premise systems, databases and data warehouses. This class addresses specific business processes (customer/product master synchronization, and others) and point-to-point data integration for example, Salesforce.com to on premise end-points, as well as best practices for cloud-based data integration.

Target Audience: Business Analyst, Developer

Pre-requisites: None

Delivery Method: Instructor Led Onsite & Virtual Classroom


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

  • Build and run Tasks, Mappings, and Taskflows
  • Install the Informatica Cloud Secure Agent
  • Automate data integration jobs
  • Use Cloud Mapping Designer and create Mapping Tasks
  • Use advanced features to enhance and optimize integrations
  • Perform administration tasks in IICS org

Official Agenda

Module 1: Informatica Cloud Overview

  • Informatica Cloud
  • Object Synchronization
  • Process Synchronization
  • Data Replication and Archiving
  • Informatica Cloud Applications
  • Informatica Cloud – Key Terms

Module 2: Informatica Cloud Secure Agent and Architecture

  • Informatica Cloud Architecture
  • Informatica Cloud Secure Agent
  • Informatica Secure Agent Architecture
  • Agent Log File
  • Running Agent as Local/Network User

Module 3: Creating Connections

  • Connection Properties
  • Connection types
  • Configuring a connection
  • Creating a Salesforce.com Connection
  • Creating a Flat File Connection

Module 4: Data Synchronization Application

  • Data Synchronization application
  • Data Synchronization Operations
  • Field Information
  • Activity Logs
  • Log file types

Module 5: Relationships and Integration

  • Purpose of external ID
  • External ID fields in Salesforce.com
  • Foreign Keys
  • Salesforce ID
  • Data Synchronization Operations – IDs

Module 6: Qualifying and Transforming Source Data

  • Data Filter
  • Simple and Advanced Data Filter
  • System Variables in a Data Filter
  • Incremental Processing
  • Field Expression

Module 7: Advanced Source Options

  • Multiple Object Source Type
  • Salesforce Objects – Options
  • Salesforce Data Model and ERDs
  • Saved Queries

Module 8: Field Lookups

  • Lookup Overview
  • Configuring a Lookup
  • Lookup Best Practices

Module 9: Data Replication Application

  • Data Replication App Overview
  • Data Replication Features and Benefits
  • Data Replication Source and Target Options
  • Other Data Replication Task Options
  • Resetting the Target Table
  • Non-Unique Index

Module 10: Automating and Monitoring Tasks

  • Schedules
  • Schedule Repeat Frequency
  • Repeat Frequency Options
  • Schedule Blackout Period
  • Task Flow
  • Email Notifications
  • Informatica Cloud Mobile App

Module 11: Cloud Mapping Designer – Part I

  • Cloud Mapping Designer use cases
  • Mapping Lifecycle
  • Transformations in Cloud Mapping Designer
  • Mapping Validation
  • Creating a Simple Mapping using a Source, Filter, and Multiple Targets

Module 12: Cloud Mapping Designer – Part II

  • Joiner, Expression, and Lookup transformations
  • Field Rules: Renaming Fields, Selection Criteria
  • Creating a Mapping using the Lookup and Expression Transformations

Module 13: Mapping Task and Mapping Parameters

  • Mapping Task
  • Parameterization use cases
  • Adding Parameters to a Mapping
  • Parameter Types
  • Parameter Panel and Best Practices
  • Mapping Updates and Deployment
  • Creating, testing, and running a Mapping Task

Module 14: Advanced Task Options

  • Pre and Post-Processing Commands
  • Operating System Commands
  • Parameter File
  • Setting Up a Parameter File

Module 15: Advanced Salesforce Options

  • Salesforce target batch size
  • Salesforce bulk API
  • Salesforce outbound messaging to trigger a synchronization task

Module 16: Data Masking Application

  • Data Masking Service
  • Data Subset: Row Limits and Data Filters
  • Building, testing, and running a Data Masking task

Module 17: Administration

  • User Roles
  • User Groups
  • Object level permissions
  • Organization hierarchy
  • Migrating Assets

Module 18: Linear Taskflow

  • Linear Taskflow Overview
  • Tasks included in a Linear Taskflow
  • Properties of a Linear Taskflow
  • Scheduling a Taskflow

Module 19: Mass Ingestion Task

  • Mass Ingestion Task Overview
  • Functionalities
  • Configure Mass Ingestion Task