Informatica Cloud (IICS) - The Complete Guide 2023 Edition

Focused View

Radosław Janas

9:24:36

14 View

1. Introduction

1. Introduction.mp4

01:38

2. Understand Cloud and Cloud Computing.mp4

03:35

3. Different Types of Computing Cloud.mp4

04:25

4. Get to Know Different Cloud Computing Models.mp4

03:49

5. Cloud is a Hot Topic!.mp4

04:20

6. Quiz Time!.html

2. Informatica Cloud Overview

1. Key Integration Terminology.mp4

02:05

2. What is IICS IICS as an iPaaS solution.mp4

05:01

3. Create Informatica Cloud Trial Account.mp4

05:10

4.1 30 Days Free Cloud Data Integration Trial Account.html

4.2 Informatica University Training Paths.html

4. [Action] Create Informatica Cloud Trial Account.html

5. Set Up Your Lab Environment.mp4

05:29

6. [Action] Set Up Your Lab Environment.html

7. Informatica Cloud Architecture.mp4

02:54

8. Informatica Cloud Runtime Environments.mp4

07:15

9. Secure Agent Architecture and Informatica Cloud Connectivity.mp4

04:33

10. Secure Agent Log Files.mp4

02:53

3. Informatica University and Trial Accounts

1. Informatica University and IICS Documentation.mp4

06:33

2. Re-register existing Informatica Cloud Secure Agent to new IICS Org.html

4. Data Integration Services

1. Introduction to Informatica Cloud Services.mp4

04:34

2. Informatica Cloud Connections.mp4

02:08

3. Create Salesforce Account.mp4

01:05

4. [Action] Create Salesforce Account.html

5.1 Salesforce Developer Account Sign up.html

5. Create Salesforce Connection.mp4

02:22

6. [Action] Create Salesforce Connection.html

7. Load File Content into Salesforce.mp4

06:48

8.1 Accounts.csv

8. [Action] Load File Content into Salesforce.html

9. Cloud Mapping Designer and Data Integration Features.mp4

05:09

10. [Action] Cloud Mapping Designer and Data Integration Features.html

11.1 Accounts(custom+formating).csv

11.2 Accounts(with+Salesforce+IDs).csv

11. Update Account Objects in Salesforce.mp4

05:57

12. [Action] Update Account Objects in Salesforce.html

13. Update Account Objects with Lookup Transformation.mp4

05:03

14. [Action] Update Account Objects with Lookup Transformation.html

15.1 Accounts(new+companies).csv

15. Upsert Accounts into Salesforce.mp4

07:00

16.1 Accounts(new+companies).csv

16. [Action] Upsert Accounts into Salesforce.html

17.1 Accounts(new+companies+less+employees).csv

17. Delete Accounts from Salesforce.mp4

10:11

18. [Action] Delete Accounts from Salesforce.html

19. Informatica Cloud Environments.mp4

05:10

20. [Action] Informatica Cloud Environments.html

21. Activity Monitor Service.mp4

04:01

5. Transformations in Informatica Cloud (Data Integration Service)

1. Data Integration Transformations Joiner and Query in a Mapping.mp4

09:43

2.1 Products.csv

2.2 Products.txt

2. [Action] Data Integration Transformations Joiner and Query in a Mapping.html

3. Configure Oracle Database.mp4

07:21

4. [Action] Configure Oracle Database.html

5.1 orders.zip

5. Create a New Table and Connection to Oracle Database.mp4

02:43

6. [Action] Create a New Table and Connection to Oracle Database.html

7.1 Big Order.csv

7.2 Products.csv

7.3 Products.txt

7.4 Small Order.csv

7. Expression Transformation and Multiple Target Transformations (csv).mp4

08:13

8.1 Big Order.csv

8.2 Products.csv

8.3 Products.txt

8.4 Small Order.csv

8. [Action] Expression Transformation and Multiple Target Transformations (csv).html

9.1 Big Order Fixed Width.csv

9.2 Products.txt

9.3 Small Order Fixed Width.csv

9. Expression Transformation and Multiple Target Transformations (fixed-width).mp4

07:58

10.1 Big Order Fixed Width.csv

10.2 Products.txt

10.3 Small Order Fixed Width.csv

10. [Action] Expression Transformation and Multiple Target Transformations (fixed-w).html

11. Aggregator Transformation - Use Case and Properties.mp4

10:28

12.1 Employee Profit 2022.csv

12.2 Employee Sum Profit 2022.csv

12. [Action] Aggregator Transformation - Use Case and Properties.html

13. Sorter Transformation - Use Case and Properties.mp4

04:56

14. [Action] Sorter Transformation - Use Case and Properties.html

15.1 Employee Profit 2022.csv

15. Single Mapping with Multiple Flows and Router Transformation.mp4

17:00

16.1 Employee Profit 2022.csv

16. [Action] Single Mapping with Multiple Flows and Router Transformation.html

17.1 Employee Profit 2022.csv

17.2 Employee Profit part2 2022.csv

