Informatica Cloud (Iics) - The Complete Guide 2023 Edition

Master IICS: Informatica Intelligent Cloud Services. Start from basics and learn how to build complete integration flows

What you'll learn

Use Informatica Cloud to build automated tasks & processes

Run simple and complex workflows on a broad variety of triggers

You will understand Informatica Cloud architecture

You will get to know different Informatica Cloud runtime environments and understand the differences between them

You will be able to create professional Informatica Cloud flows and system integrations

Build a variety of different Data Integration flows on multiple environments

Understand cloud and cloud computing concepts

You will learn Data Integration service, Application Integration service, Mass Ingestion service, Monitor service, Application Integration Console service

Requirements

NO prior Informatica Cloud knowledge is required, I will teach you everything about Informatica Cloud from fundamentals to more advanced topics

A Mac or PC computer with access to the internet

No paid software required - I will show you how to use Informatica Cloud trial account

I'll walk you through, step-by-step how to get all the software installed and set up

Basic knowledge of XML/JSON is good to have but not required

Description

This course teaches Informatica Intelligent Cloud Servcies (IICS) from the basics all the way to advanced topics, without any prior Informatica Cloud knowledge assumed or required.Every organisation has different applications and business systems that they use for particular processes and tasks. In order to keep up with the growing development and a huge number of new technologies storming the market, organizations are looking for for a better and more sufficient way to integrate new systems and technologies into their current technology stack. To solve this problem, organizations implement more and more Software Integration solutions, which are becoming more crucial for the business then ever, and with the expanditure of cloud technologies Software Integration solutions are increasingly based on cloud solutions and services.Informatica Cloud is one of the most popular and industry-leading cloud data integration, application and API integration solutions. It is a next-gen iPaaS solution which utilizes cloud and cloud computing to provide customers with user-friendly solutions that enable various integrations of data, residing in on-premise databases and systems or between cloud applications.Learn how to use Informatic Cloud for real-world tasks, such as database integration, REST/SOAP API integration, reading data from csv files and transforming it into xml, reshape XML payloads to meet target system requirements, task and process automation and much more!This course will teach you Informatica Cloud concepts in a practical manner, for every lecture with hands-on example comes an assignment lecture with instructions that you can use to practice Informatica Cloud integrations on your own so you can read and solve tasks in your own way. To kick start this course we will begin by learning cloud and cloud computing concepts which will allow you to fully understand and Informatica Cloud is and how it works, next we will dig deep into IICS architecture and setup the required software.In this course we cover a variety of topics, which includes:Creating IICS trial accountInstalling Secure AgentRunning IICS tasksScheduling IICS tasksData IntegrationApplication IntegrationFile IntegrationMass Ingestion Application Integration ConsoleMonitor ServiceAdministrator ServiceBasic Bash commandsJSON/XMLXPathPostmanREST/SOAP APICSV/Fixed-Width filesDebugging and Error Handlingand much more!You will get lifetime access to full IICS course which covers all new IICS features and services, this course will be frequently updated to keep up with all new technologies and features IICS brings. This course is a practice-oriented courses, exploring all key concepts whilst diving into concrete examples. You'll build different workflows for multiple projects and requirements.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Understand Cloud and Cloud Computing

Lecture 3 Different Types of Computing Cloud

Lecture 4 Get to Know Different Cloud Computing Models

Lecture 5 Cloud is a Hot Topic!

Section 2: Informatica Cloud Overview

Lecture 6 Key Integration Terminology

Lecture 7 What is IICS? IICS as an iPaaS solution

Lecture 8 Create Informatica Cloud Trial Account

Lecture 9 [Action] Create Informatica Cloud Trial Account

Lecture 10 Set Up Your Lab Environment

Lecture 11 [Action] Set Up Your Lab Environment

Lecture 12 Informatica Cloud Architecture

Lecture 13 Informatica Cloud Runtime Environments

Lecture 14 Secure Agent Architecture and Informatica Cloud Connectivity

Lecture 15 Secure Agent Log Files

Section 3: Informatica University and Trial Accounts

Lecture 16 Informatica University and IICS Documentation

Lecture 17 Re-register existing Informatica Cloud Secure Agent to new IICS Org

Section 4: Data Integration Services

Lecture 18 Introduction to Informatica Cloud Services

Lecture 19 Informatica Cloud Connections

Lecture 20 Create Salesforce Account

Lecture 21 [Action] Create Salesforce Account

Lecture 22 Create Salesforce Connection

Lecture 23 [Action] Create Salesforce Connection

Lecture 24 Load File Content into Salesforce

