To connect to SQL databases, install the data providers on the client machine or web server. The table below lists the supported SQL databases and 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.
If you use a custom connection string, specify the XpoProvider parameter as described in the How to Specify a Custom Connection String for an SQL Data Source topic.
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 Microsoft Analysis Services OLE DB and Microsoft ADOMD.NET providers should be installled on the client machine or web server. Refer to the Data providers used for Analysis Services connections article for more information.
The following OLAP servers are supported:
ASP.NET Core Dashboard control in 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.
The DevExpress Dashboard supports the following Entity Framework versions:
Use the DashboardEFDataSource class to bind a dashboard to an Entity Framework data source.
The DashboardEFDataSource should have a data provider to connect to a data source. 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.
The DevExpress Dashboard supports a compressed data snapshot from a regular data source (such as DashboardSqlDataSource, DashboardEFDataSource, DashboardObjectDataSource, etc.). You can save a snapshot to a local file and update it from the original data source. An extracted data source can be used as a regular data source.
Use the DashboardExtractDataSource class to bind a dashboard to a data extract in code.
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.
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.
Use the DashboardFederationDataSource class to bind a dashboard to a federated data source in code.