17.3 Employee Sum Profit two files%T%m%Y.csv

17.4 filelist.txt

17.5 Top 5 Best Employee Sum Profit.csv

17. File List, Normalizer and Rank Transformation - Use Case and Properties.mp4

12:32

18.1 Employee Profit 2022.csv

18.2 Employee Profit part2 2022.csv

18.3 Employee Sum Profit two files%T%m%Y.csv

18.4 filelist.txt

18.5 Top 5 Best Employee Sum Profit.csv

18. [Action] File List, Normalizer and Rank Transformation - Use Case and Properties.html

19. Union and Sequence Transformation - Use Case and Properties.mp4

09:06

20. [Action] Union and Sequence Transformation - Use Case and Properties.html

21.1 Employees 2022.csv

21.2 Employees additional information.csv

21. Union vs Joiner Transformation.mp4

07:07

22.1 Employees 2022.csv

22.2 Employees additional information.csv

22. [Action] Union vs Joiner Transformation.html

23. Join Files with Command Source Type.mp4

08:32

24.1 Employees numbers 1.csv

24.2 Employees numbers 2.csv

24. [Action] Join Files with Command Source Type.html

6. Data Integration Tasks

1.1 Accounts Synchronization.csv

1. Synchronize Data with Synchronization Task.mp4

05:59

2.1 Accounts Synchronization.csv

2. [Action] Synchronize Data with Synchronization Task.html

3.1 sample oracle tables.txt

3. Replicate Oracle Tables Data to Flat Files Using Replication task.mp4

05:35

4.1 sample oracle tables.txt

4. [Action] Replicate Oracle Tables Data to Flat Files Using Replication task.html

5. Use Masking Task to Mask Values in Salesforce Contact objects.mp4

07:37

6. [Action] Use Masking Task to Mask Values in Salesforce Contact objects..html

7.1 Salesforce contacts summary.csv

7.2 Salesforce contacts.csv

7. Transfer Data from Salesforce to Local CSV File with Transfer Data Task.mp4

04:48

8.1 Salesforce contacts summary.csv

8.2 Salesforce contacts.csv

8. [Action] Transfer Data from Salesforce to Local CSV File with Transfer Data Task.html

9. Run PowerCenter Session in Data Integration with PowerCenter Task.mp4

06:39

10.1 Customer orders.csv

10.2 Userguide 2111.pdf

10.3 wf m default column formatting.zip

10. [Action] Run PowerCenter Session in Data Integration with PowerCenter Task.html

7. Data Integration Parametrization - Intermediate

1. Creating Completely Parametrized Mapping.mp4

14:34

2.1 Cheap Products.csv

2.2 Expensive Products.csv

2. [Action] Creating Completely Parametrized Mapping.html

3. Using Parameter File in a Mapping Task.mp4

13:39

4.1 Cheap Products.csv

4.2 Creating Sections Inside Parameter File Informatica Cloud Documentation.html

4.3 Expensive Products.csv

4.4 Parameter File Informatica Cloud Documentation.html

4. [Action] Using Parameter File in a Mapping Task.html

8. Incremental Data Loading - Intermediate

1.1 SQL+Script.txt

1. Implementing Incremental Data Loading using IICS System Variables.mp4

11:04

2.1 SQL+Script.txt

2. [Action] Implementing Incremental Data Loading using IICS System Variables.html

3. Implementing Incremental Data Loading using IICS Input-Output Parameters.mp4

08:04

4. [Action] Implementing Incremental Data Loading using IICS Input-Output Parameter.html

9. Expression Macros - Intermediate

1. Use Vertical Macro to Generate a Set of The Same Expressions Vertically.mp4

10:26

2.1 cleansed data static file.csv

2.2 data to be cleansed.txt

2. [Action] Use Vertical Macro to Generate a Set of The Same Expressions Vertically.html

3. Use Horizontal Macro to Filter Null Values From The File.mp4

04:55

4.1 data with null values.txt

4.2 vertical macro.csv

4. [Action] Use Horizontal Macro to Filter Null Values From The File.html

5. Expand Expression both Vertically and Horizontally using Hybrid Macro.mp4

05:39

6.1 data to be cleansed.txt

6.2 hybrid macro.csv

6. [Action] Expand Expression both Vertically and Horizontally using Hybrid Macro.html

10. Hierarchy Transformations

1. Convert Hierarchical Input (XMLJSON) into Relational Output.mp4

11:11

2.1 sample customersorders.zip

2.2 sample customersorders.zip

2. [Action] Convert Hierarchical Input (XMLJSON) into Relational Output.html

3. Convert Relational Input into Hierarchical Output (XMLJSON).mp4

09:09

4.1 sample file.zip

4. [Action] Convert Relational Input into Hierarchical Output (XMLJSON).html

11. IICS Data Integration REST V2 Connector & WebServices Transformation

1. What is a Web Service and REST API.mp4

07:26

2.1 Free API Tutorial.html

2.2 Free Postman Tutorial.html

2.3 Link to the API.html

