SQL Connector for Jira automatically builds relations between tables and fields, including Custom fields. This means that when you upload your Jira data into the SQL database, all tables will be connected in relations based on the logical key field. Thus, users don’t need to relate tables manually, which is really time-consuming.
| Info |
|---|
Review the entities and attributes to see if they include everything you want to export from the system. If not, manual adjustment is required. |
How to review the Entity Relationship Diagram?
Simply click on Data Relationships tab available on the data source creation page.
...
| Info |
|---|
The diagram of the exported data is available in its full form on the correspondent diagram. Below, you can find the individual data schema of each plug-in in the format of the Power BI data schemes. |
Jira Core
Issues Block
...
Permissions Block
...
Linked Tables Block
...
Jira Software
...
Jira Service Management
...
Tempo
...
Insight
...
Time to SLA
...
Worklog PRO
...
Xray
...
Tempo Budgets
...
R4J
...
Advanced Roadmaps
...
Zephyr Scale
...