Write to external DB

[Mohamed Saad Taha]

Dears,

I have JSM datacenter edition and I have script runner is this possible to write directly from jira form to external DB ? using script runner or any other tool or automation 

[Joseph Chung Yin]

@Mohamed Saad Taha -

Please provide more information on your ask -

1) What is the process for?

2) What is the external DB system?

It seems it is a custom development using custom scripting and Atlassian REST APIs to pull the data in JSM and send out JSON payload for downstream processing against your external DB.

https://docs.atlassian.com/jira-servicedesk/REST/4.15.0/

Otherwise, you will need to search in Atlassian Marketplace for possible third party add-ons for external integration.

Hope this helps.  Sorry.

Best, Joseph Chung Yin

[Mohamed Saad Taha]

Dear @Joseph Chung Yin 

thansk a lot for your reply and interest 

1- creating recorded in database tables after certain workflow steps

2- Database is oracle database 

[Timothy Madsen]

@Mohamed Saad Taha 

Did you obtain a solution for this?  I have a similar task to do and would be very interested in what you were able to discover?

Alternatively:
@Joseph Chung Yin 
Do you have any additional information that we may find helpful?

After a certain workflow step, we need to make an external callout.
One approach would be to call into an Oracle Database and execute a small block of code to pass data from the workflow page.

Alternately, we could call out to a Python script.

What are the options to make a call out from a page based on a particular step in the workflow to be able to send data from the workflow to an external interface?

[Joseph Chung Yin]

@Timothy Madsen -

Welcome to the Community.  You can setup automation rules for your project based on transition issue event as a trigger.  In your rule, then you can do a WEB REQUEST action to your targeted receiving application.  The action will send out the JSON Payload of the issue.

Hope this makes sense.

Best, Joseph Chung Yin

[Timothy Madsen]

@Joseph Chung Yin 

That is very helpful.

It would be much easier if I was able to do a SQL action.  Is that possible or is the only external call-out the WEB REQUEST action?

Thanks.

[Joseph Chung Yin]

@Timothy Madsen -

Unfortunately, you cannot use direct SQL action. 

Sorry.  If my suggestion helped you, please click on Accept answer when you have a chance.

Best, Joseph

[Timothy Madsen]

@Joseph Chung Yin 

I appreciate the info.  Still trying to find if there is any way.  lol

Are you aware if there are plug-ins that would allow this?  I do see people speaking of plug-ins but I am unclear if those are old and outdated or if they are current and what sort of support there could be?

Are you either familiar or able to point me in a direction that I could learn more regarding SQL plug-ins that would allow a SQL callout from a workflow?

Thanks