For building reports using 3rd partry reporting software, can the reports hit the database directly with SQL queries ?
We have nuxeo using oracle as the database. Now we are planning to build reports using Jaspersoft reporting software. Can we build the Jaspersoft reports directly accessing the relational database by coming up with SQL queries ? Or is there a recommended approach for developing reports against nuxeo repository ?
The Birt addon also uses the direct access to the database. It seems that it is the recommended way.