Skip to content

Bing Search Query authentication guide

Overview

This is a step-by-step guide to acquiring credentials and authorising the Bing Search Query connector for use in Matillion ETL.

Important Information

  • The Bing Search Query connector uses an API token for third-party authentication.
  • While connector properties may differ between Cloud Data Warehouses, the authentication process remains the same.

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 Cognitive Services on the Azure services menu at the top of the screen.

    Please Note

    If Cognitive Services 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 Cognitive Services page, click + Add.

    Cognitive Services

    Cognitive Services

  3. The browser will redirect to the AI + Machine Learning window on the Microsoft Azure Marketplace. To find the Bing Search service, either type "Bing Search" into the search field at the top of the window or scroll down and click the Bing Search service block found below.

    Microsoft Azure Marketplace

    Microsoft Azure Marketplace

  4. Now, on the Bing Search page, click Create.

    Bing Search resource

    Bing Search resource

  5. On the next page, fill in the required fields (*), confirm the notice has been read and understood, then click Create.

    Create API key

    Create API key

  6. Next, an Overview page for the newly created Bing Search deployment will open. Check all the details are correct, then click Go to resource.

    Resource Overview

    Resource Overview

  7. The browser will redirect to the Quick start window on the deployment dashboard. From here, copy the API key from the list, as it will be required in Authorising for Use in Matillion ETL.

    Please Note

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

    Quick Start

    Quick Start

Authorising for Use in Matillion ETL

  1. If a Bing Search Query connector has not already been dragged onto the job canvas, search "Bing Search" using the Components panel search field, or find the Bing Search Query connector under Orchestration → Load/Unload → Internet.

    Please Note

    An Orchestration Job must be open on the job canvas within Matillion ETL to ensure the Bing Search Query connector is searchable within the Components panel.

  2. Then, click and drag the Bing Search Query connector onto the job canvas.

    Search for Bing Search Query connector

    Search for Bing Search Query connector

  3. Click the connector icon on the job canvas to open the Properties panel at the bottom of the screen.

  4. Then, click ... next to the API Key input.

    Open Bing Search Query connector properties

    Open Bing Search Query connector properties

  5. In the API Key pop-up window, paste the API key (copied from the Microsoft Azure Portal earlier) into the Store in component field and click OK.

    Please Note

    Passwords and codes can also be saved using the Matillion ETL Password Manager. To learn how to do this, please refer to the Manager Passwords article.

    Paste the API key

    Paste the API key

  6. If the API Key is entered correctly, the connector should be authenticated and the status of the input will be displayed as OK.

    Connector successfully authenticated

    Connector successfully authenticated