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
4,365,417
Community Members
 
Community Events
168
Community Groups

How to connect to Jira Align Enterprise Insights using Python

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 

1 comment

edwin vasquez Community Leader Jun 28, 2022

Great post! Thanks for sharing.

Comment

Log in or Sign up to comment
TAGS

Atlassian Community Events