Integrate Oracle Fusion Cloud Warehouse Management with an External Data Warehouse or Data Lake

In this use case, warehouse data is extracted from a warehouse management system and fed to data hubs.

Description Integration Type Integration Options Notes

A warehouse management system is a source of truth for inventory in a supply-chain network. This data might need to be sent to a hub for consolidation, and for visibility and performing analytics. It would require extracting data periodically from a warehouse management system and feeding it to feed to data hubs.

In a scenario such as this, Oracle Warehouse Management provides REST APIs to
  • Pull data for extraction from various business-object and transactional entities in a warehouse management system.
  • Push data from Oracle Warehouse Management to external systems using various extraction processes.

Planning for the integration requires you to:

  • Identify the data that needs to be extracted and how often.
  • Identify volume considerations.
  • Identify and plan the extraction schedule.
Outbound

REST API

SFTP

For a large data transaction with some embedded business logic, an integration middle layer is recommended.

Explore ready-to-use integration packages if the mapping is uncomplicated or if using Oracle back-end systems.