Tips & Tricks For Integration In Oracle Integration 2 (Oic)

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

What you'll learn

Learn Integration concepts with examples

Learn Integration concepts with use cases

Learn Integration concepts with practise

Learn Integration concepts in depth

Requirements

Students must already know the basics of Integration in Oracle Integration

Students must enroll to Learn Integration in Oracle Integration (OIC) before enrolling for this course if they don't know Integration

Description

A Quick Introduction to Oracle Integration:Integration is a fundamental part of your digital business development. It involves connecting on-premises applications and cloud applications and services. Oracle Integration makes it easy to connect your applications and automate end-to-end processes such as procure to pay, inquiry to order, and hire to retire.With Oracle Integration, you can:Develop integrations to design, monitor, and manage connections between your applicationsCreate process applications to automate and manage your business work flowsAnalyze results to gain insight into your businessBuild custom web and mobile applicationsCritical business processes, such as those related to human capital management (HCM), customer experience (CX), and enterprise resource planning (ERP), are frequently slow and inflexible. For example, a multi-step process such as Lead to Opportunity to Quote to Order can involve four or more applications and require human exception management at every step of the process. In this scenario, the lack of integration between departments as well as the delays caused by human-based problem resolution can result in lost revenue, frustrated customers, and high costs.Oracle Integration changes all that. It empowers you to:Establish connectivity between the many applications and people that are part of the entire business process life cycle.Assemble existing technologies into new business services to better align with the changing pace of new business demands.Deliver new business innovations faster by rapidly connecting diverse applications and key business roles.Gain 360-degree views across your entire business. Easily monitor and analyze every application, integration, and workflow spanning the business process life cycle.About IntegrationsOracle Integration is a complete, secure, but lightweight integration solution that enables you to connect your applications in the cloud. It simplifies connectivity between your applications and connects both your applications that live in the cloud and your applications that still live on premises. Oracle Integration provides secure, enterprise-grade connectivity regardless of the applications you are connecting or where they reside.Oracle Integration provides native connectivity to Oracle Software as a Service (SaaS) applications, such as Oracle Engagement Cloud Adapter, Oracle B2C Service, and so on. Oracle Integration adapters simplify connectivity by handling the underlying complexities of connecting to applications using industry-wide best practices. You only need to create a connection that provides minimal connectivity information for each system. Oracle Integration lookups map the different codes or terms used by the applications you are integrating to describe similar items (such as country or gender codes). Finally, the visual data mapper enables you to quickly create direct mappings between the trigger and invoke data structures. From the mapper, you can also access lookup tables and use standard XPath functions to map data between your applications.Once you integrate your applications and activate the integrations to the runtime environment, the dashboard displays information about the running integrations so you can monitor the status and processing statistics for each integration. The dashboard measures and tracks the performance of your transactions by capturing and reporting key information, such as throughput, the number of messages processed successfully, and the number of messages that failed processing. You can also manage business identifiers that track fields in messages and manage errors by integrations, connections, or specific integration instances.We will try to upload almost all the videos for this course by April 30, 2022. Also, this course will be updated with new chapters and classes based on the feedback we receive from you.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Retry faults and errors with custom solution

Lecture 2 Build retry logic for failed / errored invocations in Integration

Section 3: Solving REST connection related problems

Lecture 3 Build REST/https Integration to expose over multiple resources / verbs / paths

Lecture 4 Convert Scheduled to App Driven Orchestration (REST trigger based) Integration

Lecture 5 REST Adapter - OAuth Custom Two Legged Token-Based Authentication

Lecture 6 REST Adapter - OAuth Custom Three Legged Token-Based Authentication

Section 4: Solving mapping (XSLT) related problems

Lecture 7 For loop in mapper

Lecture 8 Grouping of data with for-each-group function

Lecture 9 Datetime conversion between time zones in mapper

Section 5: Libraries in Integration

Lecture 10 Use XPath Functions in JavaScript Libraries and Updating existing Library

Lecture 11 Create a JavaScript function in .jar file (advanced)

Section 6: Database use cases

Lecture 12 Call long running Stored Procedures Asynchronously

Lecture 13 Fetch records from database with size greater than 10 MB

Section 7: Microsoft Azure

Lecture 14 Authorize with Shared key for Storage services

Section 8: WhatsApp Integration with Twilio

Lecture 15 Send WhatsApp / SMS message with Twilio Adapter

Section 9: Oracle BI Publisher Integration

Lecture 16 UI Navigation for BI Publisher (BIP)

Lecture 17 Create a Data Model in BIP

Lecture 18 Create Report in BIP

Lecture 19 Build Integration to run and read BIP report

Section 10: Data Migration using File-Based Data Import (FBDI)

Lecture 20 FBDI overview with manual approach

Lecture 21 Build integration for FBDI bulk data import to Fusion

Lecture 22 Build callback integration to subscribe to on completion of Fusion ESS job event

Lecture 23 Testing Integrations

Section 11: ESS Job set automation

Lecture 24 Create ESS Jos Set and submit / run ESS Job Set

Lecture 25 Submit ESS Jos Set request with Oracle Integration

Section 12: Export bulk data from Oracle Fusion Cloud / SaaS Demo

Lecture 26 Method 01 : Extract data

Lecture 27 Method 02 : Extract data

Section 13: HCM Adapter

Lecture 28 Method 01 - Bulk import with HDL

Lecture 29 Method 02 - Bulk import with HDL

Section 14: Microsoft Email Adapter

Lecture 30 Register an Azure app and test send mail with POSTMAN client

Lecture 31 Send email with Microsoft Mail adapter in Oracle Integration

Section 15: Slack Adapter

Lecture 32 Send a message to Slack channel from Oracle Integration

Section 16: Oracle Cloud Functions

Lecture 33 Invoke OCI Function from Oracle Integration

Lecture 34 Read excel files (.xlsx / .xls) with Oracle Integration and OCI Function

Lecture 35 Generate an Excel (xlsx) file

Section 17: Connectivity Agent

Lecture 36 Learning Connectivity agent in detail

Section 18: Automation with REST API for Oracle Integration

Lecture 37 Import(Add) an Integration

Lecture 38 Import(Replace) an Integration

Lecture 39 Retrieves detailed information about the integration

Lecture 40 Update(Activate/Deactivate) an Integration

Section 19: Oracle Cloud resources

Lecture 41 Invoke Oracle Integration for OCI Events with Notification service

Lecture 42 Put / Get objects from Object Storage

Lecture 43 Capture the Activity Stream of Integrations in Oracle Cloud logging service

Lecture 44 Backup OIC Integration Activity Stream to OCI Logging Service

Lecture 45 Get Object from Object Storage with OIC Integration using OCI Functions

Lecture 46 Put Object to Object Storage with OIC Integration using OCI Functions

Section 20: Congratulations

Lecture 47 Congratulations

Students who want to explore more and more features in Integration with examples