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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Wednesday in Jira

Join our webinar: How 1B+ feature flag events helped us build the new Jira

Every time you release software, there's a bit of risk – that there's a bug, that something breaks, or that the feature doesn't resonate with customers. Feature flagging helps make high stakes s...

140 views 0 3
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