[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
 [Expand]Getting Started
 [Collapse]Basic Concepts and Terminology
   DevExpress Dashboard Architecture
   Dashboard Designer
   Dashboard Viewer
   Dashboard Items
   Data Sources
   Measures and Dimensions
 [Expand]Main Features
 [Expand]Building the Designer and Viewer Applications
 [Expand]Creating Dashboards
 [Expand]Design-Time Features
  Video Tutorials
  End-User Documentation
 [Expand]Redistribution and Deployment
 [Expand]Member Tables
 [Expand]API Reference
[Expand]eXpressApp Framework
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Data Sources

To visualize data within Dashboard Items, you need to first establish a connection to a data source.

A data source collects underlying data and passes it to a data engine that performs aggregation and summarization before data analysis.

The DevExpress Dashboard allows you to use various data source types: traditional SQL databases, OLAP cubes, Excel and XML files, etc.

The following data source types are supported.

  • SQL Data Source

    Allows you to establish a connection to various types of SQL databases and to work with the connected data.

    In code, the SQL Data Source is represented by the DashboardSqlDataSource class.

  • OLAP cubes

    Provides the capability to connect to an OLAP cube in the Microsoft Analysis Services database.

    In code, use DashboardOlapDataSource.

  • Excel Data Source

    The Excel Data Source can be used to select data from Microsoft Excel workbooks (XLS, XLSX or XLSM) or CSV files.

    In code, use DashboardExcelDataSource.

  • Entity Framework Data Source

    You can connect to an Entity Framework data source defined within the current project or you can use an external assembly containing the required context.

    In code, use DashboardEFDataSource.

  • Object Data Source

    The Object Data Source provides the capability to connect to an object data source defined in a separate class within a current project.

    In code, use DashboardObjectDataSource.

  • Extract Data Source

    A data extract is a compressed snapshot of data from a regular data source. This data is saved to a local file and can be updated from the original data source at any time. For instance, you can work with a live SQL data source or you can use the Extract Data Source as an intermediate layer.

    In code, use DashboardExtractDataSource.

Expanded See Also

Is this topic helpful?​​​​​​​