Can JIRA be used to trigger API calls to Oracle procedures?

[Lina Abu-Baker]

Hi,

Our team is looking to automate an account creation process in Oracle. Right now, when a new account is requested, a ticket is created in JIRA and once its approved by our security team, the account is then created manually in Oracle. Is there a way to automate this process so that once the security team approves the ticket, the call is made to Oracle to create the account?

Thanks,

Lina

[said kouzibry · Accepted solution]

Hello Lina,

This would depend on the add-ons you have installed, but it is possible and pretty common,

Using Power Script, you have the ability to create a post-function script that would make an API call to Oracle sending the data you need for the creation of the account,

Similarly, you can use Script Runner for the same operation.

There also might be other add-ons that would allow to make API calls.

Here is the documentation for the Power Script method : https://confluence.cprime.io/display/SIL/httpPost 

[M Amine]

You can also use groovy with scriptrunner for Jira app. The only one condition is that you need REST API exposed by Oracle. Or (bad solution) you can connect directly to the database using either PowerScript or ScriptRunner and make your SQL request.