How to integrate MS access database with JIRA

Question

How to integrate MS access database with JIRA ?

Please help me

Troy Edmonds · Answer

Oops

Phill Fox · Answer

Hi Gayathri

I assume you want to pull other information in to your JIRA instance and are not thinking of using MS Access as your underpinning database.

Firstly I would suggest considering how many users are going to be pulling the information from your Access database as the performance hit may be a challenge for you in which case you should consider more powerful database systems.

However, if the number of accesses is suitably low then you could look at using https://marketplace.atlassian.com/plugins/com.keplerrominfo.jira.plugins.databasecf/server/overview and in particular the page on data source configuration https://confluence.kepler-rominfo.com/display/DBCF/Data+Source+Configuration

Note that this requires you to manipulate the configuration files of JIRA to add this access as well as installing the appropriate ODBC drivers. Make very careful notes of your changes so that when an upgrade of JIRA happens you can quickly check that your changes have persisted.

Hope this helps

Phill