Before You Install the Recipe

You must perform the following configuration tasks on your Gmail instance and sFTP server in order to successfully connect to these external systems using Oracle Integration and export email attachments from Google Gmail to an FTP server.

Configure Gmail

You must obtain the Gmail API credentials, that is the Client ID and Secret, for connecting to Gmail from Oracle Integration.

  1. Log in to your Google account and access the Google Developer console at https://console.developers.google.com.
  2. On the Title bar of the Google Cloud Platform page, click the Select a project drop-down list.
  3. Select an existing project to use or create a new project.
    Note that if you create a new project, ensure that the project is selected from the drop-down list after saving the new project. You’ll be able to view the project’s dashboard only if you select the project.
  4. Click ENABLE APIS AND SERVICES. Alternatively, click Library in the left navigation pane.
    The API Library page opens.
  5. In the Search field enter Gmail API, and then select Gmail API from the search results.
  6. On the Gmail API window, click MANAGE.
  7. In the left navigation pane, click Credentials.
  8. At the top of the Credentials window, click CREATE CREDENTIALS and then choose OAuth client ID.
  9. In the Application type field, select Web Application from the drop-down list.
  10. Enter a name for the OAuth Client ID in the Name field.
  11. Scroll to the Authorized redirect URIs section and click ADD URI.
  12. Enter the following URL in the URIs field.
    https://OIC_HOST:OIC_SSL_PORT/icsapis/agent/oauth/callback
    Where,
    • OIC_HOST is the Oracle Integration instance host name.
    • OIC_SSL_PORT is the Oracle Integration SSL port.
  13. Click CREATE.
    A message confirms that the OAuth Client has been created.
  14. In the resulting dialog, copy the Client ID and Client Secret.
    Note the Client ID and Secret. You’ll need these later while configuring the Google mail connection from Oracle Integration.
  15. Click OK.
    You return to the Credentials window, and the OAuth Client ID that you created is listed under the OAuth 2.0 Client ID section.

    Note:

    Before creating a Gmail connection, you must upload the trusted Gmail public certificate to Oracle Integration. The trusted Gmail public certificate can be downloaded from https://gmail.com. Rename the GoogleCertificate.txt file extension to .cer.

    See Upload an SSL Certificate and Certificate Errors in Using the Google Gmail Adapter with Oracle Integration 3.

Access Your FTP Server and Create a Directory

Obtain a sFTP server and ensure that you're able to access it.

  1. Log in to the server using your user name and password through an FTP client; for example, FileZilla.
  2. Create a directory (gmail-attachments) on the server into which the attachments from Gmail will be written. Note down the path of the directory.