1. Import Orders from Oracle ERP Cloud to Oracle Autonomous Data Warehouse
  2. About This Recipe

1 About This Recipe

Use this recipe to import orders from Oracle ERP Cloud to Oracle Autonomous Data Warehouse (ADW).

Note:

This recipe is available as Oracle ERP Cloud — Oracle ADW | Import Orders in Oracle Integration. Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.

Overview

This recipe imports the order details of a new order created in Oracle ERP Cloud (Order Management Module) to a database table in Oracle ADW.

To use the recipe, you must install the recipe and configure the connections and other resources within it. The recipe contains two integration flows, one for receiving the orders from Oracle ERP Cloud and then updating the same into an Apache Kafka topic, and another for writing the orders from the Apache Kafka topic into the Oracle ADW database table. When an order is created in Oracle ERP Cloud, the first integration (Oracle ERP Kafka Order Sync Producer) is triggered. The integration flow receives the order details from Oracle ERP Cloud and writes it into an Apache Kafka topic. This in turn triggers the second integration (Oracle Kafka ADW Order Sync Consumer) which consumes the order from the Apache Kafka topic and writes it to the Oracle ATP database table, thereby importing the newly created order from Oracle ERP Cloud.

System and Access Requirements

  • Oracle Integration, Version 24.10 or higher

  • Oracle ERP Cloud

  • Oracle ADW

  • Apache Kafka

  • An account on Oracle ERP Cloud with the Administrator and Procurement Manager roles

  • An account on Oracle ADW with the Administrator role

  • An Oracle ADW database table with write access

  • An account on Apache Kafka with the Administrator role

Recipe Schema

This section provides an architectural overview of the recipe.


Description of erp-kafka-adw.png follows
Description of the illustration erp-kafka-adw.png

An event is raised in Oracle ERP Cloud when an order is created. This triggers the first integration flow in Oracle Integration. The integration flow uses the Oracle ERP Cloud Adapter and the Apache Kafka Adapter (Producer) to get and write the order details to an Apache Kafka topic. This in turn triggers the second integration flow which uses the Apache Kafka Adapter (Consumer) and Oracle Autonomous Data Warehouse Adapter to write the order details from the Apache Kafka topic to an Oracle ADW database table.