How to setup JIRA Integration

This integration will allow you to connect with JIRA and start collecting your data. It is a matter of minutes to send your development data to feed your BI, your data warehouse, or your custom analytics stack. With your JIRA data into one place like Google BigQuery, PostgreSQL, Amazon Redshift or Microsoft SQL Server, it is much easier to analyze your development and support data. You can even get it a bit further up by combining with transactional data or data from your support and analyzing them using your favorite Analytics, Business Intelligence, or querying tools.

Our JIRA integration uses our Incoming Webhooks to connect and sync data. For more information on Incoming Webhooks, check out the Setting up Incoming Webhooks guide in our knowledge base.
Our JIRA integration is currently in open beta.

What can I see with Webhooks on JIRA?

You can use a webhook as a trigger of events. When you want a trigger or update sent from JIRA after an issue event occurs, use a webhook. For example:

  • You can trigger a webhook when JIRA issues are created, modified, deleted, or when worklogs are changed.
  • You can create a webhook that fires only for a specific JIRA workflow transition. Using this approach you can start doing “Story Driven Development.”

You can see a list of events you can enable in the picture bellow.

Jira Webhook integration

Getting Started – Setup JIRA integration at Blendo.

1. Login to your JIRA dashboard from a browser tab

2. Click on the gear icon in the top right side of your dashboard and click on System.

Jira integration

3. Scroll way down and click on WebHooks.

Jira Webhook integration

4. Click on Create a WebHook.

Jira Webhook integration

5. You now have two options to send your event data to Blendo: Either send all your event data in one webhook or to separate webhooks. What you will choose it depends on what you want to track.

Setup JIRA and Blendo integration

In Blendo, for every separate webhook that you create, another different table will be created in your output database. For example:

a) You may create a webhook in Blendo that you will send all the Issue events (create, update, delete, worklog changed).

b) Create another webhook in Blendo that you will send all the Sprint events.

6. Open Blendo in a new browser tab.

7. Add a webhook (in our example we will use this to receive only the Issue events)

Setup JIRA Webhook integration8. In the new page, you will setup the Webhook. Add a table prefix if you like. It will help better separate your tables. Click Save.

Setup JIRA Webhook integration

9. Then you will return back to the home dashboard. Click on your new Webhook data source.

Setup JIRA Webhook integration

10. Let’s change the name to reflect its use. Hover over the name Webhook and click on it and rename it if you like.

Setup JIRA Webhook integration10. In the same page you may see the Webhook address we are going to use to send our JIRA data.

Setup JIRA Webhook integration

11. Copy the URL.

12. Go to your JIRA browser tab.

13. In URL boxpaste the URL we copied from step #11 above. For the Events, check: Issue.created, Issue.deleted, Issue.updated. Click Save.

JIRA webhook

Next Steps:

Blendo will now start receiving data from your JIRA data sourc and it will copy everything into your destination data warehouse. 

Questions? Contact us!

in Connecting SaaS Data Sources