Connecting to Jira Align Enterprise Insights with SQL Authentication

[#1]

Enterprise Insights is a SQL data warehouse for Jira Align that enables you to query your Jira Align data using database tools like SQL Server Management Studio and Azure Data Studio or develop custom reports and dashboards with your own data visualization tools such as Tableau Desktop Download or Power BI Desktop Download .

This article provides an walk thru on how to connect to Enterprise Insights with a SQL login with Azure Data Studio, SQL Server Management Studio, Tableau and Power BI.

Note: The article doesn't cover how to connect to Enterprise Insights with Azure Active Directory authentication.

Before attempting to connect to Enterprise Insights you will need the following:

1. Confirmation by Atlassian that your network IP addresses have been whitelisted for accessing your Enterprise Insights instance
2. Your Enterprise Insights server address, login credentials (username and password) and database name provided by Atlassian

Please contact your Atlassian TAM for Onboarding Success or the Jira Align Support team if you need assistance with this.

Azure Data Studio

1. On the Azure Data Studio Welcome screen click on Create a connection

2. On the Connection Details window, select or enter the below values in the following fields:

• Connection type = Microsoft SQL Server
• Server = Enterprise Insights instance address (Provided by Atlassian)
• Authentication type = SQL Login
• User name = User name for your Enterprise Insights instance (Provided by Atlassian)
• Password = Password associated with user name (Provided by Atlassian)
• Remember password = Select the checkbox
• Database = Enter the name of your Enterprise Insights database (Provided by Atlassian)

3. Click on Advanced...

4. Set Encrypt = True to enable SSL encryption

5. Click OK to return to Connection Details

3. On Connection Details, click Connect

SQL Server Management Studio

1. Click on File > Connect Object Explorer

2. On the Connect to Server window, select or enter the below values in the following fields:

• Server type = Database Engine
• Server name = Enterprise Insights instance address (Provided by Atlassian)
• Authentication = SQL Server Authentication
• Login = User name for your Enterprise Insights instance (Provided by Atlassian)
• Password = Password associated with user name (Provided by Atlassian)
• Remember password = Select the checkbox

3. Click on Options >>

4. On the Connection Properties tab, enter the name of your Enterprise Insights database (Provided by Atlassian) in the Connect to database field.

5. Select Encrypt connection checkbox

5. Click on Connect

Power BI Desktop

1. On the Power BI Home ribbon, click on SQL Server.

2. On the SQL Server database window, enter the below values in the following fields:

• Server = Enterprise Insights instance address (Provided by Atlassian)
• Database (optional) = Enter the name of your Enterprise Insights database (Provided by Atlassian)

2. Click OK

3. Click on Database on the left side of the window, enter the values in the following fields: 

• User name = User name for your Enterprise Insights instance (Provided by Atlassian)
• Password = Password associated with user name (Provided by Atlassian)
• Select which level to apply these settings to = Enterprise Insights instance address appears by default

4. Click on Connect

Tableau Desktop

1. Click on the Connect menu, click on Microsoft SQL Server

2. On Connection Details, select or enter the below values in the following fields:

• Server = Enterprise Insights instance address (Provided by Atlassian)
• Database = Enter the name of your Enterprise Insights database (Provided by Atlassian)
• Authentication = Use a specific username and password
• Username = User name for your Enterprise Insights instance (Provided by Atlassian)
• Password = Password associated with user name (Provided by Atlassian)
• Require SSL = Select checkbox

3. Click on Sign In

DBeaver

1. Select Microsoft SQL Server

2. On SQL Server Connection Settings, select or enter the below values in the following fields:

• Host = Enterprise Insights instance address (Provided by Atlassian)
• Database/Schema = Enter the name of your Enterprise Insights database (Provided by Atlassian)
• Authentication = SQL Server Authentication
• Username = User name for your Enterprise Insights instance (Provided by Atlassian)
• Password = Password associated with user name (Provided by Atlassian)

3. Click on Finish

[Tarun Sapra]

This is a really helpful writeup @Sam Tsubota , thanks so much for sharing!