Deep-dive into Oracle Integration-3

About Instructor

Ankur Jain

Oracle

Technology

BUY NOW

Course Overview

In this course, you will learn Oracle Integration Cloud-3 with n number of real-time examples step by step. This course is designed for all levels of the audience such as beginners, and professionals. After completing this course, you will be very confident to jump into real-time projects without any help and even you can guide your teammates on how to use the Oracle Integration Cloud.

The course will help you to crack the 1Z0 1042: Oracle Cloud Platform Application Integration 2022 Professional Exam.

Below are the benefits of the course:

A lot of real-time examples are executed step-by-step
Compare Oracle Integration-2 and Oracle Integration-3 side by side
Know about the various service limits of each and every adapter before you start using it
Get into the depth of Oracle Integration and become an Oracle Integration developer expert
Clear your basics and become a perfect Oracle Integration developer
Covers a lot of inbuilt adapters including REST, SOAP, FTP, File REST, SOAP, ERP, HCM, Salesforce, etc,
Learn how the operations team will monitor the runtime interfaces and take preventive actions in case the interface fails.
Questions and Answers support
The course is regularly updated with a new set of features of Oracle Integration released every quarter

Please keep posting your questions in case any doubts.

What you'll learn

Deep understanding of Oracle Integration-3
Learn how to implement Oracle Integration in projects
Get into the depth of various adapters and it’s use-cases step by step
Help your customers to implement Oracle Integration with best practices
Attempt and clear your Oracle Integration Certification
Learn how to handle exceptions, best practices, administration of integrations

Who this course is for:

Oracle ERP consultant who would like to integrate the Oracle ERP system
Developers who need to develop integrations between various systems
Administrator who are responsible to monitors the runtime integrations
Mangers who wanted to understand how integration works between multiple systems

Requirements

No programming language experience is required. Little knowledge of APIs is good to have
Know everything in this course to learn Oracle Integration

Course Details

Course Outline

Overview and features of Oracle Integration-3

Introduction of Oracle Integration 3 Course
Overview of Oracle Integration 3
Features of Oracle Integration 3
Oracle Integration Gen-2 vs Oracle Integration Gen-3
Oracle Integration Gen-3 New Features

Provisioning Oracle Cloud Account and Oracle Integration Instance

Oracle Cloud Infrastructure (OCI) Free Tier
Create Oracle Cloud Infrastructure (OCI) Free Tier Account
Login into Oracle Cloud Infrastructure (OCI) Free Tier Account
Understanding of Oracle Integration provisioning terms
Provisioning, Updating & Accessing Oracle Integration 3 Instance

User Provisioning and Oracle Integration Terminologies

Know about Oracle Integration Application Roles and Identity Domain
Creating Users, Groups and Assigning Oracle Integration App Roles to Users
Know about Oracle Integration Building Blocks
Walking you through all the Integration Navigations
Get to know all the steps to create and deploy integrations

Exploring and working with REST adapter

Exploring the capabilities of REST Adapter
Creating and deploying your first REST API using Oracle Integration
Consuming public REST APIs in Oracle Integration
Protecting REST API using OAuth2.0
Consume REST API which are protected using API Key
Expose REST API to send Attachments
Consume External REST API that accept Attachment in Request
Creating REST Connection using “OAuth Authorization Code Credentials” Policy
Consume OCI REST API and Configure OCI Signature Version 1 Policy

Exploring and working with SOAP adapter

Explore SOAP adapter and it’s Capabilities
Create your own SOAP API in Oracle Integration using SOAP Adapter
Consuming External SOAP API
Download File from Universal Content Management (UCM) using SOAP API

Understanding and confiure the Oracle Integration File Server

Understand about File Server and how to enable it
Configuring File Server Settings

Exploring and working with FTP adpater in Oracle Integration

Learn about FTP Adapter
How to create FTP Connection
Performing Create, READ, DELETE Operation using FTP Adapter
Understand the Stage File Action capabilites
Understanding of PGP Encryption / Decryption on Files
Perform PGP Encryption / Decryption on Files using FTP adapter
How to search data from CSV files
Read Latest File from FTP location

Understanding the Scheduled Orchestration pattern

Learn about Scheduled Orchestration Pattern
Creating and Submitting Scheduled Orchestration
Create, Update and Override Scheduled Parameters
Define Frequency for Schedule Integrations
View Past, Present and Future Runs

Learn about connectivity agent and how to install and use it

