Jira Databawse Schema

Anya A'Hearn

Hello,

I would like to put a 3 party visualization tool ontop of the Jira Data, instead of using the dashboard widgets. Is it possibla to connect to the Jira Database and if so, could you provide instructions as well as schema documentation.

Thank you

Anya

Nic Brough -Adaptavist-

Urk, I wouldn't. But start at http://confluence.atlassian.com/display/JIRADEV/Database+Schema to get the basic parts of the schema understood.

The reason I wouldn't do it is that by using SQL directly, you're dropping caching and putting a potentially vast strain on the database. If your 3rd party tool does caching, good, although it'll struggle as it won't be updating it's cache fully in step with the database. Some sites I've worked at have ameliorated the load factor by working off replicated slave servers.