You may have a data source in a JReport catalog which connects to different databases, a MySQL database, a SOAP web service data source, a MongoDB data source, etc. and you want to use data from all of the database connections in your report or dashboard. This can be achieved by the Data Mashup feature. No matter how many database connections you have, as long as they are in the same catalog data source, you can mash up multiple data resources from these connections into one single query or business view, which is essential for creating reports in JReport. You can also create joins between the mashed up data resources that are known as distributed joins.
JReport provides the Add Table/View/Query dialog, with which you can easily mash up multiple data resources from different connections. The data resources include tables, views, synonyms, queries, imported SQL files, stored procedures, and user defined data sources.
- Data mashup in queries.
Data resources from different connections can be mashed up in a query before or after a query is created.
- Data mashup in business views.
Data resources from different connections can be mashed up in a business view before or after a business view is created.
- Data mashup in catalog pre-joins.
Data resources from different connections can be mashed up when creating pre-joins in a catalog.