docs.oracle.com Open in urlscan Pro
2a02:26f0:3500:880::af5  Public Scan

Form analysis
2 forms found in the DOM

Name: searchForm — GET /apps/search/search.jsp?

<form class="u02searchform" name="searchForm" method="get" action="/apps/search/search.jsp?">
  <input aria-hidden="true" type="hidden" name="category" value="all">
  <input type="text" id="txtSearch" class="textcnt autoclear" name="q" placeholder="Search" aria-label="Search input text area" autocomplete="off" aria-owns="awesomplete_list_1">
  <input aria-label="submit search" class="u02searchbttn" type="submit" aria-hidden="true">
</form>

Name: searchForm — GET /search/?

<form class="u02searchform" name="searchForm" method="GET" action="/search/?">
  <input id="search-bar-input" name="q" placeholder="Search" aria-label="Search input text area" autocomplete="off" class="background-white black-placeholder">
  <input type="hidden" name="book" value="LOAD-ERP-DATA-SERVERLESS"><input type="hidden" name="library" value="en/solutions">
</form>

Text Content

 * Skip to Content
 * Skip to Search
 * Home

   
 * Cloud Applications
    * Cloud Applications
    * Fusion Applications Suite
    * NetSuite Applications
    * Industry-Specific Applications
    * Advertising (Data Cloud)

   
 * Cloud Infrastructure
    * Cloud Infrastructure
    * Get Started
    * Free Tier
    * Government Cloud
    * Services
    * Developer Resources
    * Security
    * More Resources
    * Launch Infrastructure Console
    * All Cloud Infrastructure

   
 * On-Premises Applications
    * On-Premises Applications
    * Fusion Applications On Premises
    * Enterprise Performance Management
    * E-Business
    * PeopleSoft
    * Siebel
    * JD Edwards
    * All Applications

   
 * Middleware
    * Middleware
    * Business Intelligence
    * Data Integrator
    * Enterprise Manager
    * GoldenGate
    * Identity Management
    * JavaScript Extension Toolkit
    * Platform Security Services
    * SOA Suite
    * WebCenter
    * WebLogic Server
    * All Middleware

   
 * Database
    * Database
    * Big Data
    * Enterprise Manager
    * Oracle Database
    * Other Databases
    * All Database

   
 * Engineered Systems
    * Engineered Systems
    * Advanced Support Gateway
    * Autonomous Health Checks and Diagnostics
    * Big Data Appliance
    * Database Appliance
    * Enterprise Manager
    * Exadata Database Machine
    * Exalogic Elastic Cloud
    * Exalytics In-Memory Machine
    * MiniCluster
    * Private Cloud Appliance
    * SuperCluster
    * Zero Data Loss Recovery Appliance
    * ZFS Storage Appliance
    * All Engineered Systems

   
 * Java
    * Java
    * Java EE
    * Java Embedded
    * Java SE
    * All Java

   
 * Systems
    * Systems
    * Networking
    * Servers
    * Storage
    * All Systems

   
 * Operating Environments
    * Operating Environments
    * Operating Systems
    * Virtualization
    * All Operating Environments

   
 * Virtualization
    * Virtualization
    * Oracle Linux Virtualization Manager
    * Oracle VM
    * Oracle VM VirtualBox
    * Secure Global Desktop
    * All Virtualization

   
 * Industry-Specific Applications
    * Industry-Specific Applications
    * Communications
    * Construction and Engineering
    * Energy and Water
    * Financial Services
    * Food and Beverage
    * Health
    * Health Sciences
    * Hospitality
    * Insurance
    * Public Sector
    * Retail
    * State and Local
    * All Industries

   
 * Architecture Center
    * Architecture Center
    * Reference Architectures
    * Solution Playbooks
    * Built & Deployed
    * All Architecture Center

   
 * Tutorials and Labs
   
   --------------------------------------------------------------------------------

   
 * All Services & Products
   
 * Help Center Home
   
 * Oracle.com Home
   
   --------------------------------------------------------------------------------

 * Get started with Cloud