2. Call REST API Using Postman.mp4

11:35

3. Generate Swagger Files and Create Rest V2 Connections.mp4

09:05

4. [Action] Generate Swagger Files and Create Rest V2 Connections.html

5.1 Users to be added.txt

5. Interact with REST Web Services using Rest V2 Connector.mp4

05:48

6. [Action] Interact with REST Web Services using Rest V2 Connector.html

7. SOAP API Description and Call Using Postman.mp4

05:52

8.1 SOAP Web Service.html

8. [Action] SOAP API Description and Call Using Postman.html

9. Interact with SOAP Web Services using WSConsumer Connector.mp4

05:59

10.1 Numbers to be transformed into words.txt

10. [Action] Interact with SOAP Web Services using WSConsumer Connector.html

12. Data Integration Transformations and Features part 2

1. Build Your Data Model with Intelligent Structure Model.mp4

06:28

2.1 username-password additional column.csv

2.2 username-passwords.csv

2. [Action] Build Your Data Model with Intelligent Structure Model.html

13. Mass Ingestion Service

1. Perform File Transfer with File Ingestion Task.mp4

12:28

2. [Action] Perform File Transfer with File Ingestion Task.html

3. Create File Listener Component.mp4

06:32

4. [Action] Create File Listener Component.html

5. Use File Listener Component to Trigger File Ingestion Task.mp4

06:03

6. [Action] Use File Listener Component to Trigger File Ingestion Task.html

7. Build and Use Database Ingestion Tasks.mp4

07:35

8. Build and Use Database Ingestion Tasks (Schema Directory).html

9. [Action] Configure Kafka Event Streaming Platform.html

10. Create Kafka Topic and Kafka Connection.mp4

05:21

11. [Action] Create Kafka Topic and Kafka Connection.html

12.1 Factory Details.csv

12. Transform and Ingest data to Kafka Topic in Real-Time.mp4

07:30

13.1 Factory Details.csv

13. [Action] Transform and Ingest data to Kafka Topic in Real-Time.html

14. Application Integration Service - Beginner Level

1. Application Integration Introduction.mp4

03:51

2. [Action] Application Integration Introduction.html

3. Create your first process in Application Integration Service.mp4

12:53

4. [Action] Create your first process in Application Integration Service.html

5. Return User Input as Output Inside Application Integration Process.mp4

10:38

6. [Action] Return User Input as Output Inside Application Integration Process.html

7.1 Customers source payload xml.txt

7.2 Customers target payload xml.txt

7. Create API and Process XML Payload Using XPath.mp4

14:33

8. [Action] Create API and Process XML Payload Using XPath.html

9. Create Service Connector and Send Source Data to Target API.mp4

13:54

10. [Action] Create Service Connector and Send Source Data to Target API.html

11. Optimize Service Connector by Using Reusable Connection Fields.mp4

06:54

12. [Action] Optimize Service Connector by Using Reusable Connection Fields.html

15. Application Integration Service - Intermediate Level

1. Move Processing Logic to Subprocess and Invoke it From the Main Process.mp4

10:56

2. [Action] Move Processing Logic to Subprocess and Invoke it From the Main Process.html

3. Process XML Input Inside a Loop to Produce Required XML Output.mp4

16:38

4. [Action] Process XML Input Inside a Loop to Produce Required XML Output.html

5. Read Data From CSV File and Transform it Into XML Payload Part 1.mp4

12:41

6.1 csv transformed to xml.txt

6.2 Sample Customers Input.csv

6. [Action] Read Data From CSV File and Transform it Into XML Payload Part 1.html

7. Read Data From CSV File and Transform it Into XML Payload Part 2.mp4

14:36

8.1 Sample Customers Input.csv

8. [Action] Read Data From CSV File and Transform it Into XML Payload Part 2.html

9. Mass Ingestion Service and Other IICS Services.mp4

05:14

Description

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

Who is this for?

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

What You Need to Know?

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

More details

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 account
Installing Secure Agent
Running IICS tasks
Scheduling IICS tasks
Data Integration
Application Integration
File Integration
Mass Ingestion
Application Integration Console
Monitor Service
Administrator Service
Basic Bash commands
JSON/XML
XPath
Postman
REST/SOAP API
CSV/Fixed-Width files
Debugging and Error Handling
and 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.
Who this course is for:
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

User Reviews

Rating

average 0

Total votes0

Focused display

Cloud Computing

Radosław Janas

Instructor's Courses

Hi there,My name is Radosław, I'm a Software Integration Developer with a passion for teaching. I'm currently working as Software Integration Developer in full-time for one of the biggest pharmaceutical companies in the world. I created hundreds of integration flows and processes in order to solve the daily struggles companies face with various system, data and application integrations. In my spare time I enjoy doing researches about new technologies and Integration platforms. During my career I realised one of my greatest passions is teaching, I consider my job to make learning software integration concepts as fun as possible and at the same time keep it as practical and proffesional as possible to enable students use knowledge they learned in their daily work. Have a great time learning!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.