Connecting to Jira Align Enterprise Insights with SQL Authentication

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

Screen Shot 2022-04-21 at 3.24.00 PM.png

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)

Screen Shot 2022-04-22 at 10.54.26 AM.png

3. Click on Advanced...

Screen Shot 2022-04-27 at 10.31.18 AM.png

4. Set Encrypt = True to enable SSL encryption

Screen Shot 2022-04-27 at 10.26.26 AM.png

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

Screen Shot 2022-04-22 at 10.59.38 AM.png

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

Screen Shot 2022-04-22 at 11.01.04 AM.png

3. Click on Options >>

Screen Shot 2022-04-22 at 11.03.45 AM.png

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

Screen Shot 2022-04-27 at 10.38.10 AM.png

5. Click on Connect

 

Power BI Desktop

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

Screen Shot 2022-04-25 at 11.52.51 AM.png

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)

Screen Shot 2022-04-25 at 11.57.34 AM.png

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

Screen Shot 2022-04-25 at 12.21.03 PM.png

4. Click on Connect

 

Tableau Desktop

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

Screen Shot 2022-04-25 at 12.25.02 PM.png

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

Screen Shot 2022-04-27 at 10.22.41 AM.png

3. Click on Sign In

DBeaver

1. Select Microsoft SQL Server

Screen Shot 2023-03-02 at 2.37.52 AM_2023-03-02T10_42_18.025Z.png

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)

Screenshot 2023-04-07 at 1.59.35 PM.png

3. Click on Finish

1 comment

Tarun Sapra
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 26, 2022

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

Like # people like this

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events