How to connect to Jira Align Enterprise Insights using Python

[#1]

Summary

How to connect to Enterprise Insights using Python

Environment

Tested in:

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

Solution

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};"
"Server=xxxx;"
"Database=xxxx;"
"UID=xxxxx;"
"PWD=xxxxxxx;"
"AuthenticationType=SQLPassword;"
"minimalTlsVersion=1.3;"
"Trusted-Connection=yes;")
​
​
cursor = stringConnection.cursor()
cursor.execute('SELECT * FROM current_dw.Dependency where [Dependency ID] < 20')
​
for i in cursor:
print(i)

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 

[edwin vasquez]

Great post! Thanks for sharing.