Current Status
Not Enrolled
Enroll in this course to get access
Price
Free
Get Started
| List of Contents |
|---|
| Problem Statement |
| • The integration flow focuses on extracting structured data from the database environment. |
| • Exporting the extracted data as a file for downstream system consumption. |
| • Creating the records in Fusion instances. |
| Integration Flow |
| General Use Case / Scenario |
| • When a customer is operating with multiple systems. |
| • Some data is available in one system and needs to be synchronized with another system. |
| • Oracle Integration Cloud (OIC) plays a key role in automating the data synchronization between systems. |
| • Example: A customer creates suppliers in the Salesforce system while using Fusion for invoicing. |
| • All suppliers from Salesforce should remain synchronized with the Fusion supplier records. |
| • This synchronization can be achieved using OIC. |
| Approach Overview |
| • REST Trigger / Scheduled Integration → ATP Database Adapter → Data Transformation → File Generation → FTP Adapter → Load into Fusion |
| Solution Overview |
| • This pattern enables structured data extraction from a database. |
| • Transformation of the data into file formats such as CSV. |
| • Delivery of the generated file to secure FTP locations. |
| • Commonly used for reporting feeds, partner integrations, and enterprise data distribution. |
| Key Integration Concepts Demonstrated |
| • File-based enterprise integration using FTP adapters. |
| • Data transformation and schema mapping in Oracle Integration Cloud. |
| • Record-level processing using looping constructs. |
| • Loading the data into the Fusion environment. |
| • Bidirectional data exchange between file systems and databases. |
| • Designing scalable and reliable batch data pipelines. |
Create a Free Account to Access
(login if you already have an account)
- Login
- Register (Free)
Course Content
Meeting Invite
Training Recordings
Session-1: OIC – Add Suppliers from External System to Fusion (19-Mar-26)
2 Topics
You don't currently have access to this content
