Oracle Integration Cloud Service

Call at 8287712644 and book your demo class!

Oracle Integration Cloud Training- OIC Training Course Content

This training can help you prepare for Oracle Certification – 1Z0-1042-20 (Oracle Cloud Platform Application Integration 2020 Specialist).  Oracle Integration Cloud Training will be focused 70% on practices and 30% concept discussion. The following topics shall be covered



OIC

Overview of Cloud offerings (IaaS, PaaS, SaaS) Overview of Oracle Integration Cloud (OIC) concepts Discussion on iPaaS offerings in market (OIC, DellBoomi, Mulesoft, etc.) Details about Oracle Certification – 1Z0-1042-20 (Oracle Cloud Platform Application Integration 2020 Specialist) Details about Oracle Free cloud account Technical and Business Benefits of iPaaS (OIC) Discussion on key integration terminologies– WSDL, SOAP, REST, XML, XSD, JSON Overview of Oracle Fusion Middleware Discussion on market value and prerequisites Demo
Introduction to RPC and where Web Services come in Introduction to RESTful Services (GET, PUT, POST, PATCH, DELETE) Complete walkthrough of a WSDL
Oracle Cloud Adapters Configuring Connections – Trigger, Invoke using REST adapter Working on App Driven Orchestration – Integration Style Working on MAP, SWITCH, ASSIGN activities Testing REST integration using Test option on OIC console Take a backup of integration – Download iar file Activate, Monitor and Track integration flow
Configuring Connections – Trigger, Invoke using FTP, SOAP adapter Writing files on FTP server (using FTP connection) Working on Call Integration action (calling existing Integration from OIC) Exposing REST service as SOAP Using SOAP-UI to call OIC SOAP-based integration Discussion on packages Take backup of integration – Download par file Clone an integration Integration versioning
Scheduled integration pattern READ csv file from FTP Read file using STAGE FILE data action WRITE csv file on FTP iCal expression Integration parameters
For Each collection action Download and process zip file from FTP Read multiple CSV records Write separate JSON structure file per record Local variables Global Variables and Data Stitch action MAP action vs Data Stitch
LIST files using FTP adapter WRITE operation – STAGE file Convert csv to JSON Lookup, Note, Logger, Notification Practice
Configuring On-Prem Connections – Trigger, Invoke using DataBase, File adapter Discuss on Agent concept – Need of agent. Create database connection using On-Prem agent Create Basic Routing Orchestration Perform SELECT, UPDATE, INSERT operation Edit SQL and add parameters in DB query
Navigating Oracle Cloud ERP – Oracle Fusion R13 Calling Oracle Cloud ERP SOAP web service Using SCOPE Action handling fault demo
Fault Return Re-throw Fault Throw New Fault Global Fault Using Global Variables in fault handler
These preliminaries settled, he did not care to put off any longer the execution of his design, urged on to it by the thought of all the world was losing by his delay, seeing what wrongs he intended to right, grievances to redress, injustices to repair, abuses to remove, and duties to discharge.
Introduction to Oracle SAAS Fusion ERP. Discussion on Conversion/Interface Describe FBDI manual process. Practice all FDBI steps manually Practice
Discuss ERP integration SOAP service operations Configuring all FBDI steps using ERP integration SOAP service, including getting logs Discussing Oracle Fusion ESS job and it’s details How to get parameter details for ERP Integration service operations Comparing Oracle ERP Cloud Adapter with ERP Integration SOAP service (When to use what option)
Discuss OIC Oracle ERP adapter concepts and usages Automate FBDI process using ERP adapter as Invoke Configuring properties file Configuring ERP cloud adapter for callback (configuring CSF key in Oracle SOA Composer) using ERP adapter as Trigger to get FBDI logs Practice
Discussion and Creation of OTBI report Analysis, Dashboard demo Drill down report demo Practice
Creation of BIP report Creating parameter based BIP custom report Bursting, emailing output of report Using Report service to automate BIP report data extraction Practice
Describe Fusion REST services Leverage parameters provided by Oracle on REST service Create integration to invoke Oracle Fusion REST service to create supplier
REST API’s to manage OIC integrations Submit failed integrations without logging to OIC instance OIC user management SOA and OIC discussion/comparison
Overview of VBCS Introduction to OJET Comparison of VBCS with other application tools (ADF, OAF) Application development using VBCS
Overview of PCS Form Development, approval patterns Demo PCS application – Approvals
Interview Technical Questions Interview Scenario Questions Sample project write-ups Project Ideas

 

Tap here to chat

Tap here to call us

1. Introduction to the OIC Training Course and Course Content

  • Overview of Cloud offerings (IaaS, PaaS, SaaS)
  • Overview of Oracle Integration Cloud (OIC) concepts
  • Discussion on iPaaS offerings in market (OIC, DellBoomi, Mulesoft, etc.)
  • Details about Oracle Certification – 1Z0-1042-20 (Oracle Cloud Platform Application Integration 2020 Specialist)
  • Details about Oracle Free cloud account
  • Technical and Business Benefits of iPaaS (OIC)
  • Discussion on key integration terminologies– WSDL, SOAP, REST, XML, XSD, JSON
  • Overview of Oracle Fusion Middleware Discussion on market value and prerequisites
  • Demo    

