Become an OIC 2 Master: Oracle Integration Cloud Masterclass

REST ,SOAP Adapters ,FTP ,ATP Adapter, FBDI, ORDS, Business Events, Call Back in Oracle Fusion

Ratings: 4.19 / 5.00




Description


Oracle Fusion:

Adapters:

  • REST Adapter: Connects to RESTful web services, enabling integration with a wide range of external systems using HTTP methods (GET, POST, PUT, DELETE).

  • SOAP Adapter: Interacts with SOAP-based web services, using XML-based messaging to exchange data.

  • FTP Adapter: Facilitates file transfers between Oracle Fusion and FTP servers, supporting both secure and unsecure protocols.

  • ATP Adapter: Interacts with Oracle Application Transaction Platform (ATP), a high-performance transaction processing server for handling high-volume, mission-critical operations.

  • FBDI Adapter: Handles File-Based Data Import (FBDI) processes for loading data from flat files (CSV, XML, etc.) into Oracle Fusion applications.

Other Key Components:

  • ORDS (Oracle REST Data Services): Enables the creation of RESTful APIs for accessing Oracle Fusion data, providing a way to expose and consume data in a RESTful manner.

  • Business Events: Asynchronous notifications triggered by specific actions or data changes within Oracle Fusion, allowing other systems or processes to react to these events.

  • Callback: A mechanism for Oracle Fusion to notify external systems upon completion of certain tasks or events, enabling those systems to take further actions based on the outcome.

Use Cases:

  • REST Adapter: Integrating with external APIs, consuming web services, exchanging data in JSON or XML format.

  • SOAP Adapter: Interacting with SOAP-based systems, legacy applications, or web services that primarily use SOAP.

  • FTP Adapter: Transferring files for data exchange, backups, or integration with file-based systems.

  • ATP Adapter: High-volume transaction processing, integrating with ATP-based applications for critical operations.

  • FBDI Adapter: Loading data from flat files into Oracle Fusion for batch processing or data migration.

  • ORDS: Exposing REST APIs for integration with mobile apps, web applications, or other systems accessing Oracle Fusion data.

  • Business Events: Triggering actions in external systems based on specific events within Oracle Fusion, enabling real-time responses.

  • Callback: Notifying external systems of task completion or events, allowing for further actions or updates.

Unlock the Power of Oracle Integration Cloud: A Comprehensive Guide for Oracle Fusion and Apps/EBS Consultants

Master Oracle Integration Cloud (OIC) and seamlessly connect your Oracle Fusion and EBS applications with this hands-on, expert-led course.

Designed for:

  • Oracle Fusion Technical Consultants

  • Oracle Apps/EBS Technical Consultants

  • Professionals seeking to advance their OIC expertise

Key topics covered:

  • OIC Instance and ATP Database Setup: Learn how to create and configure your OIC instance and ATP database, laying the foundation for integrations.

  • Notifications and Emails: Master notification creation and email formatting for effective communication and alerts.

  • REST API Integration: Connect to RESTful web services with confidence, using Postman for testing and mastering query and template parameters.

  • ATP Adapter Mastery: Perform essential database operations (insert, update, delete, select) with and without parameters, and call procedures directly from your integrations.

  • SQL Developer for Database Connectivity: Gain proficiency in connecting to databases using SQL Developer for seamless data access.

  • FTP Integration: Transfer files effortlessly using FTP adapters, covering read, write, move, delete, list, and download actions.

  • Stage File Handling: Work with files effectively using Stage File actions for reading, writing, listing, and downloading.

  • SOAP API Integration: Connect to SOAP-based web services with ease, using SOAP UI for testing and creating SOAP connections in OIC.

  • BI Reporting: Retrieve BI reports efficiently, handling both small and large datasets seamlessly.

  • FBDI for Data Import: Master File-Based Data Import (FBDI) for loading data from flat files into Oracle Fusion applications.

  • Advanced Concepts: Explore  ORDS, Cloud Adapter connections, Callbacks, Attachments, Business Events, and ESS job integration.

By completing this course, you'll:

  • Confidently build and manage integrations in Oracle Integration Cloud.

  • Streamline workflows and data exchange across Oracle Fusion and EBS applications.

  • Enhance your career prospects in the in-demand field of Oracle integration.

Enroll now and unlock the limitless possibilities of Oracle Integration Cloud!

Oracle Fusion Technical BI Reports and OTBI Reports available in udemy please go through it

Topics :

How to Create OIC Instance in OCI

How Create ATP Data Base in OIC

How create a notification in OIC

How Create Email Notification With EMAIL body parameters OIC

How Create Email Notification With HTML body parameters in OIC

How Test Rest API Using Post man

How to Create REST Adapter connection in OIC

How To create integration using REST API with query and template parameters in OIC

How to Create ATP Adapter Connection in OIC

         Insert     - With parameters and without parameters

         update   - With parameters and without parameters

         Delete    - With parameters and without parameters

        Select     - With parameters and without parameters

        Call Procedure from Integration


How to connect to DB using SQL developer

How to Create FTP Adapter Connection in OIC

How To create integration using FTP In OIC

            Read

            write

           Move

          Delete

          List Files

          Download

Stage File Action in OIC

            Read entire file

           Read File in Segments

            write

          List Files

          Download

How to run Soap Api Using SOAP UI

How to create Soap connection in OIC

How to call Bi report with <10Mb data from SAAS using last_run_date

How to call Bi report with >10Mb data from SAAS

FBDI - File based data Import

BI Cloud Connector

Sandbox

Application Composer

ORDS(Oracle REST Data Service)  in Oracle Database

How to Create Cloud Adapter connection OIC

How To create Call Back in oracle OIC

How to work with attachments in Oracle OIC

Business Events in Oracle OIC

How to call ESS job from OIC and SOAP UI

How to create ESS job in oracle Fusion ERP



What You Will Learn!

  • Oracle integration Cloud OIC for Oracle EBS Consultants and fusion consultants
  • Soap Adapter ,Rest Adapter with REST API and SOAP API
  • FTP Adapter - READ an WRITE and MOVE Files and Load file data into Tables
  • Cloud Adapter -FBDI and Interfaces and conversions and Call Back
  • ATP Adapter - INSERT ,UPDATE,DELETE ,MERGE and Calling Procedure and Packaged Procedure
  • Call Bi Report From OIC and Load Data into Custom Tables
  • Stage File action ,Schema File Creation
  • App Driven Integration with Complex JASON Payload
  • Creating Common logger integration
  • For Loop ,While Loop, Fault , Re through Fault in OIC
  • Scope and Exception Handling in OIC
  • Email Notification with HTML body in OIC
  • Web Services Testing using POSTMAN and SOAP UI
  • Working With Attachments in Oracle OIC
  • Call Back In Oracle OIC
  • Business Events in OIC
  • ORDS - Oracle Rest Data Service
  • Content Sever
  • FBDI
  • Call BI Report from OIC using soap Webservice

Who Should Attend!

  • Oracle Apps technical consultants
  • Oracle Fusion Technical (HCM or SCM or Finance)
  • Oracle SOA Developers
  • Oracle Developers