1. Import Sales Orders from Oracle NetSuite to Oracle Autonomous Data Warehouse
  2. About This Recipe

1 About This Recipe

Use this recipe to import sales orders from Oracle NetSuite to Oracle Autonomous Data Warehouse (ADW).

Note:

This recipe is available as Oracle NetSuite — Oracle ADW | Import Sales Orders 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 recipe imports sales orders created in Oracle NetSuite and loads them into Oracle ADW database.

To use the recipe, you must install the recipe and configure the connections and other resources within the recipe. Subsequently, you can activate and run the integration flow manually or specify an execution schedule for it. When triggered, the integration flow uses a schedule parameter sinceDateTime to query sales orders created on or after the date and time specified in the parameter. The recipe then extracts the sales orders from Oracle NetSuite and writes them into Oracle ADW database tables.

System and Access Requirements

  • Oracle Integration, Version 21.2.1.0.0 or higher

  • Oracle NetSuite, Version 2023.1.0

  • Oracle Autonomous Data Warehouse (ADW), Oracle Database 19c Enterprise Edition

  • An Autonomous Database instance created in Oracle Cloud Infrastructure (OCI)

  • An account in Oracle NetSuite with the Administrator role

  • An account in Oracle ADW with the Administrator role

  • An Oracle ADW table with write access