how to get data from JIRA to be used in Tableau Reports

[abhishek singh]

i want to use data from JIRA environment to be used in my tableau reports , Tableau does not provide any native connector for this so may be I have to Built a web connector for tableau , but I need to know how data is saved inside JIRA and how can we retrieve this data both from server and cloud .

[Amy Biasella · Accepted solution]

For cloud, there is a plugin that can help: https://marketplace.atlassian.com/plugins/com.kaanha.jira.tableau/cloud/overview

Server is a bit trickier, and you may find some answers on this Tableau forum question (essentially asking the same question):

https://community.tableau.com/ideas/3658

[abhishek singh]

thanks amy

[Navarambh Software - Gmail]

The add-on is available for all three versions of Jira - Cloud, Server, Data Center.

https://marketplace.atlassian.com/apps/1214641/aio-tableau-connector-for-jira

Please feel free to AIO support at support@aioreports.com in case of any issues.

Regards

AIO Support

[Gabe Kressel]

Hi,

if you're looking for an automation solution, I can recommend you try the 3rd party app Skyvia. It provides Jira to Tableau integration (https://skyvia.com/data-integration/analyze-jira-with-tableau) with an additional step - loading Jira data to a database or a cloud data warehouse.

I found Skyvia on the Atlassian marketplace.

[Bibek Behera]

Hi Everyone!

For using any third-party connector or using any in-house connector you have to keep in mind the points mentioned in the below article, mainly the authentication and performance part!

https://help.tableau.com/current/server/en-us/datasource_wdc.htm

Thanks!

[Yuliia Maidanova -Alpha Serve-]

You can try our Tableau Connector for Jira https://marketplace.atlassian.com/apps/1221376/tableau-connector-for-jira?hosting=server&tab=overview 

It supports a wide range of Jira data configuration to export any field you wish: Jira tables and fields, including Custom fields, History, Jira Service Desk, Tempo Timesheets, Tempo Planner, Portfolio for Jira, Agile, and others.

Here you can find a detailed installation guide https://www.alphaservesp.com/blog/tableau-connector-for-jira-installation-guide/ 

I'd be happy to answer any questions you may have)

[Michael Q]

You can also use the JIRA DB (if on premise) as a data source in Tableau.

https://developer.atlassian.com/server/jira/platform/database-schema/

[vivek srivastava]

Hi Micheal, 

what is the way to connect JIRA DB with tableau. 

Can we really do it some way. please share some approach!

Note: I am not so much into API stuff

[Pablo Beltran _Marketplace Expert_]

The problem of direct access to Jira DB is that it breaks Jira permissions and no support for JQL.

If those things are important for you then SQL+JQL Driver might be an alternative to connect Jira with Tableau via standard JDBC or web data sources and run SQL compatible with JQL remotely.

Disclaimer: I work at the company selling the app.

[Madison Quinn]

Hello,

Analyze all of your JIRA data in Tableau, Connect your JIRA Cloud to Tableau.

Web data connector for Tableau lets you import JIRA data into Tableau for report creation.

Supports Agile, Custom Fields and Time Reporting

Supports Agile reporting including Sprints & Epics, Time reporting using worklog data and Custom Fields reporting.

Thanks.

[Matt Fishel]

Do you know if this also supports Jira Labels? 

[JulienFritsch]

Yes

[Navarambh Software - Gmail]

The add-on is available for all three versions of Jira - Cloud, Server, Data Center.

https://marketplace.atlassian.com/apps/1214641/aio-tableau-connector-for-jira

Please feel free to AIO support at support@aioreports.com in case of any issues.

Regards

AIO Support

[Nihar Das]

Dear AIO Team,

Could you please help me to get the AIO Connector? We have JIRA in the Cloud. Could you please help to connect with Tableau Desktop?

I have tried with the above link. I am not able to get this page.

It will be really helpful if you explain the steps with some Screenshots.

Thanks in advance.

[Navarambh Software - Gmail]

Thank you for contacting us. Please email us at support@aioreports.com and we will be happy to work with you get the . connector setup.