Get started with Enterprise Insights

Enterprise Insights (EI) is a data mart that lets you connect your Jira Align cloud instance's data to existing data visualization products like PowerBI and Tableau, or export your data to your own internal data lake. This connection lets you use data visualization tools to slice and dice data beyond the reports built into Jira Align, so that you can create tailor-made dashboards and charts for executives, partners, and other important stakeholders. EI opens up the possibility to report on additional fields, attributes, and time periods.

On this page:

• Overview video
• How it works
• Connection options
• Who you'll need
• The set up process
• Additional resources

Overview video

Watch our An Introduction to Jira Align Enterprise Insights video below for an overview of the things you can do with EI:

How it works

Once Enterprise Insights is provisioned, your Jira Align data is hosted on a data mart, powered by Microsoft Azure SQL Server. EI data is optimized for read-only operations and served in a format that is easily consumable for building data visualizations and exporting to a data lake. Our support team will assist you with the initial set up and connection to your EI instance.

Authentication to your data visualization tools is handled through Microsoft Entra (formerly known as Azure AD) authentication. Microsoft Entra authentication allows your users to authenticate with the Azure presence on your network. 

Connection options

There are multiple ways to connect to Enterprise Insights, depending on your network requirements:

• Standard multi-tenant: For Jira Align cloud environments that connect with third-party business intelligence. Once provisioned, you can set up the connection in Jira Align.
• VPC cloud: For Jira Align cloud environments hosted in a virtual private cloud (VPC) offering. You can set up the connection in Jira Align using standard IP allowlisting, or work with support to connect with Azure private links.
  
• VPC with VPN: For Jira Align cloud environments hosted in a virtural private cloud (VPC) offering that want to connect through a VPN gateway hosted on Google Cloud or Amazon Web services.
  
• Data file retrieval: For Jira Align environments that prefer to download Parquet file format snapshots of data through Amazon Web Services.
• On-premise: For Jira Align self-hosted environments. You can set up this connection locally.
• Atlassian Analytics: For Jira Align cloud environments that would like to leverage dashboards and charts in Atlassian Analytics. This option can be used in combination with other connections to third-party BI tools.
  

Who you'll need

To successfully connect to and use Enterprise Insights, you’ll need to first locate the right people in your organization. Ensure you have team members available who can assist you with the following concepts:

• SQL databases and how to join tables within an SQL query
• Use of SQL code editors like Azure Data Studio and SQL Server Management Studio
• Building reports and dashboards in data visualization tools
• Authentication via Microsoft Entra
• Firewall management
• Management of your corporate networks and virtual private network (VPN)
• Allow listing and IP management
• Jira Align administration

For a smooth setup experience with EI, we recommend identifying three points of contact across your teams: A Jira Align admin, an admin for your data visualization or business intelligence tools, and a network specialist.

The set up process

Once you’ve found the right people in your org to handle the technical requirements, you’re ready to work with our sales team or Atlassian Partner to provision Enterprise Insights. Here’s an overview of the steps we’ll take together:

Note: These steps describe the standard connection option for EI. If you have the virtual private cloud (VPC) offering for Jira Align and EI, you can use the VPN connection option instead. This option is useful when you cannot use IP allowlisting for access, or are unable to open port 1433 to outbound traffic over the public internet.

1. Contact your Atlassian Solutions Engineer or partner reseller to provision Enterprise Insights.
2. You'll work with your network team to ensure you have the information needed to create firewall rules and user accounts. More about EI connectivity requirements.
3. You work with your network team to ensure that TCP port 1433 on your corporate network is open for outbound traffic. Preferably, this port is open to all addresses. If your network team does not allow this, port 1433 must be open to the Microsoft Azure region gateway IP addresses and subnet addresses your EI instance is hosted on. 
   Note: If your business intelligence tools are hosted on an Azure hosted server, you will need to open additional ports to use Azure's Redirect connection policy. 
4. Our support team sends you an update that Enterprise Insights has been provisioned. You'll be provided with the EI server name and Microsoft Azure region and gateway addresses that EI is hosted on. 
5. You or your Jira Align super admin accesses the Enterprise Insights settings page, where you can use the setup wizard to create your firewall rules and user accounts to manage access. 
6. You or your data admin / network specialist can now test the connection to EI from your corporate network. We recommend using an SQL code editor to test this connection while logged into your corporate network.
7. Once your connection test is successful, you’re ready to use your data visualization tools with Enterprise Insights!

Additional resources

See the following pages and videos to learn more about the benefits and use of Enterprise Insights:

• Connectivity requirements for Enterprise Insights 
• Enterprise Insights FAQ
• Video: Understanding the Jira Align Enterprise Insights Data Schema