How to access JIRA Database to retrieve data

[Shridhar Samala]

We have JIRA Ondemand, I would like to access JIRA Database for one of the internal project. How can I access JIRA DB? Is there API where i need to access JIRA DB.

[Shridhar Samala · Accepted solution]

We can retrieve the OnDemand JIRA database for these API need to be installed: JIRA JSON-RPC APIs, Confluence JSON-RPC APIs in your JIRA and by using tempo license details you can access & retrieve the data.

Best link to study:
1. https://bitbucket.org/cmiller_atlassian/confluence-json-rpc-plugin/wiki/Home
2. https://docs.atlassian.com/jira/REST/latest/#d2e2494
3. https://confluence.atlassian.com/display/CONF53/Prototype+REST+API
4. https://developer.atlassian.com/display/JIRADEV/JIRA+REST+API+Version+2+Tutorial
5. https://developer.atlassian.com/display/CONFDEV/Confluence+JSON-RPC+APIs
6. https://ecosystem.atlassian.net/wiki/display/JRJC/Download
7. https://developer.atlassian.com/display/JIRADEV/JIRA+REST+APIs
8. https://developer.atlassian.com/display/JIRADEV/Concepts#Concepts-JIRAPluginModuleTypes

with the help of above information provided in links, we can try to reteive the data from OnDemand Instance.

Regards,
Shridhar

[RambanamP]

you can't access ondemand data base, check this

https://confluence.atlassian.com/display/AOD/Restricted+Functions+in+Atlassian+OnDemand

same question here

https://answers.atlassian.com/questions/39171/does-hosted-jira-ondemand-provide-read-only-access-to-the-jira-db-so-that-i-can-run-sql-statements-for-reporting-purposes

https://answers.atlassian.com/questions/212683/how-to-connect-to-jira-ondemand-database-from-a-external-application

https://answers.atlassian.com/questions/153125/sql-access-for-ondemand

[Shridhar Samala]

Thanks for sharing the answer, can any one tell me what is the way... I have gone through the links provided by you guys, saying that with the use of REST API we can do... by can any one give the steps how to do please, since i need on high priority.

It would be highly appreciated for your concern HELP.

[RambanamP]

the latest REST Api's can be find here

https://docs.atlassian.com/jira/REST/latest/

and tutorial

https://developer.atlassian.com/display/JIRADEV/JIRA+REST+API+Version+2+Tutorial

[Nadir MEZIANI]

Hi,

JIRA exposes the OfBizDelegator to dealing with its database.

http://docs.atlassian.com/jira/latest/com/atlassian/jira/ofbiz/OfBizDelegator.html