1. Import Orders from Oracle ERP Cloud to Oracle Autonomous Data Warehouse
  2. Activate and Run the Recipe

4 Activate and Run the Recipe

After you've configured the connections and other resources, you can activate and run the recipe.

  1. In the project workspace, click Activate. In the Activate project panel, with the default project deployment selected, choose an appropriate tracing option, then click Activate.

    A message confirms that the integrations have been activated. Refresh the page to view the updated status of the integrations.

  2. Run the recipe.
    1. Log in to your Oracle ERP Cloud instance with the Procurement Manager role.
    2. Create an order.
      Click the Task drop-down menu, and select Create Order.

    On successfully creating an order in Oracle ERP Cloud, the first integration flow Oracle ERP Kafka Order Sync Producer gets triggered and it receives the order details and writes the same into the Apache Kafka topic. Subsequently, the second integration flow Oracle Kafka ADW Order Sync Consumer gets triggered which consumes the order details from the Apache Kafka topic and writes it to the Oracle ADW database table.

  3. Monitor the running of the integration flows in Oracle Integration.
    1. In the project workspace, click Observe. You'll see the integration flows being triggered and running successfully.
    2. To manage errors in your project, see Manage Errors in a Project.
  4. Verify that the order details are written to the Oracle ADW database table.
    Execute the following command:
    SELECT * FROM ERPUSER.SALES_ORDER_LINEITEMS

          SELECT * FROM ERPUSER.SALES_ORDER_HEADER

Related Documentation