You can connect multiple databases together in a single data source. For example, you can connect a MySQL database, a SOAP web service data source, a MongoDB data source, etc. and you use the data from all of the database connections in a single report. This can be achieved by using 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 mashup multiple data resources from these connections into one single query or business view, which is essential for creating reports in Logi JReport. You can also create joins between the different data resources; these are known as distributed joins.
Logi 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.
See Predefining Queries in a Catalog for additional information.
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.
See Creating a Business View for additional information.
Data Mashup in Catalog Pre-joins
Data resources from different connections can be mashed up when creating pre-joins in a catalog.
See Creating Pre-joins for additional information.