Twitter Query Authentication Guide

Twitter Query Authentication Guide


Overview

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

Important Information

  • The Twitter Query connector uses an OAuth for third-party authentication.
  • While connector properties may differ between Cloud Data Warehouses, the authentication process remains the same.
  • Twitter accounts need to apply for authorisation to develop apps. If the associated account has not yet been authorised, please be aware that the authorisation process may take some time and is unfortunately outside of Matillion's control.

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 Twitter 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 on the Service dropdown menu and select Twitter. 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 Twitter Developer portal and click Sign in in the top right of the screen. The browser will redirect to a login screen. Enter valid login credentials to continue.

    Sign in to Twitter Developer portal

    Sign in to Twitter Developer portal

  2. Once logged in, Sign in will be replaced on the menu by the profile name. Click <Profile Name>Apps.

    Twitter Developer portal

    Twitter Developer portal

  3. Then, on the Apps dashboard, click Create an app on the top right of the window above the apps list.

    App dashboard

    App dashboard

  4. On the Create an app page, provide details for the following fields:

    • App name – provide an appropriate name for the app
    • Application description – provide a description of the app for users
    • Website URL – provide a website to be associated with the app
    • Callback URLs – paste the Callback URL (copied from the Manage OAuth window in Matillion ETL earlier)

    Create an app

    Create an app

  5. Next, scroll down the page to the field below Tell us how this app will be used and provide details on how the app will be used. Then, click Create.

    How the app will be used

    How the app will be used

  6. A pop-up window will then appear prompting a review of Twitter's Developer Terms, before creating the app. Click Create to agree.

    Review Twitter's Developer Terms

    Review Twitter's Developer Terms

  7. The browser will then return to the app page. Click the Keys and tokens tab at the top of the window.

  8. On the Keys and tokens tab, copy the codes next to API key and API secret key as they will be required in Authorising for use in Matillion ETL.

    Please Note

    • Make sure to copy the API secret key right away as it may appear only once.
    • Additionally, when copying the codes, some browsers may add a space to the end of the code. Watch out for this as it will cause the credentials to fail.
    Copy the API key and API secret key

    Copy the API key and API secret key


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 Twitter Developer portal earlier, provide details for the following fields:

    Configure OAuth settings

    Configure OAuth settings

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

    Authorization link

    Authorization link

  4. The browser will then redirect to a Twitter screen requiring authorisation to access the associated account. Click Authorize appto confirm.

    Authorise access to Twitter account

    Authorise access to Twitter 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