ravikakani Posted August 31, 2016 Share Posted August 31, 2016 Hi, I would like to use MY sql DB and mongoDB connections in a single report. I tried using subreport option. I have created main report using MYSQL connection and trying to create a subreport for mongoDB. However, I am unable to create report connection expression for mongodb. Please tell me if it is possible to create a report using MY sql DB and mongoDB connections. If yes, can you help me out with report connection expression for mongodb subreport??Thanks Link to comment Share on other sites More sharing options...
kkriplani Posted August 31, 2016 Share Posted August 31, 2016 Hi,I guess it is not possible to use MYSQL DB and mongo db to be used individually in the same report.However, you can implement Data Virtualization to do so which would use the two different DBs as one.Regards,KKriplani Link to comment Share on other sites More sharing options...
ravikakani Posted August 31, 2016 Author Share Posted August 31, 2016 I have tried to create virtual datasource to combine MY SQL db and Mongo DB. However when Virtual datasource option is selected when creating data source, MongoDB is not showing in the list.Thanks Link to comment Share on other sites More sharing options...
ravikakani Posted August 31, 2016 Author Share Posted August 31, 2016 Is it possible to create virtual datasource using MY SQL and Mongo DB?, when virtual datasource is slected, created mongo DB is not displaying in repository Link to comment Share on other sites More sharing options...
kkriplani Posted August 31, 2016 Share Posted August 31, 2016 Hi,Refer the screenshot for creating a Mongodb datasource.Regards,KKriplani Link to comment Share on other sites More sharing options...
ravikakani Posted August 31, 2016 Author Share Posted August 31, 2016 Thank You. I am able to create Mongo datasource. Issue is after done with creation of Mongo datasource when I try to create virtual datasource by combining MY SQL and Mongo. Created MongoDatasource is not displaying in list.Thanks Link to comment Share on other sites More sharing options...
kkriplani Posted August 31, 2016 Share Posted August 31, 2016 Hi,I just came across the reason. Read below:MongoDB is a big data architecture based on the NoSQL model that is neither relational nor SQL-based. Jaspersoft provides aconnector that allows reports to use MongoDB as a data source. Reports based on a MongoDB data source can be used asTopics that allow users to create Ad Hoc views based on the fields returned by the MongoDB query. However, Domainsrequire relational data sources, and therefore MongoDB data sources cannot be used in Domains.Regards,KKriplani Link to comment Share on other sites More sharing options...
ict-programmer Posted September 4, 2016 Share Posted September 4, 2016 Depending on what you need to do with it, you can use scriptlets. From a scriptlet, you can pull together as many data sources as you wish. It is fairly simple to use them to get single pieces of information from multiple sources, but you can also create List objects in the scriptlet that you can use to populate a List element in Jasper. Scriptlets are a fairly broad topic, but this post should get you started:http://community.jaspersoft.com/blog/all-you-want-know-about-scriptlets 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