How to integrate an MS DB with jira

[Teeka Leone]

others have asked but there has been no good response.  I want to open a jira project ticket with data from my MS Access Database.

Can I do it?  How do I do it?

[Mikael Sandberg]

You would need an app in order to get external data to feed into a Jira field, like Elements Connect or External Data for Jira Fields. I would suggest that you search the Marketplace for external data and check out the apps.

[Craig Castle-Mead]

Hey @Teeka Leone 

I'd recommend keeping the MS Access Database and Jira logically separated by building a "helper" application/function that was able to access the MS Access Data using read only access, this would then use Jira REST APIs to pass the relevant data via payload to create the issues within Jira. 

While there are tools like Elements Connect/Adaptavist ScriptRunner that can add an arbitrary  database as a data source for Jira, this means your Access Database needs to be network accessible from the Jira application node (generally not ideal from a security POV) - and you'd then need to create some form of scripting to read from the Access DB and use rest/java/groovy to create the desired issues anyway.

CCM

[Teeka Leone]

My Access DB is network accessible as the tables are on an SQL Server as the backend.  I see no reason why a simple exposed API couldn't work if there was one from Jira