Print Friendly and PDF

IICS: Cloud Data
Integration Services

onDemand | IDMC Data Integration | Self-Paced | Release 41


Please be aware that this course is retiring as it was revamped and split into the following courses available as a more up-to-date version:

Cloud Data Integration for Developers (onDemand)

Cloud Data Integration for Developers, Advanced (onDemand)

View the new training path here.




Course Overview

Learn the fundamentals of Informatica Intelligent Cloud Services (IICS) including the architecture and data integration features, synchronization tasks, cloud mapping designer, masking tasks, and replication tasks. This course enables you to operate and manage user security, secure agents, and monitor tasks and resources in IICS.
This course is applicable to Release 41.

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
  • Oracle
  • Kafka and Zookeeper
  • Postman 


Objectives

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

  • Describe Informatica Cloud Architecture
  • Install the secure agent and create connections
  • Create Synchronization task
  • Create Data Transfer task
  • Use Cloud Mapping Designer to create Mappings and Mapping tasks
  • Create a Replication task
  • Create a Masking task
  • Create a Mass Ingestion task
  • Create Taskflows
  • Use IICS REST web services for data integration
  • Use Intelligent Structure Model to parse data
  • Handle exceptions
  • Use advanced data integration features to optimize performance of jobs
  • Automate and monitor tasks
  • Configure advanced administration settings in IICS
  • Distinguish users and groups
  • Configure custom roles in IICS
  • Asset Management

Target Audience - Informatica Partners only

  • Developer
  • Operator
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.

    • Oracle: 
      Some of the course lab exercises are dependent on Oracle database (see ** within agenda below). You must install and configure Oracle database to perform these labs. If you do not have Oracle installed on your system, you can skip the labs that are Oracle database dependent and continue with the rest of the course and lab exercises.

    • Kafka and Zookeeper: 
      The Kafka and Zookeeper installation is only required for performing Streaming Ingestion Task lab exercise (Lab 10-1). You can only execute this lab if the Mass Ingestion service is enabled in your Org. If the service is not enabled, you can refer to the demonstration provided in the lab to understand the working of streaming ingestion task.

    • Postman: 
      The postman application is required to perform REST APIs call and execute IICS task using API.

Steps required to setup 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 Cloud Overview
  • Informatica Intelligent Cloud Services (IICS) as an iPaaS solution
  • Informatica Cloud Terminologies
  • Informatica Cloud Architecture
  • CDI Assets
  • CDI Components
  • Lab: Navigating the IICS interface
Module 2: Runtime Environments and Connections
  • Runtime Environments
  • Secure Agent Architecture
  • Secure Agent Status
  • Configuring Firewall for Secure Agent
  • Elastic Server
  • Secure Agent Services
  • IICS Log Files
  • Connections
  • Connection Types
  • Creating Connections
  • Lab: Installing IICS Secure Agent
  • Lab: Creating a Salesforce connection
  • Lab: Creating a Flat File connection
  • Lab: Creating an Oracle connection**
Module 3: Synchronization and Data Transfer Task
  • Synchronization Task Overview
  • Synchronization Task – Definition Step
  • Synchronization Task – Source Step
  • Synchronization Task – Target Step
  • Synchronization Task – Data Filters Step
  • Synchronization Task – Field Mapping Step
  • Synchronization Task – Schedule Step
  • Data transfer tasks Overview
  • Data transfer tasks – Source and Target
  • Activity Monitor
  • Lab: Creating a Synchronization Task
  • Lab: Using Filter, Expression and Lookup in a Synchronization Task
  • Lab: Creating a Data Transfer Task**
Module 4: Cloud Mapping Designer
  • Cloud Mapping Designer Overview
  • Mapping Designer Terminologies
  • CLAIRE Transformation Recommendations
  • Copying Transformation
  • Mapping Data Preview
  • Customizing Mapping Preview
  • Field Rules
  • Best Practices for Creating Mappings
  • Data flow run order
  • Mapping Task
  • Dynamic Schema Change
  • Deploy mapping updates
Module 5: Cloud Mapping Designer - Transformations
  • Source Transformation
  • Target Transformation
  • Filter Transformation
  • Joiner Transformation
  • Expression Transformation
  • Lookup Transformation
  • Union Transformation
  • Mapplets
  • SQL Transformation
  • Aggregator Transformation
  • Normalizer Transformation
  • Rank Transformation
  • Data Masking Transformation
  • Java Transformation
  • Lab: Using Query in a Mapping**
  • Lab: Using Normalizer, Aggregator, and Rank transformations in a mapping
  • Lab: Using Unconnected Lookup transformation in a mapping**
  • Lab: Using Mapplet transformation in a mapping
