Oracle Retail Bulk Data Integrations


 
The file transfer style of integration is the most common integration pattern used with Oracle Retail products.  The majority of them still take the form of periodic programmatic extractions (e.g. MOM Batch) using a variety of tools or programs such as shell scripts, Pro*C, and RETL scripts. 

The Oracle Retail strategic direction has been, and continues to be, moving bulk data using the Oracle Data Integrator tool, an ETL tool that performs the extraction, transform and load between Oracle Retail Applications, and now to external Oracle applications.

This release of RRA 14.0 is the beginning of including these forms of integration. 

  • Oracle Retail Financial Integration 14.0 - Oracle Merchandising 14.0 to E-Business Suite Financials version 12.1.3.
  • Oracle MOM (RMS, Allocations, ReIM, RPM)  14.0 Batch and Database level Integrations
  • Oracle RMS Data Access Schema (New in 14.0)








Integration Styles


Oracle Retail Integration Bus (RIB)

The Oracle Retail Integration Bus (RIB) is a fully distributed integration infrastructure that implements messaging using Asynchronous JMS Pub/Sub Fire-and-Forget.

Oracle Retail Service Backbone (RSB)

Oracle Retail Service Backbone (RSB) is the productization of a set of Web Services, ESBs and Security tools that standardize the deployment and run time of Web Service flows within Oracle Retail Suite of applications.


Bulk Data  Integration
(File-based, ETL-based)

Oracle Retail, like most vendors, have relied on file extraction of large amounts of data (bulk), moving that data between it's applications using file-based methods or ETL-tool based methods, and then consuming the data for processing.