Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How to connect to Jira Align Enterprise Insights using Python


How to connect to Enterprise Insights using Python


Tested in:

  • Jira Align Enterprise Insights Version(s): 10.108
  • Python v3.10


You will need:

  • A SQL user for Enterprise Insights

  • Python v3.10 (newer versions have not yet been tested. Feel free to test and update here!)

  • Python module pyodbc
    Install the package of "pyodbc" which is ODBC Driver 17 for SQL Server as per this link:

Configure pyodbc Python environment - Python driver for SQL Server

import pyodbc 

stringConnection = pyodbc.connect("Driver={ODBC Driver 17 for SQL Server};"

cursor = stringConnection.cursor()
cursor.execute('SELECT * FROM current_dw.Dependency where [Dependency ID] < 20')

for i in cursor:

Related Content:

Use Python to query a database - Azure SQL Database & SQL Managed Instance

Connect and query - Azure SQL Database & SQL Managed Instance


With thanks to my co-author and tester @Luiz Felipe Arruda 

1 comment

edwin vasquez Community Leader Jun 28, 2022

Great post! Thanks for sharing.


Log in or Sign up to comment

Atlassian Community Events