JIRA Align database schema

[Aman]

Hello,

I am looking to see if there is a database schema available for Jira Align. Also, are there any SQL queries readily available for reporting use?

[Sam Tsubota]

If you are on Jira Align cloud, you don't have access to the database. If you are referring to Jira Align Enterprise Insights, the data schema document is available on the Jira Align knowledge base under Enterprise Intelligence. You will need to create a login through Sign In to access previous version of the document. 

[Abhishek Jayaraj]

Hi Sam, Can you please share the ER diagram for  Jira Align Enterprise Insights

[Sam Tsubota]

An ER diagram for Enterprise Insights is not available. The data schema document on the Jira Align Knowledge Base has a tab of the foreign key mappings.

[Allan Maxwell]

Some level of reporting could also be achieved through the creative use of the Jira Align API ...Getting started with the REST API 2.0