Need to integrate JIRA on Cloud with BIRT BI tool.

Hi All,

 

We need to integrate our JIRA on Cloud system with BIRT BI tool. I have tried to do so by using different options available at BIRT's end but have not been successful. Is there anything available with JIRA/Altassian that can help in this case.

 

Thanks in advance

 

Regards

Aman

3 answers

1 vote

Whatever reporting tool you want to use, it will have to read JIRA's data over REST.  You won't get access to the database or other ways to access your data.

Nic

Thanks for the response. I have tried with some open source BI like BIRT but have been unsuccessful. Using REST have not been able to get the data in the format required. I believe it should be handled at BI tool end only. Will try their. Thanks a lot.

 

Aman,

 

Birt supports REST for reporting as well as whatever data that you can read with Java. It requires some scripting of course, but it is pretty easy: Briefly, you have to create a Scripted Data Source and then fetch the JIRA data in JSON format via the Atlassian's REST Java Client or the Kinto Soft's REST Driver and create a Data Set for those JIRA data,. From this stage, there are not any difference to make BIrt reports by using REST or SQL.

If you want to read further details about how use JIRA REST services to create Birt reports, read please the documentation of the Birt Reports for JIRA add-on. It shows step by step how to achieve it from the scratch.

 

Hope this helps,

Pablo.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Tuesday in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

351 views 1 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you