Fusing Data Sources
Data fusion is the concept of tying together two or more disparate data sources as a single data source for exploration and analysis. After the Zoomdata server joins together data from various data sources, you can visualize the combined results in charts and dashboards. Zoomdata supports data fusion between all data stores it supports.
|If you have reenabled the legacy query engine so you can use Data Sharpening, data fusion will no longer work because it requires zEngine. See Reenabling the Legacy Query Engine. To use data fusion, the legacy query engine must be disabled and zEngine must be enabled (set the
Fused data can generate more meaningful insights than what might be available in the data from a single data source. For example, suppose a data warehouse stores ticketing sales and events data in the following different data stores:
- Information about buyers and sellers stored in SAP IQ
- Events data stored in Elasticsearch
- Ticket sales stored in Cloudera Impala
You can fuse the data in these data stores together into a single Fusion data source. This combined data can be used for more in-depth and complete analysis and exploration.
The following diagram depicts the basic concept of Zoomdata data fusion.
Data fusion is available through Zoomdata’s familiar and intuitive user interface. Connections to data fusion data sources can be established using Zoomdata's standard connection interface. Step-by-step instructions are provided in Creating a Fusion Data Source.
Fused data sets are stored as a Fusion data source (). The Fusion data sources can be accessed and interacted with in the same manner as any other standard data source. You can visualize the fused data in standard or custom charts.
For more information, see the following sections:
- Data Fusion Limitations
- Data Fusion Processing
- Data Fusion Join Rules
- Filtering Fused Data
- Data Fusion Table Structures
- Data Fusion Use Cases
- Creating a Fusion Data Source
- Optimizing Joins
Was this topic helpful?