About This Recipe
This recipe imports sales orders created in Oracle NetSuite and loads them into Oracle Autonomous Data Warehouse database.
To use the recipe, you must install the recipe package and configure the connections and other resources within the recipe package. 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 Autonomous Data Warehouse 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, 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 Autonomous Data Warehouse with the Administrator role
-
An Oracle Autonomous Data Warehouse database table with write access