SmartQL - Power BI & Tableau & SQL

Name: SmartQL - Power BI & Tableau & SQL
Rating: 4 (3 reviews)

works with Jira Server 7.2.0 - 8.21.1 and more

OVERALL RATINGS
INSTALLS: 22

We no longer offer sales and support for server apps. You can stay connected by exploring the migration options to either the cloud or Data Center version of this app.

Explore migration program

Overview

Reviews

Key highlights of the appExplore Jira data using SQL with built-in IDE or connect Tableau, Power BI and other tools using OData & JDBC

Use SQL & JQL together with built-in SQL IDE

Discover Jira data with built-in SQL engine and IDE. Use SQL & JQL together. With full respect to Jira permission system.

Connect Tableau, Power BI, etc with OData support

Connect Tableau, Power BI or any other tools that supports OData protocol. Create custom SQL views in Smart QL and expose them through OData to your BI tools.

Connect even more tools with JDBC support

With our dedicated JDBC driver you can connect your SQL tools and explore Jira data. Again, with full respect to Jira permission system.

Supporting media

More details

Essential information and links:

User guide
How to connect Tableau, Power BI
How to connect using JDBC

This app creates virtual SQL database with row level support for Jira permissions (no data leaks among your users). On top of this database you have three ways to play with your Jira data:

Built-in IDE like SQL console. You can search data straight in Jira, create persisted views and share them to other users. You can even create gadgets like tables and charts and place them onto dashboards.
JDBC with a dedicated driver. You can connect Jasper Reports, Squirrel, HeidiSQL, DBeaver or many more.
OData API to be use with Tableau, Power BI and other BI tools.

Some built in functions are provided for handling JIRA specific data. You can even place JQL inside your SQL queries.

Resources

Download
Get the .jar file downloaded to your system
App documentation
Comprehensive set of documentation from the partner on how this app works
EULA
Get the End User License Agreement for this app

Privacy and Security

Privacy policy

Atlassian's privacy policy is not applicable to the use of this app. Please refer to the privacy policy provided by this app's partner.

Partner privacy policy

Security program

This app is not part of the Marketplace Bug Bounty program.

Version information

We no longer offer sales and support for server apps. You can still explore the earlier versions but these may not offer the necessary support.

Explore all server versions