Hi everyone! I’m trying to figure out how to make reports with SSRS using data from JIRA. I’m pretty new to JIRA and don’t know much about REST APIs.
I know I can’t connect straight to JIRA’s database, so I’m wondering if there’s a way to extract the information I need by another method. If it’s not feasible to use SSRS directly with JIRA, I’m open to transferring the data to a SQL database using SSIS.
Has anyone managed something similar? What would be the most effective approach? I would really appreciate any guidance or tips on how to proceed. Thanks a lot for your help!
I’ve been in your shoes, Samuel87. Getting JIRA data into SSRS can be tricky, but it’s doable. Here’s what worked for me:
I used JIRA’s REST API to extract the data, then set up an SSIS package to pull it into a SQL database. This gave me a local copy of the JIRA data that SSRS could easily work with.
The process wasn’t straightforward at first. I had to learn about authentication tokens and how to structure API calls. But once I got it working, it was smooth sailing. I scheduled the SSIS package to run nightly, keeping my report data fresh.
One tip: start small. Pick a specific JIRA project or issue type to focus on. It’ll help you get the hang of the API without getting overwhelmed.
Don’t be discouraged if it takes some trial and error. The end result is worth it – you’ll have powerful, customizable reports that leverage your JIRA data.
hi samuel, tried it before. use jira rest api, then ssis to move data into sql. its a bit tricky at first with auth and tests, but work if u get it right… good luck!
Having worked extensively with JIRA and SSRS, I can attest that using SSIS as an intermediary is a sound strategy. In my experience, leveraging JIRA’s REST API for data extraction and then feeding this data into a SQL database provides a robust foundation for SSRS reporting. It is crucial to carefully plan your SQL schema; mirroring JIRA’s structure while incorporating necessary denormalization can enhance efficiency. Implementing incremental loads helps manage performance, especially in larger environments, and ensures that the reporting data remains current.