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,368,757
Community Members
 
Community Events
168
Community Groups

Connecting to Jira Align Enterprise Insights with Azure Active Directory Authentication

In my last article, Connecting to Jira Align Enterprise Insights with SQL Authentication, I walked through connecting to Enterprise Insights with SQL login authentication. If you use Azure Active Directory for authentication, Enterprise Insights can be set up to authenticate with your Azure Active Directory.

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

Before attempting to connect to Enterprise Insights with Azure Active Directory 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 instance has been set up to authenticate with Azure Active Directory by Atlassian
  3. Your Enterprise Insights server address 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-08-08 at 12.55.42 PM.png

 

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

  • Connection type = Microsoft SQL Server
  • Parameters = Select radio button
  • Server = Enterprise Insights instance address (Provided by Atlassian)
  • Authentication type = Azure Active Directory - Universal with MFA support

Screen Shot 2022-08-08 at 1.02.15 PM.png

3. In the Account field, select Add an account…

Screen Shot 2022-08-08 at 1.05.50 PM.png

4. A browser tab opens to sign in or select you Azure AD account to log into. Log into your Azure AD account. Screens may vary depending on your single sign-on (SSO)/multi-factor authentication (MFA) provider.

Microsoft Account Login.png

5. After logging in successfully, a confirmation page that your account was add to Azure Data Studio displays.

Screen Shot 2022-08-02 at 1.47.31 PM.png

6. Enter your Enterprise Insights database name (provided by Atlassian) in the Database field

Screen Shot 2022-08-08 at 11.04.47 AM.png

7. Click on Advanced...

Screen Shot 2022-08-08 at 1.23.47 PM.png

8. Set Encrypt = True to enable SSL encryption. Then click OK to return to Connection Details

Screen Shot 2022-08-08 at 1.20.34 PM.png

9. On Connection Details, click Connect

Screen Shot 2022-08-08 at 1.24.11 PM.png

 

SQL Server Management Studio

1. Click on File > Connect Object Explorer

SQL Server Management Studio Object Explorer.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 = Azure Active Directory with Universal MFA
  • Username = User name for your Azure Active Directory

SQL Server Mgmt Studio Connection.png

3. Click on Options >>

Screen Shot 2022-08-08 at 10.49.06 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. Then select Encrypt connection checkbox

Connection Properties.png

5.Click on Connect. You will be redirected to your SSO/MFA provider to enter your login credentials.

 

Power BI Desktop

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

Home Ribbon.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)

SQL Server Database Window.png

3. Click OK

4. Click on Microsoft Account on the left side of the window. Then click on Sign in.

Sign In.png

5. In the Sign in pop up window, enter your Azure Active Directory user name in the Sign in field and click Next. You are redirected to your SSO/MFA provider to complete the login process. Screens vary by SSO/MFA provider.

Screen Shot 2022-08-08 at 11.26.41 AM.png

6.After successful authentication of your account, you are returned to the SQL Server Database window which displays that your are currently signed in with your Microsoft account. Click on the Connect button.

Screen Shot 2022-08-08 at 11.34.24 AM.png

0 comments

Comment

Log in or Sign up to comment
TAGS

Atlassian Community Events