Data Federation
- 09 Oct 2023
- 1 Minute to read
- Print
- PDF
Data Federation
- Updated on 09 Oct 2023
- 1 Minute to read
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Data federation refers to the process of integrating and consolidating data from multiple disparate sources, often from various IT systems and databases, into a single unified view within the dashboard.
Select Data connection
Select Data Federation on the select data source type page. Click Next. 
Figure: Data federation
Include Data into Separate Queries
The columns selected from specific tables and/or views will be automatically included in a separate query.
- Enable the data fields, queries, and entire data sources.
Figure: Data fields, queries, and entire data sources. - The selected fields are included in the data federation as separate queries.
Figure: DNote:
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.
<< update screenshot>>
Federated Queries
Hover your mouse pointer over the Federated Query string to combine multiple data from various sources into a single query.
- Choose one of the query types by clicking Add query (+).
Figure: Federated Queries - This launches the Query builder for federated data sources. To know more about this, refer to Query Builder for federated data sources.(A link to the page will be added)
Figure: Federated QueriesAdd a New Query to the Existing Federated Data Source
<< work in progress>><< Need clarification>>
Was this article helpful?