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 REST Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    Connection Type Select REST API Base URL.
    Connection URL Enter your Oracle Integration instance URL. For instance, https://<instance-name>.com/.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Basic Authentication.
    Username Enter the username of your Oracle Integration account.
    Password Enter the password of your Oracle Integration account.
  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 Workday Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    Hostname

    Enter the Workday host name. For example: https:// wd2-impl-services1.workday.com.

    Tenant Name

    Enter the tenant name of the account created for Oracle Integration on Workday.

    See Configure Workday.

  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Workday Username Token Policy.
    Workday Integration User

    Enter the user name of the account created for Oracle Integration on Workday.

    See Configure Workday.

    Password

    Enter the password of the account created for Oracle Integration on Workday.

  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 ServiceNow Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    • In the ServiceNow Instance Name field, enter your ServiceNow instance URL. For example, https://instance_name.service-now.com.
  3. In the Security section, enter the following details:
    • In the Username and Password fields, enter your ServiceNow username and password.
  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 Lookup Table

The recipe contains the following two lookup tables. Edit them as necessary.

  • ORACLE-BRT-LOOPCOUNT_LOOKUP: Use this lookup to configure the loop count, Workday EIB report name, and employee types.
    Property Description Value
    LoopCount Specify the maximum number of iterations for a loop. 10
    WorkdayReportName Specify the name of the Workday EIB report. EIB_new_hire_report
    EmployeeType Specify the type of the employee. Employee_ID
  • ORACLE-BRT-WD_SERVICENOW_LOOKUP: Use this lookup to map the priority and department between Workday and ServiceNow.
    Property Description Value WD_Value SN_Value
    Priority Priority Values mapped between Workday and ServiceNow. 2-High Sales Sales
  1. In the Lookups section, click the lookup name.
  2. In the Value column, enter or map the appropriate values for the properties.
  3. Click Save. If prompted, click Save again.
  4. To return to the project workspace, click Go back Back icon.