Data Warehouse (2)

VIP.LEAN ETL for Reporting

The Jira App-In “VIP.LEAN ETL for Reporting” allows our customers to export all Jira artifacts to any database. The target database tables are automatically created and populated by the app. The table content is based on the business and technical needs of our customers and can be evaluated directly with other BI tools such as Tableau or Power BI. The potential of your Jira data is fully exploited with this app.

We offer the following features:

Jetzt Testen
Database Connections
The first step is to configure database connections:
  • Oracle is supported
  • Postgres is supported
  • Planned: MySQL
  • Any number of connections can be configured and used in parallel
TRY FOR FREE
Jetzt Testen
Data Warehouse Rules
With the data warehouse rules, the transfer of the functional Jira data to a database can be set up in a few minutes:
  • The administrator selects the projects, task types and fields to be exported to a database
  • The administrator then selects a previously configured database connection
  • Based on the selected fields, the app automatically creates the correct database table
  • The app transfers the corresponding fields to the database table after each relevant Jira change
TEST FOR FREE
Ganz Neu
More Features
We are continuously developing this app:
  • Exporting Jira links to defined database tables (2022.H1)
  • Workflow or time-based historiography (2022.H1)
  • Email messages planned for connection and database errors)
  • Atlassian Cloud Support (2022.H1)
TRY FOR FREE

YOUR NEED > CLICK FOR OUR SOLUTION

Real-time BI dashboards

The integration with technical tables or rest API is complex.

Functionally structured tables

With our app, technical tables can be created that represent a direct data source for BI tools.

Data from multiple Jira instances

With many Jira instances, it is time-consuming to see all the data at a glance.

Multi-instance ability

Our app can run on several Jira instances and use central shared tables. This gives the customer a consolidated view and can also evaluate it in BI tools (e.g. all stories across all Jira instances)

Control over your own data

There is a high evaluation potential in the Jira data. However, the data is technically difficult to collect.

Further processing of the reporting tables

Once the Jira data is stored in a technical/business table, any further processing can take place, such as histories or more complex calculations.

Mastering Projects Made Easy: Discover the Power of Our Jira Apps!

OUR JIRA APP's

Create and Link

From $0 / per month

Design your own button: Design, place, click – Easily create and link predefined issues from your workflow.

Jira Cloud

Try it Now

Issue Picker

From $0 / per month

Create custom fields as issue pickers, specified by JQL queries. End users benefit from automatic issue linking

Jira Cloud

Try it Now

ETL for Reporting

From $10 / per month

This app transfers Jira data in real-time as business entities into your database. This significantly simplifies report generation in Power BI/Tableau.

 

Jira Cloud / Data Center

Try it Now

ADVANCED LINKS

From $2.45 / per month

Create and navigate through your Jira tasks along semantic structures with issue pickers, issue panels and linked task creation.

Jira Cloud / Data Center

Try it Now

FLOATING LICENSES

From €300 / per year

Maximize your savings on licensing costs and effortlessly extend the benefits of Jira features to a larger number of users.

Jira Server / Data Center

Behaviours Builder (24Q2)

From $0 / per month

The Behaviours Builder allows administrators in Jira to configure field behavior based on defined conditions using a GUI, without any need for programming.

Jira Cloud