Module 6: Mapping Parameters
  • Parameterization use cases
  • Adding Parameters to a Mapping
  • Creating parameters
  • Parameter Types
  • Using parameter files
  • In-Out Parameter in Mapplet
  • Parameter File Directory
  • Parameter Best Practices
  • Lab: Performing Complete Parameterization
  • Lab: Using Parameter File in a Mapping task
  • Lab: Using In-Out parameters for incremental data loading**
Module 7: Expression Macro and Dynamic Linking
  • Expression Macro
  • Dynamic Linking
  • Lab: Using Expression Macro in a mapping
  • Lab: Using Dynamic Linking in a mapping
Module 8: Replication Task
  • Replication Task Overview
  • Replication Task Features
  • Replication Task: Source and Target Options
  • Other Replication Task Options
  • Resetting the Target Table
  • Generating Non-Unique Index
  • Appendix: Replicating Data to a Flat file
Module 9: Masking Task
  • Masking Task Overview
  • Masking Task: Source and Target Options
  • Data Subset: Row Limits and Data Filters
  • Field Masking Rules
  • Masking Rule Types
  • Refresh Masking Task metadata
  • Reset a Masking Task
  • Masking Best Practices
  • Appendix: Creating a Masking Task
Module 10: Mass Ingestion Task
  • Mass Ingestion Task Overview
  • Functionalities
  • Configuring a Mass Ingestion Task
  • File Ingestion Task
  • Database Ingestion Task
  • Streaming Ingestion Task
  • Lab: Creating a Streaming Ingestion Task
Module 11: Taskflows
  • Taskflow overview
  • Linear Taskflows
  • File Listener Enhancements
  • Taskflow Steps
  • Taskflow Templates
  • Parameters in Taskflow
  • Using REST APIs
  • File Listener
  • Invoke a Taskflow through a File Listener
  • Lab: Passing in-out parameters in a Taskflow**
  • Lab: Invoking a Taskflow through a File Listener
Module 12: Hierarchical Connectivity
  • Web Service transformation
  • REST V2 Connector
  • Hierarchical Schemas
  • Hierarchy Parser Transformation
  • Hierarchy Builder Transformation
  • Lab: Creating a mapping using a REST V2 connector
  • Lab: Using Web Services transformation in a mapping
  • Lab: Using Hierarchy Parser and Hierarchy Builder Transformation
Module 13: Intelligent Structure Model
  • Intelligent Structure Model
  • Intelligent Structure Discovery Process
  • Intelligent Structure Example
  • Refining a Discovered Structure
  • Editing an Intelligent Structure Model
  • Intelligent structure models based on an XSD file
  • Using intelligent structure models in Structure Parser transformation
  • Lab: Creating an Intelligent Structure Model
  • Lab: Using Structure Parser transformation in a mapping
Module 14: Advanced Task Settings and Performance Tuning  
  • Primary Key Chunking
  • Lookup SQL Override
  • Partitions Overview
  • Types of Partitions
  • Partitioning Rules and Guidelines
  • Pushdown optimization overview
  • Types of pushdown optimization
  • Pushdown optimization user-defined parameters
  • Secure agent groups
  • Shared secure agent groups
  • DTM performance properties
Module 15: Exception Handling
  • Types of exceptions
  • User-defined exceptions
  • Non-fatal exceptions
  • Default Field Value Setting
  • Row Error Logging
  • Error handling settings
  • Fatal exceptions
  • Bad files or Reject files
  • Lab: Creating a mapping to handle non-fatal errors
Module 16: Automating and Monitoring Tasks
  • Schedules
  • Schedule Repeat Frequency
  • Schedule Blackout Period
  • Schedule Export
  • Monitoring tasks
  • Email Notifications
  • Event Monitoring
  • Lab: Creating a schedule
Module 17: Administration
  • Licenses
  • Administrator Service
  • User Roles (System-defined Roles and Custom Roles)
  • Creating a User
  • User Groups
  • User Statistics
  • Permissions
  • Object-Level Permissions
  • Organization Hierarchy
  • Sub-Organization
  • Importing and Exporting Assets
  • Asset Dependency
  • Add-on Bundles
  • Lab: Configure Administrative settings for your Informatica Cloud org
  • Lab: Creating a sub-organization and importing/exporting assets
  • Lab: Managing Assets in Org
Module 18: IICS APIs
  • REST API overview
  • Informatica Cloud REST API
  • REST API Versions
  • Request Header and Request Body configuration
  • Return Lists
  • Lab: Running a Mapping task using REST API
** Oracle required for this lab

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