Install and Configure the Recipe

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

  1. On the Oracle Integration Home page, scroll to the Accelerators & Recipes section.
  2. Click Search All.
    The list of available recipes appears.
  3. Select the recipe you want to install, and click Install Install icon.
    A confirmation message informing that the recipe was successfully installed appears, and the recipe now displays the Installed tag.
  4. Click Configure Configure icon to configure the following resources using the Configuration Editor.

Configure the Oracle Google Mail Connection

You must provide connection details such as the client ID and client secret to access Google APIs, then test your connection to ensure it works.

  1. On the Configuration Editor page, select Oracle Google Mail Connection.
  2. Click Edit Edit icon.
    The Google Mail Connection window opens.
  3. Under the Security section, enter the following details:
    1. In the Client Id and Client Secret fields, enter the client ID and secret that you obtained while configuring Gmail.
    2. In the Scope field, enter https://www.googleapis.com/auth/gmail.modify.
  4. Click Save.
  5. Click Provide Consent.
    1. In the resulting dialog, enter your Oracle Integration username and password, and click Sign in.
    2. Log in to your Gmail account from the browser window that opens.
    3. Follow the prompts till you see the access allowed page.
      Switch back to your Google Mail Connection window in Oracle Integration.
  6. Click Test to ensure that your connection is successfully configured.
    You get a confirmation message if your test is successful.
  7. Click Back Go back icon to return to the Configuration Editor page. Click Save again if prompted.

Configure the Oracle FTP Read Write Connection

You must configure connection details such as connection properties and log in credentials for your FTP server.

  1. On the Configuration Editor page, select Oracle FTP Read Write Connection.
  2. Click Edit Edit icon.
    The FTP Connection window appears.
  3. In the Connection 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 22
    SFTP Connection Select Yes from the list.
  4. In the Security section, enter the following details.
    Field Information to Enter
    Security Policy Select FTP Server Access Policy.
    User Name Enter the user name to connect to your sFTP server.
    Password Enter the password to connect to your sFTP server.
  5. Click Save. If prompted, click Save for a second time to confirm.
  6. Click Test to ensure that your connection is successfully configured. In the dialog that displays, click Test again.
    You get a confirmation message if your test is successful.
  7. Click Back Go back icon to return to the Configuration Editor page. Click Save again if prompted.

Update Integration Property

You must update the integration property value so that the attachments from Gmail are exported to the right folder in the FTP server.

  1. On the Configuration Editor page, select the Oracle Gmail FTP Attachment Sync integration.
  2. Click Actions Actions icon, and then click Update Property Values.
  3. In the Update Property Values dialog, note the property that has been configured - Ftpfolderdestination.
  4. Click Ftpfolderdestination, and in the New Value field, enter the path of the directory where the Gmail attachments will be written in the FTP server. For example, oracle-int/gmail-attachments.
  5. Click Submit.
    You get a confirmation message that the integration property has been updated successfully.