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

4 Activate and Run the Recipe

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

  1. In the Configuration Editor, click Activate in the title bar. In the Activate Package dialog, click Activate again.
    A message confirms that the integration has been activated. Refresh the page to view the updated status of the integration.
  2. Run the recipe.
    1. In the Configuration Editor, select the integration flow.
    2. Click Run Run icon, then click Submit Now.
    3. In the resulting dialog, click Confirm.

      The Schedule Parameters page is displayed, where you can specify a value for the sinceDateTime parameter. This parameter fetches all the sales orders created on or after the date and time specified and loads them into Oracle ADW. Enter a value, for example, 2022-09-02T00:00:00Z in the New Value field to fetch all the sales records from Oracle NetSuite created on or after the date specified. The parameter’s value is automatically updated after each successful run.

    4. On the Schedule Parameters page, click Submit.

      Note:

      You can also schedule this integration to run at a date, time, and frequency of your choosing. See Define the Integration Schedule.
  3. Monitor the running of the integration flow in Oracle Integration.
    1. In the Configuration Editor, select the integration flow.
    2. Click Run Run icon, then click Track Instances.
      On the Track Instances page, observe that the integration has been triggered and running successfully. The recipe fetches the sales orders from Oracle NetSuite and imports them into Oracle ADW.
  4. Log in to the Oracle ADW instance and check if sales orders from Oracle NetSuite have been imported into the Oracle ADW database table.

Related Documentation