Oracle® Retail Xstore Suite 20.0/Oracle® Retail Merchandising Suite 19.2.000 Implementation Guide Release 20.0 F37856-03 |
|
![]() Previous |
![]() Next |
This chapter covers the data flow from Merchandising and Pricing to OCDS, where Merchandising and Pricing data can be requested by Xstore Office for loading into the Xcenter and Xstore databases.
OCDS can provide the Xstore Suite the following categories of data:
Merchandise hierarchy
Organizational hierarchy
Store (including addresses)
Dimension type (derived from item differentiator, or diff usage)
Dimension value (derived from item diff usage)
Items and Item Location
Enterprise Item and Enterprise Item Location
Item UPC
Value Added Tax (VAT) rules and item associations
Related items
Initial prices
Price changes
Promotions
Clearance prices
Oracle Omnichannel Cloud Data Service (OCDS) is a data hub, enabling the Merchandising applications to share information with the Oracle Retail Omnichannel applications. OCDS is composed of three major components:
BDI Batch Job Admin - Enables the flow of data into OCDS using the Oracle Bulk Data Integration (BDI) technology. Job Admin has a User Interface (UI) to support the management of BDI batch jobs.
RIB Injector - Enables the flow of data into OCDS from the Oracle Retail Integration Bus (RIB).
ORDS Web Services - Enables the data contained in OCDS to be accessed by Omnichannel applications, such as the Xstore Suite, through the use of RESTful web services.
Figure 2-1 illustrates the major system components that make up OCDS, and the interactions of the applications major actors.
The following steps describe the flow in Figure 2-2.
OCDS receives an initial load of Merchandising foundation data using BDI as the data transport. This is generally a one-time push of data over BDI into OCDS.
OCDS starts to receive, on-going, regularly scheduled pricing and promotion data using BDI as the data transport.
OCDS starts to receive, on-going, near-real-time updates of Merchandising data using the RIB as the data transport.
Xstore Office starts polling OCDS, at a regularly scheduled interval, to check for updates (for example, additions, deletions, and modifications) of Merchandising and Pricing data used by the Xstore Suite. Xstore Office communicates requests for changes to OCDS data by calling the OCDS REST web services.
When changes to OCDS data are detected, Xstore Office generates .mnt files containing the commands to update Xstore Suite databases. When .mnt files are generated, they are automatically deposited into the Xstore Office auto-drop folder for data-loading and distribution.
If any detected OCDS updates necessitate updating the Xcenter database then the appropriate .mnt file will be automatically dataloaded.
If any detected OCDS updates necessitate updating the Xstore database then the appropriate .mnt files will be deployed to the store where they can be dataloaded either immediately or at store close.
When the OCDS integration is enabled, Xstore Office will automatically generate .mnt files with instructions for updating store databases when Merchandising or Pricing data changes are detected. Deployments of generated .mnt files, to be loaded at the store, are automatically created for either immediate or scheduled distribution. Each deployment status of the files is displayed in the Xstore Office Deployments screen.
Xstore Office Cloud Service's Integration Manager supports the use of Store Collections when configuring an OCDS integration. By associating a Store Collection with an OCDS Integration a retailer can identify which stores require data from OCDS. This feature can facilitate a phased-store rollout of OCDS data to a subset of existing stores in the Merchandising System. An OCDS integration using a Store Collection will limit the creation and deployment of mnt files to only those stores defined by the Store Collection.
Adding another store to an existing OCDS integration will enable incremental changes to start flowing to the store. A manual refresh from OCDS should be requested for the added store to seed it with a full set of OCDS data.
The OCDS integration is designed to be fully automated; under normal conditions no manual steps are required to have Merchandising and Pricing data flow from OCDS into a store database. However, Xadmin's Data Publisher can be used to regenerate and redeploy .mnt files with OCDS data to a store if exceptional circumstances necessitate the refreshing of an Xstore database.
Use of the Data Publisher to replenish one or more types of OCDS data at a store will result in the purging of all existing OCDS-sourced data, followed by the loading of a full set of the most recent OCDS data.
When the OCDS integration is enabled in Xstore Office, the DataManager screen's "Data Publisher" option will include a "Data Source" drop down list, which includes the list option: Omni Channel Data Service.
To publish OCDS data to one or more stores:
Choose the desired Organization Node for the target stores, select Omni Channel Data Service, and click Next.
Choose the type of data you wish to publish, then click Next.
Select a Download Priority, Immediate or Store Close, and click Deploy.