This example creates at runtime the following data sources:
- SQL data source connected to the SQLite database
- Excel data source
- Object data source
- JSON Data Source
Subsequently federated data sources are created to integrate the existing data sources.
This example demonstrates the following query types you can use to create a data federation:
-
Join
Combines rows from two or more tables based on a column they share. The join type specifies records that have matching values in both tables.
-
Union and UnionAll
Union combines rows from two or more tables into a single data set and removes duplicate rows in merged tables. UnionAll operates in the same manner as Union, but duplicates rows from different tables when they contain the same data. You can create a union query for data sources if data types of their columns are implicitly converted.
-
Transformation
If a data source contains a complex column (an object), you can transform its properties to display them as separate columns in a flattened view. If one of the data column is an array, you can unfold its values and display a new data row for every element of the array. When you unfold the column, you can flatten it and create a flattened view.
The application creates a simple dashboard at runtime, binds it to the DashboardFederationDataSource created with the Join type and displays the dashboard in the DashboardDesigner control.
