cbarrientos Posted October 20, 2015 Share Posted October 20, 2015 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. Link to comment Share on other sites More sharing options...
Solution marianol Posted November 6, 2015 Solution Share Posted November 6, 2015 On Jaspersoft 6.1.1 we updated the mongoDB JDBC Drivers is that the version you are using? You can download a free trial form here: http://www.jaspersoft.com/four-ways-test-drive-jaspersoft-bi-software get the 30 day download.Remember that Jaspersoft has 2 Mongo Conectors a JDBC one that allows you to use Domains and use Mongo build relations between collections (looks like that is the one you need) and a Native connector that allows you to do native mongo queries. See all the info on both here: http://community.jaspersoft.com/documentation/tibco-jasperreports-server-administration-guide/v611/mongodb-data-sourcesIf you want to report on RESTful API's you should try our Community WebServices Datasource that allows you to report on JSON or XML Restful Web Services.Regarding Apache Drill, I have seen it use with jaspersoft a while back, I will check the error, from experience the "pool exausted" error normally comes with JDBC driver issues (i.e. driver not fully implements all the JDBC API), I remmeber running into that with old HIVE/Thrift drivers.Sometimes fixed by using a JNDI connection (pool managed by tomcat) than a JDBC one. Link to comment Share on other sites More sharing options...
ernestoo Posted April 12, 2016 Share Posted April 12, 2016 MapR has contriubted an article on the matter:http://community.jaspersoft.com/wiki/apache-drill-and-jaspersoft-studio Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now