SQL Access for OnDemand

[Tom McKenzie2]

There are a bunch of SQL queries here https://confluence.atlassian.com/display/JIRACOM/Example+SQL+queries+for+JIRA we would like to run. Is the available for OnDemand or do we need to use the API?

[Nic Brough -Adaptavist- · Accepted solution]

OnDemand does not allow you access to the database. You'll need to use REST to get the information.

[Tom McKenzie2]

See 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