Jmix integration options with BI Tools

Support
#1

Hi,
I would like to ask if there is any available open source Business Intelligence tool that could be easily integrated with a jmix application. We have recently got some requests to provide the option to the end users of a jmix app to build their own dashboards using the application data. Although we have done some research with third party products it seems that there are several difficulties especially in the field of authentication / authorization. I remember that in the past there was a Cuba add-on for Pentaho BI Tool but for the jmix it seems that there is no any related product. We have also tried to use the existing add-on for dashboards, but It seems to have several limitations regarding the available options for the end users to build their own charts.

Nevertheless, I think that data visualization options for the end users is something very important and I believe that jmix platform should be able to provide some alternatives in the future.

Regards,
George

#2

Hello,

I’m using Jasper for my reporting needs, as it’s primarily a report server. It has its own database connection and works fine.
A similar product is Apache Birt, used some time ago.
If I would need to process terabytes then I would use Apache Superset
There are many other products to choose from.

Regarding integration, there is a way to include the Jasper engine within an application (embedded).

Another way to integrate is SSO, so a user can open links within jmix app. There is jmix addon for that OpenID Connect
This requires some knowledge and work, as setting properly secured and configured Keycloak (or another) and connecting to it is not to be taken lightly.

Kind regards,
Mladen

1 Like
#3

Thank you Mladen,
I will check your recommended products to check how they could be integrated into our solution since what we need is to allow end-users create their own dashboards.

Regards,
George

#4

Hi,

You can try Metabase (https://www.metabase.com/) - it has a quite nice embed story. I only tried it with CUBA back then, but should only be better nowadays. You will get self service for end users, it directly sits on your DB next to the Jmix app.

Cheers
Mario

1 Like
#5

Hey,

Did you guys find any other solutions or maybe Jmix Team made other solutions?
@mbucan @mario @papageor

#6

Next release of Jmix 2 will have Apache Superset integration.
Seems its making good progress :slight_smile:

1 Like