The DevExpress Dashboard uses database servers that can be configured to use case-sensitive table/column names. For this reason, a database scheme used in dashboards is case-sensitive to prevent any problem when the product is used with such servers.
The data within the extract is already optimized for data grouping, reducing the initial load time. An in-memory cache (ExtractCacheOptions) allows you to improve performance when accessing extract data.
The DashboardJsonDataSource object requires the open source Newtonsoft.Json library. Install the Newtonsoft.Json NuGet package in Visual Studio.
Federated Data Source
You can create a query that includes SQL Data Source queries, Excel Data Sources, and Object Data Sources, and set up a relation condition between them. This query forms the federated data source which operates with the source-specific query language, translates the queries, and processes the results to supply a dashboard with data.