with jaspersoft being a reporting tool i believe others have had a similar porblem.
I have data in mongodb and data in sql server. I need to join them together for reporting purposes only.
For example i have in my mongodb accountid and in my sqlserver database i have aid, Name, etc. Both accountid and aid are matching.
is there a way to get the data from both in one report.
I think it is a lost cause but you might have some interesting ideas.
Thanks for viewing.
Why don't you give a try to JasperSoft ETL which allows you to join various tables from diffrent sources and combine into one and then you can use the joined table to produce reports.
Hope that this helps