Lecture 25 [Action] Load File Content into Salesforce

Lecture 26 Cloud Mapping Designer and Data Integration Features

Lecture 27 [Action] Cloud Mapping Designer and Data Integration Features

Lecture 28 Update Account Objects in Salesforce

Lecture 29 [Action] Update Account Objects in Salesforce

Lecture 30 Update Account Objects with Lookup Transformation

Lecture 31 [Action] Update Account Objects with Lookup Transformation

Lecture 32 "Upsert" Accounts into Salesforce

Lecture 33 [Action] "Upsert" Accounts into Salesforce

Lecture 34 Delete Accounts from Salesforce

Lecture 35 [Action] Delete Accounts from Salesforce

Lecture 36 Informatica Cloud Environments

Lecture 37 [Action] Informatica Cloud Environments

Lecture 38 Activity Monitor Service

Section 5: Transformations in Informatica Cloud (Data Integration Service)

Lecture 39 Data Integration Transformations Joiner and Query in a Mapping

Lecture 40 [Action] Data Integration Transformations Joiner and Query in a Mapping

Lecture 41 Configure Oracle Database

Lecture 42 [Action] Configure Oracle Database

Lecture 43 Create a New Table and Connection to Oracle Database

Lecture 44 [Action] Create a New Table and Connection to Oracle Database

Lecture 45 Expression Transformation and Multiple Target Transformations (csv)

Lecture 46 [Action] Expression Transformation and Multiple Target Transformations (csv)

Lecture 47 Expression Transformation and Multiple Target Transformations (fixed-width)

Lecture 48 [Action] Expression Transformation and Multiple Target Transformations (fixed-w)

Lecture 49 Aggregator Transformation - Use Case and Properties

Lecture 50 [Action] Aggregator Transformation - Use Case and Properties

Lecture 51 Sorter Transformation - Use Case and Properties

Lecture 52 [Action] Sorter Transformation - Use Case and Properties

Lecture 53 Single Mapping with Multiple Flows and Router Transformation

Lecture 54 [Action] Single Mapping with Multiple Flows and Router Transformation

Lecture 55 File List, Normalizer and Rank Transformation - Use Case and Properties

Lecture 56 [Action] File List, Normalizer and Rank Transformation - Use Case and Properties

Lecture 57 Union and Sequence Transformation - Use Case and Properties

Lecture 58 [Action] Union and Sequence Transformation - Use Case and Properties

Lecture 59 Union vs Joiner Transformation

Lecture 60 [Action] Union vs Joiner Transformation

Lecture 61 Join Files with Command Source Type

Lecture 62 [Action] Join Files with Command Source Type

Section 6: Data Integration Tasks

Lecture 63 Synchronize Data with Synchronization Task

Lecture 64 [Action] Synchronize Data with Synchronization Task

Lecture 65 Replicate Oracle Tables Data to Flat Files Using Replication task

Lecture 66 [Action] Replicate Oracle Tables Data to Flat Files Using Replication task

Lecture 67 Use Masking Task to Mask Values in Salesforce "Contact" objects

Lecture 68 [Action] Use Masking Task to Mask Values in Salesforce "Contact" objects.

Lecture 69 Transfer Data from Salesforce to Local CSV File with Transfer Data Task

Lecture 70 [Action] Transfer Data from Salesforce to Local CSV File with Transfer Data Task

Lecture 71 Run PowerCenter Session in Data Integration with PowerCenter Task

Lecture 72 [Action] Run PowerCenter Session in Data Integration with PowerCenter Task

Section 7: Data Integration Parametrization - Intermediate

Lecture 73 Creating Completely Parametrized Mapping

Lecture 74 [Action] Creating Completely Parametrized Mapping

Lecture 75 Using Parameter File in a Mapping Task

Lecture 76 [Action] Using Parameter File in a Mapping Task

Section 8: Incremental Data Loading - Intermediate

Lecture 77 Implementing Incremental Data Loading using IICS System Variables

Lecture 78 [Action] Implementing Incremental Data Loading using IICS System Variables

Lecture 79 Implementing Incremental Data Loading using IICS Input-Output Parameters

Lecture 80 [Action] Implementing Incremental Data Loading using IICS Input-Output Parameter

Section 9: Expression Macros - Intermediate

Lecture 81 Use Vertical Macro to Generate a Set of The Same Expressions Vertically

Lecture 82 [Action] Use Vertical Macro to Generate a Set of The Same Expressions Vertically

Lecture 83 Use Horizontal Macro to Filter Null Values From The File

Lecture 84 [Action] Use Horizontal Macro to Filter Null Values From The File

