Install and Configure the Recipe

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

Install the recipe on your Oracle Integration instance. See Install a Recipe or Accelerator.

After you've installed the recipe, configure the following resources:

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 Microsoft SQL Server Database

To access the Microsoft SQL Server database from Oracle Integration and import customer and purchase order details, you must perform certain configurations on your Microsoft SQL Server instance. See Prerequisites for Creating a Connection in Using the Microsoft SQL Server Adapter with Oracle Integration 3.

In addition, log in to your Microsoft SQL Server Management Studio and add tables according to the following information. See Create Tables (Database Engine).

  1. Create Customer table with the following columns.
    Column Datatype
    BuyerId varchar(255)

    Note:

    Select this variable as the Primary Key (PK) and Not Null (NN).
    PersonName varchar(255)
    Gender varchar(255)
    Email varchar(255)
    WorkPhone varchar(255)
    Address1 varchar(255)
    Address2 varchar(255)
    Building varchar(255)
    City varchar(255)
    Province varchar(255)
    PostalCode varchar(255)
    Country varchar(255)
  2. Similarly, create another table named PurchaseOrder, and add the following columns.
    Column Datatype
    POHeaderId varchar(255)

    Note:

    Select this variable as the Primary Key (PK) and Not Null (NN).
    OrderNumber varchar(255)
    ProcurementBU varchar(255)
    BuyerId varchar(255)
    Buyer varchar(255)
    Ordered varchar(255)
    Supplier varchar(255)
    SupplierId varchar(255)
    Currency varchar(255)
    DiscountAmount varchar(255)
    TotalTax varchar(255)
    Total varchar(255)
  3. Create another table named PurchaseOrderDetail, and add the following columns.
    Column Datatype
    POHeaderId varchar(255)

    Note:

    Select this variable as the Primary Key (PK) and Not Null (NN).
    OrderNumber varchar(255)
    POLineId varchar(255)
    LineNumber varchar(255)
    LineType varchar(255)
    Quantity varchar(255)
    Item varchar(255)
    SupplierId varchar(255)
    ItemId varchar(255)
    ItemDescription varchar(255)
    Price varchar(255)