Bing Ads Query Authentication Guide
    • Dark
      Light

    Bing Ads 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 Bing Ads Query connector for use in Matillion ETL.

    Important Information

    • The Bing Ads Query connector uses an OAuth for third-party authentication.
    • While connector properties may differ between Cloud Data Warehouses, the authentication process remains the same.
    • Most third-party apps and services that connect to Microsoft data can be setup for use in Matillion ETL through the Microsoft Azure Portal using much of the same process.

    Creating an OAuth Entry in Matillion ETL

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

      Please Note

      If a Bing Ads 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. Click ... next to the Authentication input, 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 of the window to open the Create OAuth Entry window.

      New OAuth entry

      New OAuth entry

    4. Click the Service dropdown menu and select Bing Ads. 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.

      New Entry listed on Manage OAuth window

      New Entry listed on Manage OAuth window


    Acquiring Third-Party Credentials

    1. Navigate to the Microsoft Azure Portal. The Microsoft Azure login screen will appear immediately. Enter valid login credentials to continue. The browser will then redirect to the Microsoft Azure dashboard. Click App registrations on the Azure services menu at the top of the screen.

      Please Note

      If App registrations is not available on the Azure services menu, simply click More services, on the right of the menu, for a longer list of options.

      Microsoft Azure dashboard

      Microsoft Azure dashboard

    2. On the App registrations page, click + New registrations on the menu at the top of the screen.

      App registrations

      App registrations

    3. Now, in the Register an application window, provide details for the following fields:

      • Name – provide a name for the app
      • Supported account types – tick Accounts in any organizational directory (Any Azure AD directory - Multitenant) and personal Microsoft accounts
      • Redirect URI (optional) – paste the Callback URL (copied from the Manage OAuth window in Matillion ETL earlier), then click Register

      Register an application

      Register an application

    4. The browser will then redirect to the Overview window on the app's newly created dashboard. From here, copy the Application (client) ID as it will be required in Authorising for use in Matillion ETL.

      Please Note

      When copying the code, some browsers may add a space to the end of the code. Watch out for this as it will cause the credentials to fail.

      App Overview

      App Overview

    5. Next, click Certificates & secrets on the sidebar on the left. Then, in the main window, click + New client secret.

      Certificates & secrets

      Certificates & secrets

    6. The Add a client secret pop-up window will then appear. Provide details for the following fields:

      • Description – provide a description of the client secret
      • Expires – tick the checkbox next to when the client secret should expire, then click Add

      Add client secret

      Add client secret

    7. Returning to the Certificates & secrets window, the new client secret will appear on the list in the Client secrets section. Copy the relevant client secret as it will be required in Authorising for use in Matillion ETL.

      Please Note

      • Make sure to copy the client secret right away as it may appear only once.
      • Additionally, when copying the client secret, some browsers may add a space to the end of the code. Watch out for this as it will cause the credentials to fail.
      Microsoft Advertising Developer Account

      Microsoft Advertising Developer Account

    8. Navigate to the Microsoft Advertising Developer Account page. The browser should automatically open on the Microsoft Advertising account dashboard. From here, copy the code next to Developer token as it will be required in Authorising for use in Matillion ETL.

      Please Note

      If the browser does not automatically log in to the Microsoft Advertising Developer Account, simply click Log in and enter valid login credentials to continue. Super Admin role login credentials are required.

      Copy the client ID and secret

      Copy the client ID and secret

    9. Next, navigate to the Microsoft Advertising Developer Portal. It will open on the Campaigns page. This page's URL will contain the Customer ID (after cid=) followed by the Account ID (after aid=). Copy both codes as they will be required in Authorising for use in Matillion ETL.

      Example

      https://ui.ads.microsoft.com/Campaign/Campaigns.m?cid=CustomerID&aid=AccountID#/customer/CustomerID/account/AccountID/overview

    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.

      Configure OAuth settings

      Configure OAuth settings

    2. Using the codes copied from the Microsoft Azure Portal earlier, provide details for the following fields:

      Configure OAuth settings

      Configure OAuth settings

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

      Authorization link

      Authorization link

    4. The browser will then redirect to a window to confirm valid login credentials, before requesting access to data in the associated Microsoft account. Click Yes to confirm.

      Connect and Allow access to Microsoft account

      Connect and Allow access to Microsoft account

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

      OAuth Authorization successful

      OAuth Authorization successful