Data Mash-Up
Data mash-up makes it possible for multiple separated application systems in your enterprise to provide data in decision making. For example, you can connect a MySQL database, a SOAP Web Service data source, or a MongoDB data source, and use data from all of the database connections in a single query or business view, which is essential for creating reports in Report. You can also create joins between the different data resources, which are known as distributed joins.
Report provides the Add Table/View/Query dialog box, 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 Mash-Up in Queries
You can mash up data resources from different connections in a query before or after the query is created.
For more information, see Predefining Queries in a Catalog in the Report Designer Guide.
Back to topData Mash-Up in Business Views
You can mash up data resources from different connections in a business view before or after the business view is created.
For more information, see Creating a Business View in the Report Designer Guide.
Data Mash-Up in Catalog Pre-joins
You can mash up data resources from different connections when creating pre-joins in a catalog.
For more information, see Creating Pre-joins in the Report Designer Guide.