Connect to an external database using Scriptrunner for Jira Cloud

Marko Slijepčević_r0og9k

Hi,

I was wondering, is it possible to connect to an external database (Oracle to be specific) by using Scriptrunner for Jira Cloud? I didn't found anything in the official documentation so far.

The workflow should have a transition that will trigger the load to an external database, that's why my first thought is Script Runner, and a simple post-function that fetches the data and Updates the table should do it.

Or maybe another plugin can help - the goal is to update a table with data from Jira.

Kristian Walker _Adaptavist_

Hi Marko,

Thank you for your response.

I can confirm that currently it is not possible to connect to an external database with ScriptRunner for Jira Cloud as Atlassian does not provide any Rest API's to do this currently.

However, I can confirm we have a feature request board located here and would encourage you to raise a feature request for this if it is something that would be useful to your organisation so that our product owner can see this.

Finally, I can confirm that Scriptrunner for Jira Cloud can intergrate with external systems if the external system provides a rest API as mentioned in the KB article located here and this means if the database exposes a rest API then this could be used to interact with it.

I hope this information helps.

Regards,

Kristian