1. Import Purchase Orders from Oracle ERP Cloud to Microsoft SQL Server
  2. Install and Configure the Recipe

3 Install and Configure the Recipe

On your Oracle Integration instance, install the recipe to deploy and configure the integration and associated resources.

  1. On the Oracle Integration Home page, in the Use a recipe/accelerator section, click View all.
  2. Find the recipe you want to install, then click Get.
    A message confirms that the recipe was successfully installed, and the recipe card shows In use.
  3. Click Configure Configure icon on the recipe to configure its resources.

    The project workspace opens, displaying all the resources of the recipe. Configure the following resources before you activate and run the recipe.

Configure the Oracle ERP Cloud Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the Oracle ERP Cloud host name. For example: https://your_domain_name.fa.DC.oraclecloud.com.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Username Password Token.
    User Name Enter the user name of the account created for Oracle Integration on the Oracle ERP Cloud instance. See Configure Oracle ERP Cloud.
    Password Enter the password of the account created for Oracle Integration on the Oracle ERP Cloud instance.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.
    A message confirms if your test is successful.
  6. To return to the project workspace, click Go back Back icon.

Configure the Oracle Microsoft SQL Server Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    Host Name Enter the Microsoft SQL Server host name.
    Port Enter the Microsoft SQL Server port.
    Database Name Enter the name of the database.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Username Enter the username of your Microsoft SQL Server instance.
    Password Enter the password of your Microsoft SQL Server instance.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.
    A message confirms if your test is successful.
  6. To return to the project workspace, click Go back Back icon.