Learn about Connectivity Agent
How to download Connectivity Agent
Installing Connectivity Agent on Linux Machine
Installing Connectivity Agent in High Availability

Exploring and working with File adpater in Oracle Integration

Lear about File Adapter
How to create File Connection
Know about the difference between File and FTP Adapter
Polling CSV Files From Local Server
Encryption / Decryption using Stage File Action

Exploring and working with Oracle Database adpater (DBaaS) in Oracle Integration

Learn about Oracle DBaaS Adapter
Provisioning Oracle Database on OCI
How to create DBaaS Connection
Performing CRUD Operation using DBaaS adapter
Poll Data From Oracle Database
Reading Files and push data into Database table
Get Data in Chunk (Paginate) from Oracle Database

Exploring and working with Salesforce adatper in Oracle Integration

Learn about Salesforce Adapter
Creating Salesforce Developer Instance
Creating Salesforce Connection
Capturing Salesforce Platform Events in Oracle Integration
Capturing Outbound Message and Push data to Downstream App

Learn about Oracle ERP Cloud adapter and related use-cases

About Oracle ERP Cloud Adapter
Creating Oracle ERP Cloud Connection
Understand Trigger and Invoke Options of Oracle ERP Cloud Adapter
Creating and Getting Suppliers from Oracle ERP Cloud
Enable Oracle Account Payable (AP) Invoices Event
Subscribing Business Events from Oracle ERP Cloud
Understanding File Based Data Import (FBDI) Process
Uploading AR Invoices into Oracle ERP Cloud using FBDI with Callback
Calling Oracle Fusion ESS Job and Register Callback
Enable Oracle ERP Cloud Business Events
Subscribing Oracle Account Receivable (AR) event from Oracle ERP Cloud

Understanding of Oracle HCM Cloud Adapter and its related use-cases

Understanding of Oracle HCM Cloud adapter and its Capabilities
Creating Oracle HCM Cloud Connection
Understating HDL (HCM Data Loader) and Files Related to HDL
Creating HDL Files and Upload to Oracle HCM Cloud using HCM Data Loader
Get Manager Information from HCM Cloud

OData Adapter and its' related use-case

About OData Adapter and it’s capabilities
How to create OData Connection
Query the data from OData service
Get the data from OData service based on parameter
Filter the entity data using OData adapter

Consuming Business Intelligence Reports in Oracle Integration

Understanding of Business Intelligence Publisher (BIP) Reports
Consuming Short BIP Report (PDF Output) in Oracle Integration
Consuming Short BIP Report (CSV Output) in Oracle Integration

Oracle Integration Migration, Versioning and Cloning

Code Promotion of Oracle Integration
Code Promotion using Export / Import tool
Oracle Integration Versioning & Cloning
Create Integration Versions & Clone

Exception Handling and ways to handle exceptions

Exception Handling in Oracle Integration
Using Scope to Handle Exception in Oracle Integration
Implementing Throw New Fault in Oracle Integration
Implementing Re-throw Fault in Oracle Integration
Implementing Global Fault Handler in Oracle Integration

Understanding Observability (Run-Time Monitoring) in Oracle Integration

Observability (Run-Time Monitoring) in Oracle Integration
Exploring Observability Dashboard
Monitoring the Messages Process Status
Tracking each Integration Instance Individually
Connectivity Agent Monitoring
Track and view the fault of errored out instances

Working with Project in Oracle Integration-3

Integration Projects in Oracle Integration
Designing, Managing and Monitoring Projects
How to create and manage deployment
How to set Integration visibility to call from other projects
Resource Based Access Control (RBAC) in Integration Project
How to Restrict Projects using Resource Based Access Control (RBAC)

Important scenarios used in the different Integration

Grouping of data using mapper
Split comma separated string into an Array
Convert JSON String into Native JSON payload
Convert JSON to String
Parallel Execution of Actions
Save Payload into DB for Future Purpose
Download and Upload attachments to database
How to use Private Endpoint to connect to private resources with agent
How to read fixed length file and push data to database
Filter unique records using for-each-group
Validate Items and Sum (Balancing & Control) from summary of the file data
How to filter data from CSV file
How to set your own chunk size in Read file in Segment
Storing secrets in OCI Vault and leverage in Integration for APIs authentication
Leverage OCI Vault to sign request payload using own private keys
Leverage OCI Vault to verify the request using own private key
Implementing pagination to retrieve data in chunks from a database