Tips & Tricks For Oracle Integration 3 (Oic 3)

With examples and use cases learn Integration in Oracle Integration 3 (OIC 3), explore more and more features available

What you'll learn

Learn to build Integrations in Oracle Integration 3 with use cases

Tips to build Integrations in Oracle Integration 3

Tricks to build Integrations in Oracle Integration 3

Integration samples and real world project use case demons

Requirements

Prior knowledge to build Integrations in Oracle Integration 3 is needed

Prior knowledge to use POSTMAN / SOAPUI tools is needed

Basic knowledge on RESTful services, SOAP web services, WSDL, FTP protocol and Databases is needed

Description

Oracle Integration 3Oracle Integration 3 is a fully managed, preconfigured environment that gives you the power to integrate your cloud and on-premises applications, automate business processes, develop visual applications, use an SFTP-compliant file server to store and retrieve files, and exchange business documents with a B2B trading partner. Select from our portfolio of hundreds of adapters and recipes to connect with Oracle and third-party applications.Overview of Oracle Integration 3Oracle Integration 3 is a fully managed, preconfigured environment that gives you the power to integrate your cloud and on-premises applications, automate business processes, develop visual applications, use an SFTP-compliant file server to store and retrieve files, and exchange business documents with a B2B trading partner.CapabilitiesWith Oracle Integration 3, you can:Design integrations to monitor and manage connections between your applications, selecting from our portfolio of hundreds of prebuilt adapters and recipes to connect with Oracle and third-party applications.Create process applications to automate and manage your business work flows, whether structured or dynamic.Develop visual applications using the embedded Visual Builder feature.Store and retrieve files in Oracle Integration using the embedded SFTP-compliant file server.Create integrations that use B2B e-commerce to extend business processes to reach trading partners.EditionsOracle Integration is available in two editions: Standard or Enterprise.Oracle SaaS customers can use Oracle Integration for SaaS, which gives you the features and benefits of Oracle Integration with a focus on SaaS.Instances and UpdatesEvery instance has either a Development or Production shape, which you choose when you create the instance. Both instances have the same service level agreements (SLAs); the only difference is the timing of functional updates. Production instances are updated two weeks after Development instances.Functional updates to Oracle Integration 3 occur every two months and involve zero downtime. Oracle completes all update work on your behalf, with no work required by you.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Connectivity Agent

Lecture 2 Install Connectivity agent

Lecture 3 Building integration with connectivity agent / group

Section 3: Mapper

Lecture 4 for-each loop

Lecture 5 Using for-each loop, Xpath axes predicate, xsl if, xsl when condition

Lecture 6 Using for-each-group to group data or remove duplicate records

Lecture 7 Convert datetime to different timezone using XSLT functions

Lecture 8 Convert datetime to different timezone (DST) using user defined library function

Section 4: Actions

Lecture 9 Parallel action

Lecture 10 Cut and Paste Elements (actions and invokes)

Section 5: Library (JavaScript function)

Lecture 11 Create a library with JavaScript function

Lecture 12 Build a jar with multiple JavaScript js files / libraries

Section 6: OCI Functions

Lecture 13 Invoke Function with REST connection using OCI Signature Version 1

Lecture 14 Invoke Function with OCI Function Action

Section 7: OCI Object Storage

Lecture 15 PUT object to Object Storage bucket

Lecture 16 GET object from Object Storage bucket

Section 8: Oracle BI Publisher (BIP) report

Lecture 17 Call BIP report with Integration

Section 9: Oracle ERP Cloud connection

Lecture 18 Overview of Oracle ERP Cloud connection (Create, Trigger, Invoke)

Lecture 19 Subscribe to ERP cloud events with ERP cloud connection

Lecture 20 Subscribe to ERP cloud events with Filter expression

Lecture 21 Accessing Oracle SaaS REST API's with ERP Cloud adapter

Section 10: Data Migration with File Based Data Import (FBDI)

Lecture 22 (Optional) Manual approach to Import payable invoice (AP Invoice) using FBDI

Lecture 23 Bulk Import payable invoice (AP Invoice) using FBDI with Integration

Section 11: Export Bulk data from ERP cloud

Lecture 24 Create Integration for Bulk extract with SOAP connection

Lecture 25 Create Integration for Bulk extract with ERP cloud connection

Section 12: Import bulk data to HCM with HCM data loader (HDL) file

Lecture 26 Import bulk data with HDL file

Section 13: Microsoft Azure Blob Storage

Lecture 27 Get Blob with REST API using Integration

Section 14: Notification Action (Email)

Lecture 28 Send a simple Email from Integration

Lecture 29 Send an Email with HTML template

Section 15: Events: Publish and Subscribe to Events

Lecture 30 Create an event

Lecture 31 Create an event publishing integration

Lecture 32 Create an event subscription integration

Lecture 33 Testing Publishing and Subscribing to Events Integrations

Section 16: Projects

Lecture 34 Create a project with Integration

Lecture 35 Manage projects (Deploy, Export, Import, Delete)

Lecture 36 Invoke Integrations Inside or Outside of Projects or globally available

Section 17: Congratulations

Lecture 37 Congratulations

Beginners in Integration in Oracle Integration 3 for developers,Beginners in Oracle Integration 3 for technical professionals,Beginners who aspire to learn Oracle Integration 3 from scratch and basics,This course is not for functional consultants / functional professionals. This course is created for Technical professionals only.