Connect to an external database using Scriptrunner for Jira Cloud

Marko Slijepčević April 15, 2021

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.

1 answer

1 accepted

1 vote
Answer accepted
Kristian Walker _Adaptavist_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 15, 2021

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

Marko Slijepčević April 19, 2021

Hello @Kristian Walker _Adaptavist_ ,

Thank you for your answer!

BR,
Marko

Kristian Walker _Adaptavist_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 26, 2021

Hi Marko,

I can confirm we have just made a change as documented in the release notes located here to include some SQL Librays inside of the plugin which will allow you to connect to external databases from SR Jira Cloud which may help you with achieving your requirement.

I hope this helps.

Regards,
Kristian

Like Zita Bagi likes this
Marko Slijepčević April 26, 2021

That's great @Kristian Walker _Adaptavist_ , thank you for informing me, I'll take a look into this!

BR,
Marko

Vikrant Yadav
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 2, 2024

@Kristian Walker _Adaptavist_  I have scriptrunner for Jira cloud, not able to see an option to Connect with External Data source. Links in above response are not working. Kindly suggest. Is this option available fo jira cloud ?

Kristian Walker _Adaptavist_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 8, 2024

Hi Vikrant,

We provide the libraies but you will neeed to write the logic to connect to databases in your script and we have examples of how to do this in the docs page located here.

Regards,

Kristian

Like Vikrant Yadav likes this
Vikrant Yadav
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 8, 2024

@Kristian Walker _Adaptavist_  Thanks for the link!

I am looking to create a field which get Data from Salesforce and show as options of a select list field. I am not able to find any option to create dynamic field in SR.

Kristian Walker _Adaptavist_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 8, 2024

In cloud there is no option to create this type of Scripted field currently. 

Like Vikrant Yadav likes this
Vikrant Yadav
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 8, 2024

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events