Help Center


Load data into Oracle ERP using serverless technologies

Search is scoped to:

Load data into Oracle ERP using serverless technologies


No matching results
Try a different search query.
Search Unavailable
We are making updates to our Search system right now. Please try again later.

   
 * Sign In Account
   
   
   ORACLE ACCOUNT
   
    * Account
    * Help
    * Sign Out
   
   ORACLE ACCOUNT
   
   Manage your account and access personalized content. Sign up for an Oracle
   Account
   
   Sign in to my Account
   
   SIGN IN TO CLOUD
   
   Access your cloud dashboard, manage orders, and more. Free Cloud Platform
   Trial
   
   Sign in to Cloud
   
 *  * Deutsch
    * English
    * Español
    * Français
    * Italiano
    * Português (Brasil)
    * 中文 (简体)
    * 中文 (繁體)
    * 日本語
    * 한국어

 1. Architecture Center
 2. Solution Playbooks


LOAD DATA INTO ORACLE ERP USING SERVERLESS TECHNOLOGIES

Back to Architecture Center
Get Started
 * 
   About Loading Data Into Oracle Cloud ERP Using Serverless Technologies
   * Architecture
   * About Loading Data into Oracle Cloud ERP
   * Before You Begin
   * About Required Services and Roles

Develop
 * 
   Develop Your Functions
   * Use OCI Storage Buckets
   * Create a Transform Function
   * Create a Load Function
   * About Linking Objects Together Using Events
   * Secure Passwords Using Oracle Vault
   * Create a Callback Function
   * Extend the Solution by Subscribing to Notifications

Explore
 * Explore More

Download Code
 * Download Code

Acknowledgments
 * Acknowledgments

 * Previous
 * Table of contents
 * Next

 1. Load data into Oracle ERP using serverless technologies
 2. About Loading Data Into Oracle Cloud ERP Using Serverless Technologies


ABOUT LOADING DATA INTO ORACLE CLOUD ERP USING SERVERLESS TECHNOLOGIES

If you are loading data into SaaS infrequently, or have straightforward
integration flows, you can avoid a heavy data integration solution. You may
prefer to create a code-centric approach, with complete control of what the code
is doing, how its deployed, and pay nothing when the system is idle. If you have
a need to load data into Oracle Fusion Cloud Enterprise Performance Management
(Oracle Cloud ERP) on a regular basis, Oracle offers serverless technologies on
Oracle Cloud Infrastructure. You can deploy simple Oracle Functions to handle
your data transform, load, and callbacks, use Oracle Cloud Infrastructure Object
Storage buckets to temporarily store data as it is being handled, and use API
Gateway and Oracle Cloud Infrastructure Vault to guarantee reliable security for
your mission-critical ERP data.

As an Oracle SaaS customer, you may prefer the licensing model and ease of
management of SaaS: pay by consumption of resources or by the number of
"entities" you create, and manage nothing except your own data. When building
SaaS extensions you can enjoy the same experience. By using Oracle's serverless
options, you do not have to maintain an operating system, patches, a firewall,
or runtime libraries. "Serverless" technology does not mean there are no
servers, but rather that the developer doesn't manage them, so they are
essentially hidden from the developer. In a serverless environment you deploy
your code and configurations to the cloud and Oracle manages them.

Oracle Functions, Oracle Cloud data storage, and other OCI features have scaling
pricing based on usage. You only pay for storage and compute resources that you
consume. If your Functions aren't being used at the moment, there is no cost; if
your storage is empty at the moment, there is no cost, and so on.

Oracle's premier product for moving and transforming data between systems is
Oracle Integration. Oracle Integration allows integrators the ability to create
integrations using declarative constructs, perform transformations in the cloud,
run the actual data load in the cloud, automatically manage exceptions and
retries, and do so without writing code. For heavyweight or low-code/no-code
solutions, Oracle Integration can be a great option. But one use case where
serverless might be useful is for customers who are loading data into SaaS
infrequently, or where the integration flows are straightforward.

