About This Recipe

This recipe imports the order details of a new order created in Oracle ERP Cloud (Order Management Module) to a database table in Oracle Autonomous Data Warehouse (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 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 ADW 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 Autonomous Data Warehouse

  • Apache Kafka

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

  • An account on Oracle Autonomous Data Warehouse with the Administrator role

  • An Oracle Autonomous Data Warehouse 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 ADW database table.