Creating a Fusion Data Source
To fuse data in Zoomdata, you must first connect to the data sources that you want to be joined. After successful connection, use the data source configuration wizard to join the disparate data sets as a new type of Fusion data source. Once the data sets have been joined together, you can explore and analyze the fused data set in charts and dashboards.
For an overview of Zoomdata’s data fusion capability, see Fusing Data Sources.
The key step in the process is to identify and specify the fields to be joined across the data sources used in the Fusion data source. This is performed on the Data Sources and Editor tabs, as described in this section.
Before You Start
Before you attempt to create a Fusion data source:
- Ensure the data sources you want to fuse are already connected and configured in Zoomdata. If not, create them See Managing Data Source Configurations.
- Verify that there are matching fields across the data sources you want to fuse.
- Identify the fields from each data source that will be used in the join definitions of the Fusion data source.
Configuring a Fusion Data Source
To create a Fusion data source, you will use the data source configuration wizard. However, a few of the tabs in the wizard are different for Fusion data sources than they are for other data sources.
To create a Fusion data source:
Make sure you are logged in as a Zoomdata administrator.
Select (Settings) and then select Sources. The Data Sources page appears.
On the Data Sources page, select the Fusion icon (). The data source configuration wizard will start.
Name your Fusion data source and add an optional description, as described for the General Tab. Click Next when you are done.
The Data Sources tab is unique to Fusion data sources. It contains a list of all the available data sources on the left of the tab. Select the data sources you want to join in your Fusion data source. As they are selected, they are listed on the right side of the tab. Use the search bar to locate a data source if necessary.
Select the checkbox for each data source you want to join. Your selections will be added to the fusion list to the right. You can provide an alias for each data source, delete a source that is not needed, and download the configuration details for the data source (if available and you need to export to another Zoomdata instance).
Optionally, provide an alias for each selected data source using the field in the Source Alias column. The only special character that can be used is the underscore (_).
The only special character that can be specified in a source alias is the underscore (_). This field can only be edited during the initial setup of the data source. The text is locked after you save the source. To edit this field, you need to either delete or uncheck the source and re-select it again.
You can also delete a data source from the Fusion data source and download a data source by clicking the icons in the Delete and Download columns.
When you are finished with the Data Sources tab, click Next.
The Editor tab is unique to Fusion data sources. Use the Editor tab to specify the join definitions for fusion. See Data Fusion Join Rules for rules about defining these join definitions.
The Available Fields section of the tab lists all the fields you can use in join definitions. The Define Joins section of the tab lists the join definitions and join conditions (forms).
To define a join definition:
Drag-and-drop fields from the Available Fields section into the Define Joins work area. Use the guide areas (outlined with dashed lines) in the work area to position the field in the correct location. Be sure to follow the Data Fusion Join Rules or errors will result when you save the Fusion data source.
After you have selected the fields for a join definition, use the Join drop-down menu to select the type of join that should be performed: Inner (inner join), Left (left outer join), or Full Outer (full outer join). Right outer joins are not supported.
In addition, you can specify whether a field is unique. For unique fields, the join condition values must be unique per record. To specify that a field is unique, click its Unique checkbox.
To delete a join field, a join condition (form), or a join definition from the Define Joins work area, click on the icon and then select Delete.
Optionally, use the Caching switch to indicate whether Zoomdata should cache the aggregated results of queries from this source. See How Zoomdata Caches Data.
When you have finished with your updates on the Editor tab, click Next to proceed to the Fields tab or Finish to save the Fusion data source. When you click Next or Finish, any errors in the Fusion data source definition will be identified and displayed.
On the Fields tab, update the fields included in our Fusion data source, as described for the Fields Tab. (Note that you cannot create derived fields for Fusion data sources.) Click Save & Next when you are done.
Use the Charts tab to specify global default settings for charts that use the Fusion data source as well as default settings for each charts type that uses the data source. See Charts Tab. Note that not all chart types are available for Fusion data sources. See Data Fusion Limitations.
Click Save to save the Fusion data source configuration.