Skip to main content
All docs
V25.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