Jira Query Authentication Guide

Jira Query Authentication Guide


Overview

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

Important Information

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

Creating an OAuth Entry in Matillion ETL

  1. Navigate to the Atlassian portal. The Atlassian login screen will appear immediately. Enter valid login credentials to continue. The browser will then redirect to the Atlassian product dashboard. On the dashboard, in the bottom left of the screen, click <Profile>Manage your account .

    Atlassian product dashboard

    Atlassian product dashboard

  2. Next, on the Atlassian account page, click Security on the sidebar on the left of the screen.

  3. Then, in the Security window, click Create and manage API tokens at the bottom of the API token.

    Atlassian account security

    Atlassian account security

  4. The Manage your account page will open on the API tokens window. Click Create API token.

    API tokens

    API tokens

  5. The Create your API token pop-up window will appear. In the Label field, provide a memorable and concise name for the API token. Then, click Create.

    Create your API token

    Create your API token

  6. The Create your API token will be replaced by the Your new API token pop-up window. Copy the code in the field as this will be required in Authorising for use in Matillion ETL.

    Please Note

    • Make sure to copy the API token right away as it will only appear once.
    • When copying the token, 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 new API token

    Copy new API token


Authorising for use with Matillion ETL

  1. If a Jira Query connector is not already on the job canvas, search "Jira" using the Components search field, or find the Jira Query connector under OrchestrationLoad/UnloadInternet.

    Please Note

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

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

    Search for Jira Query connector

    Search for Jira 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 Authentication Method.

    Open Jira Query connector properties

    Open Jira Query connector properties

  5. In the the Authentication Method pop-up window, select User/API Token from the dropdown and click OK. The API Token input will now appear in the list of properties under the Username input.

    Select Authentication Method

    Select Authentication Method

  6. Next, click ... next to the Username input. Then, in the Username pop-up window provide the Username (used to log into the Atlassian portal earlier) into the field provided and click OK.

    Provide username associated with app

    Provide username associated with app

  7. Finally, click ... next to the Password input. Then, in the Password pop-up window, paste the API token (copied from the Atlassian portal earlier) into the Store in component field and click OK.

    Paste the API token

    Paste the API token

  8. If all inputs are entered correctly, the connector should be authenticated and the status of the inputs will be displayed as OK.

    Authorizing Successful

    Authorising Successful