Frequently asked questions

Enterprise Insights enables you to connect your data in Jira Align to other data sources and browse your Jira Align data using your own visualization solutions, such as Tableau or Power BI. You can learn more in our Jira Align Enterprise Insights overview video.

Get in touch with your Atlassian Enterprise Advocate to arrange for a demo of Enterprise Insights.

Yes, you can create your own reports and dashboards using your existing data visualization tools like Atlassian Analytics, Tableau, or Power BI.

For a quick-time-to-start, we recommend using Atlassian Analytics. Atlassian Analytics is available for free with your cloud Enterprise edition of Jira Software, Jira Service Management, or Confluence.

No, data in Enterprise Insights is read-only.

A good understanding of SQL databases and how to join tables in a SQL query is required for Enterprise Insights. You must also have knowledge on how to build reports and dashboards in a data visualization tool like Tableau or Power BI and how to connect it to a SQL data source.

Enterprise Insights follows the Atlassian SLA of 99.95% for cloud products.

Enterprise Insights is hosted on Microsoft Azure.

Azure SQL database is a PaaS offering on the Azure cloud. There is no versioning for Azure SQL database. For more information on Azure SQL database, see Azure SQL documentation.

Data in Enterprise Insights is refreshed hourly.

Our Jira Align Knowledge Base has a page with our data schema document. You will need to create a login for the Jira Align Knowledge Base to access the schema document.

Yes, Enterprise Insights has a schema, export_dw, specifically designed for exporting data to a data lake or warehouse. This schema can easily be queried by an extract transform load (ETL) application or data pipeline using a Microsoft SQL Server data source connection (ODBC) or JDBC connection. If you are unable to connect to Enterprise Insights using the standard connection methods, we offer Enterprise Insights Data File Retrieval which exports your data in Apache Parquet formatted files. Learn more on the Jira Align knowledge base.

The data schema document on the Jira Align Knowledge Base has information on the tables, columns, data types, and primary/foreign key mappings. You will need to create a login for the Jira Align Knowledge Base to access the schema document. All data in Jira Align is eligible to be exported to Enterprise Insights.

You can subscribe to the Enterprise Insights release notes to keep track of new capabilities and changes.

Yes, custom fields for work items in Jira Align are available in Enterprise Insights.

Yes, historical data in Jira Align is available in Enterprise Insights. 

No, Enterprise Insights is read-only. You do not have the ability to administer your own instance.

No, Enterprise Insights does not support data cubes. You will need to export your Enterprise Insights data into your own data source and build your own cubes.

You will need your corporate network IP address range to be allowlisted on your Enterprise Insights instance by Atlassian. Please get in touch with your Technical Account Manager (TAM) or Enterprise Advocate (EA) for assistance.

There are two authentication options available: Azure Active Directory (AD) authentication and SQL login (username and password provided by Atlassian).

Azure AD authentication is recommended due to it being more secure. If you are using Azure AD, your Azure AD tenant must be enabled for guest authentication tenant access to allow authentication with Enterprise Insights. You can learn more on Microsoft’s website here.

No, Enterprise Insights does not support SSO or 2FA. However, Enterprise Insights does support Azure Active Directory (AD) authentication, which supports SSO and 2FA. You can learn more about Azure Active Directory single sign-on here.

Yes, you can connect to Enterprise Insights via standard ODBC SQL client over TCP 1433. We recommend connecting using Azure Active Directory (AD) authentication as it’s more secure.

No, APIs are not available for Enterprise Insights.

All Azure Databases are firewalled to only allow connections with TLS 1.2 encryption. For our ETL processes, we also restrict the CIPHER used on the client side to an Atlassian approved list.

Data is encrypted at rest by default using Azure’s transparent data encryption (TDE). Azure’s TDE uses the AES-256 encryption algorithm. Documentation on Azure’s TDE encryption is available on Microsoft’s documentation site.

Enterprise Insights is an Azure SQL Server database that enforces SSL/TLS 1.2 encryption at all times, for all connections. Microsoft recommends that, in your Microsoft SQL compatible client, you specify an encrypted connection and do not trust the server certificate.

Open a ticket with our Jira Align support team and they will assist you with your request.

No, this is currently not available. To make changes to your firewall rules, open a ticket with our Jira Align support team and they will assist you with your request.

Yes. Jira Align virtual private cloud (VPC) customers who have upgraded their Enterprise Insights to a dedicated private resource group in Azure have one of two options available to them. If they have an Azure presence, they can choose to use Azure private links to connect to their data. Otherwise, they can choose to use a route-based virtual private network (VPN).

For data residency information, please check out the Jira Align SOC2 document, which can be downloaded from our Trust center.

Enterprise Insights is hosted on a multi-tenant environment. For Jira Align VPC customers, we offer dedicated private resource group in Azure that can also be set up at an extra cost.

Yes, although Azure does not have the same concept of VPCs. We are able to isolate your Enterprise Insights instance by deploying it into a private resource group where all of their components are unique to that resource. The only thing that is shared is Active Directory which is at the tenant level.

No, Enterprise Insights does not support BYOK or customer-managed keys.

No, Azure SQL server does not support client certificate authentication where the server requires the client to present a certificate.

No, Enterprise Insights is an Azure SQL database that is a non-web based service.

Yes, Azure SQL (which hosts the Enterprise Insights database) has built-in DDoS protection. For more information, check out Microsoft’s DDoS protection response guide.

Yes, we perform Pentests on Enterprise Insights annually.

Enterprise Insights follows the same data retention policies as Jira Align. You can view our policies on the Jira Align knowledge base here.

Enterprise Insights follows the same disaster recovery policy as Jira Align. You can view our policies on the Jira Align knowledge base here.

For licensed customers, each environment will have its own Enterprise Insights data mart.