1 About This Recipe

Use this recipe to import purchase order details (and associated customer data) from Oracle ERP Cloud to a Microsoft SQL Server database.

Note:

This recipe is available as Oracle ERP Cloud — Microsoft SQL | Import Purchase Order Details in the Integration Store. 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 is an application-driven recipe that saves the order details (and associated customer data) in a Microsoft SQL Server database whenever a purchase order is created in Oracle ERP Cloud.

To use the recipe, you must install the recipe and configure the connections and other resources within the recipe. When a purchase order is created in Oracle ERP Cloud, the integration flow of the recipe is triggered, and it saves the purchase order details in a Microsoft SQL Server database.

System and Access Requirements

  • Oracle Integration, Version 23.8.0.0.0 or higher

  • Oracle ERP Cloud

  • An account on Oracle ERP Cloud with the Administrator role

  • A Microsoft SQL Server database

  • An account on the Microsoft SQL Server database with the Administrator role