Creating a Fusion Data Source
To fuse data in Composer, 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 . After the data sets have been joined together, you can explore and analyze the fused data set in visuals and dashboards.
For an overview of Composer’s data fusion capability, see Fuse 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 Composer. If not, create them See Manage 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 Composer administrator.
On the Sources page, select . The data source configuration wizard will start.
On the Select a Source Type dialog, select Fusion.
Name your Fusion data source and add an optional description, as described for the General Tab. Select 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 Composer instance).
Optionally, provide an alias for each selected data source using the field in the Source Alias column boxes. 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 selecting the and icons in the Delete and Download columns.
When you are finished with the Data Sources tab, select .
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, select its Unique checkbox.
In a fused data source, Composer uses information about column uniqueness when building its query plan. This can be critical for a connector's resource usage and query time.
To delete a join field, a join condition (form), or a join definition from the Define Joins work area, select the icon and then select Delete.
Optionally, use the Caching switch to indicate whether Composer should cache the aggregated results of queries from this source. See How Composer Caches Data.
When you have finished with your updates on the Editor tab, select to proceed to the Fields tab or to save the Fusion data source. When you select or , 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.) Select when you are done.
Use the Visuals tab to specify global default settings for visuals that use the Fusion data source as well as default settings for each visuals type that uses the data source. See Visuals Tab. Note that not all visual styles are available for Fusion data sources. See Data Fusion Limitations.
Select to save the Fusion data source configuration.