Hi there, I've been working on a BI solution for a project in my company, the project has its storage at a MongoDB database, so I've read a lot of jasperserver and it seems to have the tools that I need, but the data in the project has a lot of relations between collections in mongodb, so, when I try to do a report on Jasper, the amount of populates (Relations) I have to do in a mongo query is absurd, so, I've looking for other tools that help me get the data from the mongoDB easily, I also try to implement REST services from my project, but Jasperserver doesn't support JSON rest services, and, the last thing I have, is get the data using Apache Drill, but using the JDBC driver I got an "Cannot get a connection, pool exhausted" Exception, I checked the config and it seems to be ok, also I create queries to test Drill and it works fine. Am I missing something with jasperserver? Any help would be very appreciated. Thanks.