2. WSDL, SOAP and REST Concepts

  • Introduction to RPC and where Web Services come in Introduction to RESTful Services (GET, PUT, POST, PATCH, DELETE)
  • Complete walkthrough of a WSDL

3.Create Integration and taking integration backup  

  • Oracle Cloud Adapters Configuring Connections – Trigger, Invoke using REST adapter
  • Working on App Driven Orchestration – Integration Style Working on MAP, SWTICH, ASSIGN activities
  • Testing REST integration using Test option on OIC console
  • Take backup of integration – Download iar file
  • Activate, Monitor and Track integration flow  

3. Exposing REST service as SOAP, packages, and FTP connection

  • Configuring Connections – Trigger, Invoke using FTP, SOAP adapter Writing files on FTP server (using FTP connection)
  • Working on Call Integration action (calling existing Integration from OIC)
  • Exposing REST service as SOAP Using SOAP-UI to call OIC SOAP based integration
  • Discussion on packages Take backup of integration – Download par file
  • Clone an Integration versioning  

4. Scheduled integration pattern

  • Scheduled integration pattern
  • READ csv file from FTP Read file using STAGE FILE data action
  • WRITE csv file on FTP iCal expression Integration parameters

5. Conditional branching, looping, Global Variables  

  • For Each collection action Download and process zip file from FTP
  • Read multiple csv records
  • Write separate json structure file per record
  • Local variables
  • Global Variables
  • Data Stitch action MAP action vs Data Stitch

6. FTP adapter – List, Write, download operations

  • LIST files using FTP adapter
  • WRITE operation – STAGE file
  • Convert csv to JSON Lookup, Note, Logger, Notification
  • Practice

7. On-Prem Integrations – Agents

 

  • Configuring On-Prem Connections – Trigger, Invoke using DataBase
  • File adapter Discuss on Agent concept – Need of agent.
  • Create database connection using On-Prem agent
  • Create Basic Routing Orchestration
  • Perform SELECT, UPDATE, INSERT operation Edit SQL and add parameters in DB query  

8. Oracle SAAS – Fusion cloud and Fault Handling

  • Navigating Oracle Cloud ERP – Oracle Fusion R13
  • Calling Oracle Cloud ERP  SOAP web service
  • Using SCOPE Action handling fault demo

9. Advanced Fault Handling

  • Fault Return Re-throw Fault Throw New Fault Global Fault Using Global Variables in fault handler

10. Publish and Subscribe To OIC Integration Style

  • Discussion on messaging pattern, event-based integrations, loose coupling concepts
    Practice

11. Oracle Fusion – FBDI manual

  • Introduction to Oracle SAAS Fusion ERP.
  • Discussion on Conversion/Interface
  • Describe FBDI manual process.
  • Practice all FDBI steps manually

12. FBDI process using ERP Integration SOAP service  

  • Discuss ERP integration SOAP service operations
  • Configuring all FBDI steps using ERP integration SOAP service, including getting logs
  • Discussing Oracle Fusion ESS job and it’s details
  • How to get parameter details for ERP Integration service operations
  • Comparing Oracle ERP Cloud Adapter with ERP Integration SOAP service (When to use what option)

13. FBDI Automation using Oracle ERP Cloud Adapter

  • Discuss OIC Oracle ERP adapter concepts and usages
  • Automate FBDI process using ERP adapter as Invoke
  • Configuring properties file Configuring ERP cloud adapter for callback (configuring CSF key in Oracle SOA Composer)using ERP adapter as trigger to get FBDI logs Practice  

14. Oracle Fusion ERP – OTBI reports

  • Discussion and Creation of OTBI report Analysis
  • Dashboard demo Drill down report demo
  • Practice

15. Oracle Fusion ERP – BI reports and Oracle Report Service (Outbound from Fusion SaaS)

  • Creation of BIP report Creating parameter based BIP custom report Bursting, emailing output of report
  • Using Report service to automate BIP report data extraction
  • Practice  

16. Oracle Fusion ERP – REST Services

  • Describe Fusion REST services Leverage parameters provided by Oracle on REST service
  • Create integration to invoke Oracle Fusion REST service to create supplier  

17. OIC Admin steps and Code migrations Code migrations across instances

  • REST API’s to manage OIC integrations Submit failed integrations without logging to OIC instance
  • OIC user management SOA and OIC discussion/comparison

18. VBCS  

  • Overview of VBCS
  • Introduction to OJET Comparison of VBCS with other application tools (ADF, OAF) 
  • Application development using VBCS  

19. PCS  

  • Overview of PCS Form Development, approval patterns Demo PCS application – Approvals 

20. Interview Questions and Project write-ups for resume

  • Interview Technical Questions
  • Interview Scenario Questions
  • Sample project write-ups
  • Project Ideas