Title

Oracle Integration 3 - Using OIC Native Actions to Harness OCI Services

About Or Title

About This Workshop

Desc Long

This comprehensive hands-on workshop will equip you with the skills to automate and streamline data workflows by integrating Oracle Integration (OIC) with Oracle Cloud Infrastructure (OCI) services. In modern businesses, efficient data handling is critical, and this workshop addresses that need by walking you through the creation of a real-world integration scenario where data in Excel files is transferred, processed, and transformed automatically.

During this workshop, you will learn to build an end-to-end integration flow that automates file handling from an FTP server, converts files to a new format, and prepares them for further processing. Whether you work in data integration, IT operations, or business process automation, this workshop will give you the practical experience needed to implement solutions that save time and reduce manual effort.

Key Learning Objectives:
Transfer Excel Files to OCI Object Storage: You will learn how to use OIC native actions to list, download, and transfer Excel files from an FTP server to OCI Object Storage for secure and temporary storage.

Invoke Serverless Functions to Convert Excel Files: You will deploy an OCI serverless function that converts Excel files (.xls/.xlsx) into CSV format, automating data transformation.

Process CSV Files in OIC: After converting the files, you will use OIC to read and stage CSV files, preparing them for further integration tasks like reporting, analytics, or updating business applications.

What You Will Learn:
How to integrate OIC with OCI services to automate file transfers and transformations, creating scalable workflows.
Practical use of OIC native actions to manage Object Storage and invoke serverless functions.
Best practices for data security and processing, ensuring that file handling is efficient, secure, and streamlined.
Hands-on experience with real-life business cases, enabling you to apply these skills in your organization’s data operations.

Workshop Length

3 hours

Outline

Introduction
Get Started
Provision OIC
Enable File Server
File Server Setup
Serverless Functions Prerequisite Setup
Create a Function Application using Native Actions to invoke OCI Services
Create an Integration Flow
Test End to End Integration Flow

Prerequisites

Familiarity with OIC is desirable, but not required
Familiarity with Oracle Cloud Infrastructure (OCI) is helpful
Understand OCI Serverless Functions

Other Workshops you might like

Oracle Integration 3 - Cookbook - ERP Cloud FBDI Import

Oracle Integration 3 - Cookbook - ERP Cloud FBDI Import

This workshop shows how to design and develop a FBDI Import Usecase in Oracle Integration (..)

2 hrs 6769 Views
Oracle Integration - Experiential - ERP Business Events

Oracle Integration - Experiential - ERP Business Events

Create an integration triggered by an ERP Cloud Business Event and write data to a database table

2 hrs 9098 Views
Get Started with Process Automation

Get Started with Process Automation

Process Automation Get Started Workshop shows how to rapidly design, automate, and manage business (..)

2 hrs, 36 mins 10900 Views
Oracle Integration 3 - Experiential - ERP Cloud Business Events

Oracle Integration 3 - Experiential - ERP Cloud Business Events

Explore how to create an integration triggered by an ERP Cloud Business Event and write data to a (..)

2 hrs 3747 Views