Oracle Eloqua Query Authentication Guide
    • Dark
      Light

    Oracle Eloqua Query Authentication Guide

    • Dark
      Light

    Article Summary

    Overview

    This is a step-by-step guide to creating an OAuth entry, acquiring credentials and authorising the Oracle Eloqua Query connector for use in Matillion ETL.

    Important Information

    • The Oracle Eloqua Query connector uses username and password or OAuth for third-party authentication. This guide will only explain the OAuth method.
    • While connector properties may differ between Cloud Data Warehouses, the authentication process remains the same.

    Creating an OAuth Entry in Matillion ETL

    1. In Matillion ETL, on the top left corner of the screen, click ProjectManage OAuth.

      Please Note

      If a Oracle Eloqua Query connector has already been added to an Orchestration Job, the Manage OAuth window may also be accessed using the following method:

      1. Click the connector icon to open the Properties panel at the bottom of the screen.
      2. Then, click ... next to the Authentication Method input.
      3. Select OAuth from the dropdown menu in the pop-up window and click OK.
      4. The Authentication input will now appear on the list of properties. Click ... next to it, and finally click Manage in the pop-up window.
      Project dropdown menu

      Project dropdown menu

    2. Copy the Callback URL in the field at the top of the window as this will be required in Acquiring Third-Party Credentials.

    3. Click + in the bottom left corner of the window to open the Create OAuth Entry window.

      New OAuth entry

      New OAuth Entry

    4. Click on the Service dropdown menu and select Eloqua. Then, provide a name for the OAuth in the Name field and click OK.

      Create OAuth Entry window

      Create OAuth Entry window

    5. On returning to the Manage OAuth window, check the list of OAuths to ensure the new entry is listed.

      Please Note

      This entry is Not Configured. Configuration of the OAuth entry will be discussed in Authorising for use in Matillion ETL.

      OAuth Entry list

      New Entry listed on Manage OAuth window


    Acquiring Third-Party Credentials

    1. Navigate to the Oracle Eloqua website and click Oracle Eloqua Login on the right of the header menu. The browser will then redirect to a login screen. Enter valid credentials to continue.

      Oracle Eloqua Login homepage

      Oracle Eloqua Login homepage

    2. The My Eloqua dashboard will then open. Click on the right of the header menu.

      My Eloqua dashboard

      My Eloqua dashboard

    3. Next, on the Settings page, click AppCloud Developer at the bottom of the Platform Extensions section.

      Platform Extension

      Platform Extension

    4. On the top right of the AppCloud Developer dashboard, click Create App.

      AppCloud Developer Page

      AppCloud Developer Page

    5. The Create App pop-up window will appear. Provide details for the following required (*) fields:

      • Name – provide a name for the app
      • Description – provide a brief description about the app
      • Icon – provide a URL for an icon for the app
      • OAuth Callback URL – paste the Callback URL (copied from the Manage OAuth window in Matillion ETL earlier), then click Save

      Create App

      Create App

    6. The browser will redirect to the newly created app's information page. In the Authentication to Eloqua section, copy the codes next to Client Id and Client Secret as they will be required in Authorising for use in Matillion ETL.

      Please Note

      • Before the Client Secret can be copied, click 👁 to make it visible.
      • Additionally, when copying the codes, some browsers may add a space to the end of the string. Watch out for this as it will cause the credentials to fail.
      Copy Codes

      Copy codes


    Authorising for Use in Matillion ETL

    1. Return to the Manage OAuth window in Matillion ETL and click next to the previously created OAuth entry. This will open the Configure OAuth window.

      Manage OAuth

      Manage OAuth

    2. Using the codes copied from the Oracle Eloqua website earlier, provide details for the following fields:

      Configure OAuth settings

      Configure OAuth settings

    3. The next window will have an Authorization Link. Click on the link to authorise Matillion ETL to use the acquired credentials.

      Authorization Link

      Authorization Link

    4. The browser will then redirect to a Oracle Eloqua screen requiring confirmation of the associated account. Click Accept to confirm.

      Confirm Eloqua User

      Confirm Eloqua User

    5. If all is successful, the browser will return to Matillion ETL with a window stating, "Authorization Successful".

      OAuth Authorization Successful

      OAuth Authorization Successful


    What's Next