Export all Jira artifacts to any database in real time. Tables are created for you, every change lands in them as it happens, and Tableau or Power BI reads them directly — no export script, no nightly job.
On the Atlassian Marketplace since 2 November 2021
vl_portfolio_items
| key | status | owner | row_updated |
|---|---|---|---|
| PROJ-410 | In progress | a.keller | 09:14:02 |
| PROJ-415 | In review | m.dorn | 09:15:37 |
| PROJ-418 | Done | s.arnold | 09:16:11 |
The app creates the table from your rule and keeps writing to it after every matching change.
A connection, a rule, a table. The whole setup, click by click.
Jira's own schema is not built for reporting. This app gives you tables that are, without anyone writing SQL or maintaining an export.
Every Jira issue change triggers an automatic update to your database tables. No batch jobs, no delays — your BI dashboards always reflect the latest data. Every row carries the Jira server it came from, so several instances can share one table.
Oracle, PostgreSQL and SQL Server, including Azure SQL. Several connections run in parallel, each routed where your BI stack needs it.
Select projects, work types and fields visually. The app works out the column types and creates the table on first activation.
Dependencies and blockers land in their own table, which is what makes traceability reporting possible at all.
Tables are shaped around your fields, not Jira's internals. Connect Tableau or Power BI without a translation layer in between.
A Jira administrator sets this up once per reporting need. There is nothing to deploy outside Jira.
Driver, JDBC URL, user and pool size, tested before it is saved. Credentials stay in your Jira instance.
Name it, pick the projects, move the work types and fields you want across, then point it at a connection and a schema.
The app checks whether the table exists, creates or extends it, and starts writing. Rules can be saved inactive and switched on later.
Adding a field adds a column. Changing the table or the schema is handled too. Existing items can be brought in with a bulk change.
Projects
Work types
Fields
Target
Five technical columns are added automatically, including the server id and the update timestamp.
Atlassian is retiring Data Center. Sales of new Data Center subscriptions and Marketplace apps ended for new customers in March 2026, and Data Center products reach end of life on 28 March 2029, when the licences and the app licences that go with them expire. The dates come from Atlassian, not from us.
This app ends with the platform it was built for. Until then it stays available and supported for existing customers, and it keeps working on current Jira releases.
Your reporting need does not end, it moves. We are building a Jira Cloud app that takes over this job, and we are happy to talk about it before you plan your migration.
The documentation covers installation, database connections, ETL rules and how changes reach your tables. For anything it does not answer, the support portal is open as usual.
Developed and supported by VIP.LEAN Solutions GmbH in Germany. The app sends no data to our servers.
