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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

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,456,819
Community Members
 
Community Events
176
Community Groups

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

1 comment

Tarun Sapra Atlassian Team Apr 26, 2022

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

Like Patrick Bindels likes this

Comment

Log in or Sign up to comment
TAGS

Atlassian Community Events