Is it possible to use MYSQL DB and mongodb in a single Jasper report??

0

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

 

 

 

ravikakani's picture
Joined: Jun 23 2014 - 11:09pm
Last seen: 2 years 11 months ago

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

ravikakani - 3 years 2 months ago

6 Answers:

0

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

kkriplani's picture
858
Joined: Sep 4 2015 - 2:18am
Last seen: 2 weeks 6 days ago
0

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

 

ravikakani's picture
Joined: Jun 23 2014 - 11:09pm
Last seen: 2 years 11 months ago
0

 

Hi,
Refer the screenshot for creating a Mongodb datasource.

Regards,
KKriplani

kkriplani's picture
858
Joined: Sep 4 2015 - 2:18am
Last seen: 2 weeks 6 days ago
0

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

 

ravikakani's picture
Joined: Jun 23 2014 - 11:09pm
Last seen: 2 years 11 months ago
0

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 a
connector that allows reports to use MongoDB as a data source. Reports based on a MongoDB data source can be used as
Topics that allow users to create Ad Hoc views based on the fields returned by the MongoDB query. However, Domains
require relational data sources, and therefore MongoDB data sources cannot be used in Domains.

Regards,
KKriplani

kkriplani's picture
858
Joined: Sep 4 2015 - 2:18am
Last seen: 2 weeks 6 days ago
0

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

ict-programmer's picture
Joined: May 19 2014 - 5:26pm
Last seen: 1 year 5 months ago
Feedback
randomness