This solution playbook shows you how to implement a data load pattern using
serverless technologies, and highlights how the fundamental pattern can be
extended to include notifications and other enhancements.


ARCHITECTURE

This architecture shows how you can create a serverless architecture for loading
data into Oracle Cloud ERP.

To demonstrate how serverless technologies can be used to load data into Oracle
Fusion Cloud we have built a sample using only OCI serverless services and a 3GL
code-based approach.



Description of the illustration load-data-serverless-architecture.png


load-data-serverless-architecture-oracle.zip

Download diagram


ACCEPT TERMS OF USE

You must accept the Oracle Technology Network License Agreement for Architecture
Diagrams to download this diagram.
Additional Permission — Reference Architecture Diagram

The reference architecture diagram you have asked to download is subject to the
Oracle Terms of Use ( https://www.oracle.com/legal/terms.html), except that,
notwithstanding anything to the contrary in Section 3 thereof, you are permitted
to use and edit the architecture diagram for your internal business purposes
solely for the purpose of facilitating the design and implementation of a
similar architecture that meets your business needs. Except as specifically
stated herein, your use of the https://docs.oracle.com site, as well as your use
of any other Materials that are available for download on
https://docs.oracle.com that do not contain this Additional Permission remain
subject to the standard Terms of Use.

I have reviewed and accept the Oracle Terms of Use.
Close
Download diagram

Diagram downloading



This architecture supports the following components:

 * Functions
   
   Oracle Functions is a fully managed, multitenant, highly scalable, on-demand,
   Functions-as-a-Service (FaaS) platform. It is powered by the Fn Project open
   source engine. Functions enable you to deploy your code, and either call it
   directly or trigger it in response to events. Oracle Functions uses Docker
   containers hosted in Oracle Cloud Infrastructure Registry.

 * Events
   
   Oracle Cloud Infrastructure services emit events, which are structured
   messages that describe the changes in resources. Events are emitted for
   create, read, update, or delete (CRUD) operations, resource lifecycle state
   changes, and system events that affect cloud resources.

 * Notifications
   
   The Oracle Cloud Infrastructure Notifications service broadcasts messages to
   distributed components through a publish-subscribe pattern, delivering
   secure, highly reliable, low latency, and durable messages for applications
   hosted on Oracle Cloud Infrastructure.

 * Vault
   
   Oracle Cloud Infrastructure Vault enables you to centrally manage the
   encryption keys that protect your data and the secret credentials that you
   use to secure access to your resources in the cloud. You can use the Vault
   service to create and manage vaults, keys, and secrets.

 * API Gateway
   
   Oracle API Gateway enables you to publish APIs with private endpoints that
   are accessible from within your network, and which you can expose to the
   public internet if required. The endpoints support API validation, request
   and response transformation, CORS, authentication and authorization, and
   request limiting.

 * Object storage
   
   Object storage provides quick access to large amounts of structured and
   unstructured data of any content type, including database backups, analytic
   data, and rich content such as images and videos. You can safely and securely
   store and then retrieve data directly from the internet or from within the
   cloud platform. You can seamlessly scale storage without experiencing any
   degradation in performance or service reliability. Use standard storage for
   "hot" storage that you need to access quickly, immediately, and frequently.
   Use archive storage for "cold" storage that you retain for long periods of
   time and seldom or rarely access.

 * Fusion Applications
   
   The Oracle Fusion Cloud Applications Suite offers dozens of cloud apps across
   every business category, including ERP, SCM, HCM, Sales, Service, and
   Industry verticals.

This example architecture demonstrates how you can create a serverless
architecture for loading data into Oracle Cloud ERP. It demonstrates a pattern
of using OCI Buckets (a feature of Object Storage), Events, Functions, Vault,
Notifications, and API Gateway to implement the integration pipeline. The
pattern highlights how the flow can be extended to include notifications and
further enrich the integration. This pattern is code-based and serverless, and
when the system is idle the only cost to the consumer is the storage of the
files in OCI Object Storage.

If you have a lot of integrations to implement and these integrations will be
changed frequently then Oracle Integration is a good alternative. Oracle
Integration provides a rich declarative development environment where
integrations can be built, deployed quickly, and scale to meet your needs.
Additionally Oracle Integration gives you a lot of extra built-in functionality,
such as error handling, retrying of messages, dashboards, reporting, state
tracking of previous requests, and more.

However, if you prefer a serverless approach, a code-centric style of
integration, and the flexibility and extensibility this pattern provides, then
use this architecture as a starting point for your own Functions-based
serverless SaaS extension.


ABOUT LOADING DATA INTO ORACLE CLOUD ERP

To develop this application it is necessary to understand the flow for loading
data into Oracle Cloud ERP.

Ther following steps are typical of the requirements when loading data into
Oracle Cloud ERP:

 1. Enrich the incoming data with some external data, and transform the data
    into the Oracle Cloud ERP data loading format (FBDI)
 2. Load the file into Oracle Cloud ERP using REST or SOAP Web Services
 3. Listen for a call-back from Oracle Cloud ERP indicating that the process has
    completed and that the data has been processed.

Enrich and Transform

When loading data into Oracle Cloud ERP a mandatory step is to transform the
input data into the required CSV format and then zip up the files into a single
ZIP file. In the example in this playbook this transform step is demonstrated by
accepting a simplified JSON data structure which is then transformed into the
CSV format required by Oracle Cloud ERP. Then the files are combined into a
single ZIP file ready to be uploaded.

Load

Once the data has been transformed it can be loaded into Oracle Cloud ERP using
Fusion REST APIs. The response from Oracle Cloud ERP contains some metadata and
the JobID being used to load the data. The JobID is needed later to determine
which data file is being imported by which job.

Process the call-back

Oracle Cloud ERP issues a call-back to the client which indicates if the job was
processed correctly or if there was an error. Note that a success code does not
necessarily mean the data was all loaded: for example, there could have been
duplicate records.


BEFORE YOU BEGIN

This solution playbook assumes you're familiar with OCI, Oracle Cloud ERP, and
Python.

You'll need to create various objects in an OCI instance, including storage
buckets, funcitons, and Oracle Cloud Infrastructure Vault. The following
references may be helpful:

 * Review Example 1: ImportBulkData Operation in Create an inbound or outbound
   set of data, in REST API for Oracle Fusion Cloud Financials.
 * To create buckets in OCI, review Putting Data into Object Storage in Oracle
   Cloud Infrastructure Documentation.
 * To create Functions in OCI, review Creating, Deploying, and Invoking a
   Helloworld Function in Oracle Cloud Infrastructure Documentation.
 * Review key management with Oracle Vault in Oracle Cloud Infrastructure
   Documentation.


ABOUT REQUIRED SERVICES AND ROLES

This solution requires the following services:

 * Oracle Fusion ERP
 * Oracle Cloud Infrastructure, including Oracle API Gateway, Oracle Functions,
   and other OCI components

These are the roles needed for each service.

Service Name: Role Required to... Oracle Fusion ERP: Implementor Load Fusion ERP
data via APIs Oracle Cloud Infrastructure: Administrator Create accounts in OCI
IAM, deploy OCI components and Functions

See Learn how to get Oracle Cloud services for Oracle Solutions to get the cloud
services you need.

 * Previous
 * Table of contents
 * Next

Title and Copyright Information

Load data into Oracle ERP using serverless technologies

F41968-01

December 2022

Copyright © 2022, Oracle and/or its affiliates. 

Automation Available
You can deploy this pattern using downloadable code or automated provisioning,
as described in the Download or Deploy section.
Was this page helpful?
 * © Oracle
 * About Oracle
 * Contact Us
 * 
 * Products A-Z
 * Terms of Use & Privacy
 * Cookie-Präferenzen
 * Ad Choices
 * 
 * © Oracle

 * Previous
 * Table of contents
 * Next

×
Video