Skip to main content
All docs
V24.1

Specify Data Source Settings for a Federated Data Source

  • 2 minutes to read

The wizard appears if you select Data Federation on the start page. On this wizard page, you can create federated queries based on data from other data sources.

Run Demo: Data Federation

Include Data into Separate Queries

Enable check boxes for data fields, queries, and entire data sources.

Dashboard Data Source Wizard for Data Federation - Select data fields and queries

The selected items are included in data federation as separate queries.

The wizard specifies query names as follows:

  • If the initial data source contains one or more queries (for example, SQL data sources), the federated query name consists of the data source name and query name separated by an underscore: SQL Data Source_SQL Orders.
  • If the initial data source contains data at the root level (for example, Excel data sources), the federated query name is equal to the data source name: Excel Data Source.

Dashboard Data Source Wizard for Data Federation - Resulted federated queries

Combine Data into a Single Query

To combine data from multiple data sources into a single query, hover over the Federated Query string. Click Add query (the + sign) and select one of the query types:

Dashboard Data Source Wizard for Data Federation - Create a single query

This invokes the Query Builder for federated data sources. See the following section for details: Query Builder for Federation Data Sources.

Add a New Query to the Existing Federated Data Source

You can add a new query to the existing federated data source. Open the dashboard menu and go to the Data Sources page. Select the federated data source and click Manage Queries:

Web Dashboard - Invoke the Manage queries dialog for Data Federation

The Manage Queries dialog appears. Click Add query and select one of the query types:

Web Dashboard - Manage queries dialog for Data Federation

This invokes the Query Builder for federated data sources. See the following section for details: Query Builder for Federation Data Sources.

See Also