Lecture 85 Expand Expression both Vertically and Horizontally using Hybrid Macro

Lecture 86 [Action] Expand Expression both Vertically and Horizontally using Hybrid Macro

Section 10: Hierarchy Transformations

Lecture 87 Convert Hierarchical Input (XML/JSON) into Relational Output

Lecture 88 [Action] Convert Hierarchical Input (XML/JSON) into Relational Output

Lecture 89 Convert Relational Input into Hierarchical Output (XML/JSON)

Lecture 90 [Action] Convert Relational Input into Hierarchical Output (XML/JSON)

Section 11: IICS Data Integration REST V2 Connector & WebServices Transformation

Lecture 91 What is a Web Service and REST API?

Lecture 92 Call REST API Using Postman

Lecture 93 Generate Swagger Files and Create Rest V2 Connections

Lecture 94 [Action] Generate Swagger Files and Create Rest V2 Connections

Lecture 95 Interact with REST Web Services using Rest V2 Connector

Lecture 96 [Action] Interact with REST Web Services using Rest V2 Connector

Lecture 97 SOAP API Description and Call Using Postman

Lecture 98 [Action] SOAP API Description and Call Using Postman

Lecture 99 Interact with SOAP Web Services using WSConsumer Connector

Lecture 100 [Action] Interact with SOAP Web Services using WSConsumer Connector

Section 12: Data Integration Transformations and Feature's part 2

Lecture 101 Build Your Data Model with Intelligent Structure Model

Lecture 102 [Action] Build Your Data Model with Intelligent Structure Model

Section 13: Mass Ingestion Service

Lecture 103 Perform File Transfer with File Ingestion Task

Lecture 104 [Action] Perform File Transfer with File Ingestion Task

Lecture 105 Create File Listener Component

Lecture 106 [Action] Create File Listener Component

Lecture 107 Use File Listener Component to Trigger File Ingestion Task

Lecture 108 [Action] Use File Listener Component to Trigger File Ingestion Task

Lecture 109 Build and Use Database Ingestion Tasks

Lecture 110 Build and Use Database Ingestion Tasks (Schema Directory)

Lecture 111 [Action] Configure Kafka Event Streaming Platform

Lecture 112 Create Kafka Topic and Kafka Connection

Lecture 113 [Action] Create Kafka Topic and Kafka Connection

Lecture 114 Transform and Ingest data to Kafka Topic in Real-Time

Lecture 115 [Action] Transform and Ingest data to Kafka Topic in Real-Time

Section 14: Application Integration Service - Beginner Level

Lecture 116 Application Integration Introduction

Lecture 117 [Action] Application Integration Introduction

Lecture 118 Create your first process in Application Integration Service

Lecture 119 [Action] Create your first process in Application Integration Service

Lecture 120 Return User Input as Output Inside Application Integration Process

Lecture 121 [Action] Return User Input as Output Inside Application Integration Process

Lecture 122 Create API and Process XML Payload Using XPath

Lecture 123 [Action] Create API and Process XML Payload Using XPath

Lecture 124 Create Service Connector and Send Source Data to Target API

Lecture 125 [Action] Create Service Connector and Send Source Data to Target API

Lecture 126 Optimize Service Connector by Using Reusable Connection Fields

Lecture 127 [Action] Optimize Service Connector by Using Reusable Connection Fields

Section 15: Application Integration Service - Intermediate Level

Lecture 128 Move Processing Logic to Subprocess and Invoke it From the Main Process

Lecture 129 [Action] Move Processing Logic to Subprocess and Invoke it From the Main Process

Lecture 130 Process XML Input Inside a Loop to Produce Required XML Output

Lecture 131 [Action] Process XML Input Inside a Loop to Produce Required XML Output

Lecture 132 Read Data From CSV File and Transform it Into XML Payload Part 1

Lecture 133 [Action] Read Data From CSV File and Transform it Into XML Payload Part 1

Lecture 134 Read Data From CSV File and Transform it Into XML Payload Part 2

Lecture 135 [Action] Read Data From CSV File and Transform it Into XML Payload Part 2

Lecture 136 Mass Ingestion Service and Other IICS Services

If you are a complete beginner then this course will guide and help you to become a Informatica Cloud developer,Developers who want to explore Informatica Cloud services and tools,If you are an intermediate Informatica Cloud developer then this course will help you to raise your skills and get a better understanding of IICS processes,Beginner or advanced Cloud Integration developers who want to expand their technology stack and learn Informatica Cloud,Cloud/BI/ETL/DW Professionals,Everyone interested in cloud and softoware integration topics