--- title: "Data Federation" slug: "data-federation" updated: 2023-10-09T09:43:10Z published: 2023-10-09T09:43:11Z canonical: "help.symphonysummitai.com/data-federation" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.symphonysummitai.com/llms.txt > Use this file to discover all available pages before exploring further. # Data Federation 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**. ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/image-1696843138396.png?sv=2026-02-06&spr=https&st=2026-11-21T17%3A32%3A51Z&se=2026-11-21T18%3A32%3A51Z&sr=b&sp=r&sig=IPqcO3Yc8h4I0%2Fa0vYsGLYGl0LdcW3iBTN5iCoerV%2Bc%3D) 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. 1. Enable the data fields, queries, and entire data sources. ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/image-1696843522138.png?sv=2026-02-06&spr=https&st=2026-11-21T17%3A32%3A51Z&se=2026-11-21T18%3A32%3A51Z&sr=b&sp=r&sig=NG4fzKiMA9EBgqbiyarSwASZNygoagev6U1TuQrQTvc%3D)Figure: Data fields, queries, and entire data sources. 2. The selected fields are included in the data federation as separate queries. **Note:** 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. 1. Choose one of the query types by clicking Add query (+). ![](https://cdn.document360.io/62351b42-cfbd-43ad-8ce1-82b8f455337f/Images/Documentation/image-1696844119217.png?sv=2026-02-06&spr=https&st=2026-11-21T17%3A32%3A51Z&se=2026-11-21T18%3A32%3A51Z&sr=b&sp=r&sig=EVy6HP29DFZxbbywwdmWHzvOmBeOiCRCcTnvMT%2BOWb8%3D)Figure: Federated Queries 2. 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) ### Add a New Query to the Existing Federated Data Source << work in progress>><< Need clarification>>