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 Google Mail Connection

  1. In the Connections section, click the connection name.
  2. In the Security section, enter the following details:
    Field Information to Enter
    Client ID Enter the client ID obtained while configuring Gmail. See Configure Gmail.
    Client Secret Enter the client secret obtained while configuring Gmail.
    Scope Enter https://www.googleapis.com/auth/gmail.modify.
  3. Click Save. If prompted, click Save again.
  4. 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.
  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 Read Write 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 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.
  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.

Update Integration Properties

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

  1. In the Integrations section, click Actions Actions icon on the integration flow, then select Update property values.
  2. In the Update Property Values dialog, note the property that has been configured: Ftpfolderdestination.
  3. 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.
  4. Click Submit.

    A message confirms that the integration properties have been updated successfully.