Oracle® Retail Data Extractor for Merchandising Implementation Guide Release 15.0 E69439-01 |
|
![]() Previous |
![]() Next |
The Oracle Retail Data Extractor (ORDE) application enables customers to extract data from Oracle Retail Merchandising System (RMS) for Oracle Retail Insights (RI) consumption.
Oracle Retail Analytics (RA) was converted from being an on-premise application to a cloud based service offering named Oracle Retail Insights Cloud Services (RI). Oracle Data Integrator (ODI) mappings for extracting data from Oracle Retail Merchandising System (RMS) called as SDE Mappings (Source Dependent Extracts) were removed because RMS is an on-premise product and could not be sourced directly from the cloud.
RMS is the primary source of information for the RI application, so there was requirement to be able to extract data from RMS into flat files for uploading and importing into RI staging tables for loading the RI data warehouse.
Oracle Retail Data Extractor (ORDE) 15.0 provides this functionality to integrate with RMS and extract data in ORDE staging tables and then unload them in to respective flat files for RI consumption. The main characteristics of the Retail Data Extractor product are:
Source Integration Solution: Retail Data Extractor provides data integration with source applications as RMS and RPM.
Performant ETL Code: Retail Data Extractor data processing tool, ODI, offers high performance for the database batch processes on Oracle database.
Extensibility: Retail Data Extractor ETL code can be customized and extended for client specific needs.