Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 28, 2022

Great post! Thanks for sharing.


Log in or Sign up to comment
AUG Leaders

Atlassian Community Events