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 Workday 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 Workday host name. For example: https:// wd2-impl-services1.workday.com
    Tenant Hame Enter the tenant’s 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
    Workday Integration User Enter the username 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 FTP Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    FTP Server Host Address Enter the host address of your sFTP server.
    FTP Server Port Enter 22.
    SFTP Connection Select Yes from the list.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select FTP Public Key Authentication.
    Username Enter the user name to connect to your sFTP server.
    Private Key File Upload the private key file for your sFTP server.
  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 Integration Flow (Optional)

If you want to fetch additional information about Workday employee records (other than what is pre-configured in this recipe), you can modify the filter criteria of the Workday request-mapper element in the integration flow. To successfully process the additional fields fetched, you must update the Stage File element of the integration flow with a new schema file that contains the structure of the updated data set.

Modify the Filter Criteria

  1. In the Integrations section, select the Workday FTP Export Employee Records integration flow.
  2. On the integration canvas, click the Map to GetWorkers element, and then click Actions Actions icon and select Edit to open the mapper.
  3. In the mapper, under Response_Group, find the required element. For example, to fetch employment information, find and click the Include_Employment_Information element.
  4. In the editor that opens, set:
    • True: to export selected information to the FTP server.
    • False: to exclude selected information.
  5. Click Save and then click Validate.

To return to the project workspace, click Go back Back icon.

Update the Stage File Element

  1. Add the required additional fields to your sample schema file.

    Note:

    To obtain a sample schema file, run the recipe without modifying the filter criteria initially. The recipe populates the employee data into the specified file on your FTP server. You can use this file as the sample schema file.
  2. Edit the Stage File element on the integration canvas and upload the modified file. See Configure a Stage File Action in Using Integrations in Oracle Integration 3.