DevExpress Dashboard allows you to establish a connection to various data sources such as SQL databases, Microsoft Excel workbooks, XML/CSV data files or OLAP cubes. You can also use the Entity Framework or Object data sources to supply the dashboard with data.
The following data source types are supported.
To connect to various SQL databases, DevExpress Dashboard requires corresponding providers to be installed on the client machine or web server. The table below lists the supported data sources and the required data providers.
Relational Database System
.NET Framework Data Provider
.NET Standard 2.0 Data Provider
Microsoft SQL Server
2005 or higher
2005 Express or higher
Azure SQL Database
System.Data.dll (Included in .NET Framework)
Access 2000 or higher
Access 2007 or higher
Microsoft SQL Server CE
System.Data.SqlServerCe.dll (Included in .NET Framework)
9i or higher
Only legacy SQL functions and operations are supported
13.0 or higher
SAP Sybase Advantage
Advantage Database Server 9.1 or higher
SAP Sybase ASE
Sybase Adaptive Server 12.0 or higher
SAP SQL Anywhere
11 or higher
9.5 or higher
1.5 or higher, Dialect 3
4.1 or higher
9.x or higher
7.x or higher
Use the DashboardSqlDataSource class to bind a dashboard to an SQL database.
You should specify the XpoProvider parameter if you use a custom connection string to establish connection to data. Refer to the How to Specify a Custom Connection String for the SQL Data Source topic for information on how to specify this parameter.
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.
To use the OLAP data source, DevExpress Dashboard requires Microsoft Analysis Services OLE DB and Microsoft ADOMD.NET providers to be installed on the client machine or web server. To learn more, see Data providers used for Analysis Services connections.
The following OLAP servers are supported.
Note that for ASP.NET Core Dashboard control, OLAP mode supports only XML for Analysis (XMLA) with MSMDPUMP.
Use the DashboardOlapDataSource class to bind a dashboard to an OLAP cube.
The following Microsoft Excel/text formats are supported.
Use the DashboardExcelDataSource class to bind a dashboard to an Excel workbook.
DevExpress Dashboard supports the following Entity Framework versions:
Use the DashboardEFDataSource class to bind a dashboard to an Entity Framework data source.
To connect to different database types using DashboardEFDataSource, you need to install a corresponding data provider. For instance, install the System.Data.SQLite.EF6 data provider to connect to an SQLite database using Entity Framework 6.
Use the DashboardObjectDataSource class to bind a dashboard to an object data source in code.
DevExpress Dashboard supports a compressed snapshot of data from a regular data source (such as DashboardSqlDataSource, DashboardEFDataSource, DashboardObjectDataSource, etc.). This data is saved to a local file and can be updated from the original data source at any time. You can use this data source type as any regular data source.
Use the DashboardExtractDataSource class to bind a dashboard to a data extract in code.
Because data within the extract is already optimized for data grouping, the time required for initial dashboard loading can be significantly reduced. Moreover, a special in-memory cache (ExtractCacheOptions) allows you to improve performance when accessing extract data.