Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Collapse]Dashboard
 [Expand]Getting Started
 [Collapse]Basic Concepts and Terminology
   DevExpress Dashboard Architecture
   Dashboard
   Dashboard Designer
   Dashboard Viewer
   Dashboard Items
   Data Sources
   Measures and Dimensions
 [Expand]Main Features
 [Expand]Preparing the Designer and Viewer Applications
 [Expand]Creating Dashboards
 [Expand]Examples
  Video Tutorials
  End-User Capabilities
  Localization
 [Expand]Redistribution and Deployment
 [Expand]Member Tables
 [Expand]API Reference
[Expand]eXpressApp Framework
[Expand]CodeRush
[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

How would you rate this topic?​​​​​​​