We have made some research and below is our current vision of a possible integration with BI tools.
CUBA platform will provide integration with at least two BI suites: Qlik Sense and Pentaho.
The integration will consist of the following:
- Access control lists (ACL) based on security constraints for entities imported to the BI tool. The ACL are created in the main database at scheduled intervals and are being imported together with data.
- UI for registering and running BI reports from a predefined screen.
- Visual components and API for embedding BI reports into arbitrary CUBA screens. These visual components can also subscribe to events from a BI report and invoke some actions in the application code in response to user actions.
We expect that this functionality will be implemented in the platform release 6.4 by the end of 2016.
Your comments and questions are welcome!