integration between JIRA Service Management cloud and MS SQL DB server

Question

Hi,

I would like to make an integration between  JIRA Service management cloud version 8.16.1 and MS SQL DB server to push data like issues and projects from JIRA to be saved in my DB for analytics purposes. Is there any automation application that I can use (in Europe only due to GDPR regulations) .. otherwise, did any one did this with REST API and how I can do it??

Thanks

Daniel Ebers · Answer

Hi @Roua Yousif Farah Abdalla

this is what we used Webhooks for in the past:

https://support.atlassian.com/jira-cloud-administration/docs/manage-webhooks/

Webhooks are user-defined HTTP POST callbacks. They provide a lightweight mechanism for letting remote applications receive push notifications from Jira, without requiring polling. For example, you may want any changes in Jira bugs to be pushed to a test management system, so that they can be retested.

However, that means as soon as your data changes in an issue they are sent to a remote endpoint. This (whatever kind of) needs to react on the API call coming from Jira. I am not aware of any solution so that the data could be directly stored into a MS SQL database.

Like Ravi said there is also the possiblility of using the other way around - to query the REST API to get the data out of Jira.

From what I believe no matter how you want to do it - some kind of scripting will be involved.

Regards,
Daniel

Roua Yousif Farah Abdalla · Answer

Hi Ravi,

Thanks for answering me, that was very helpful. I'm using JSM on cloud and my end goal is to push the data from JIRA to DB for reporting. Actually I was looking for a third party solution to avoid scripting using REST API, but if there are some pre-made solutions, it would be appreciated if you could let me know about them.

Thanks a lot,

Roua

Ravi Sagar _Sparxsys_ · Answer

Hi @Roua Yousif Farah Abdalla

Are you talking about JSM on Server/DC or Cloud?

* For Server/DC you can do that using ScriptRunner for Jira which can read data from Jira using Java API, REST API or directly from database (not recommended but possible).
* For Cloud you can use REST API. You will have to do that on your own infrastructure, you can write script in your favourite programming language and schedule it to run let us say using cron to periodically do this.

Since we are talking about REST API you have lot of possibilities to fetch data from Jira using variety of tools. What exactly is your end goal? Reporting or some integrations, asking because there might be ready made solution for that.

I hope it helps.

Ravi