Supported Data Sources
- 6 minutes to read
- SQL Data Source
- OLAP Data Source
- Microsoft Excel Workbooks/CSV Files
- Entity Framework Data Source
- Object Data Source
- Extract Data Source
- XPO Data Source
- JSON Data Source
- Federated Data Source
SQL Data Source
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 | Supported Versions | .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) | |
Microsoft Access | Access 2000 or higher Access 2007 or higher | System.Data.dll |
|
Microsoft SQL Server CE | 3.5, 4.0 | System.Data.SqlServerCe.dll (Included in .NET Framework) |
|
Oracle Database | 9i or higher |
System.Data.OracleClient.dll Oracle.DataAccess.dll | |
Amazon Redshift | n/a | ||
Google BigQuery | Only legacy SQL functions and operations are supported | ||
Teradata | 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 |
| |
IBM DB2 | 9.5 or higher | IBM.Data.DB2.dll | |
Firebird | 1.5 or higher, Dialect 3 | FirebirdSql.Data.FirebirdClient.dll FirebirdSql.Data.Firebird.dll | |
MySQL | 4.1 or higher | ||
Pervasive PSQL | 9.x or higher | Pervasive.Data.SqlClient.dll |
|
PostgreSQL | 7.x or higher | ||
VistaDB | 4, 5, 6 |
| |
SQLite | 3.x | ||
XML file | n/a | Built-in support | Built-in support |
Use the DashboardSqlDataSource class to bind a dashboard to an SQL database.
Note
If you use a custom connection string, specify the XpoProvider parameter as described in the Custom Connection Strings for Data Sources topic.
Note
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.
Tip
Documentation:
OLAP Data Source
The Microsoft Analysis Services OLE DB and Microsoft ADOMD.NET providers should be installed 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:
- Microsoft SQL Server 2000 Analysis Services
- Microsoft SQL Server 2005 Analysis Services
- Microsoft SQL Server 2008 Analysis Services
- Microsoft SQL Server 2008 R2 Analysis Services
- Microsoft SQL Server 2012 Analysis Services (Multi-dimensional mode)
- Microsoft SQL Server 2014 Analysis Services (Multi-dimensional mode)
- Microsoft SQL Server 2016 Analysis Services (Multi-dimensional mode)
Note
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.
Tip
Documentation:
Microsoft Excel Workbooks/CSV Files
The following Microsoft Excel/text formats are supported:
- XLS
- XLSX
- XLSM
- CSV
Use the DashboardExcelDataSource class to bind a dashboard to an Excel workbook.
Tip
Documentation:
Entity Framework Data Source
The following Entity Framework versions are supported:
- Entity Framework 5.0 and higher.
- Entity Framework Core 1.0 and higher.
Use the DashboardEFDataSource class to bind a dashboard to an Entity Framework data source.
Note
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 that uses Entity Framework 6.
Tip
Documentation:
Object Data Source
You can use any object that implements the IEnumerable or IListSource interface as a dashboard’s data source.
Use the DashboardObjectDataSource class to bind a dashboard to an object data source.
Tip
Documentation:
Extract Data Source
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.
The data within the extract is optimized for data grouping and reduces the initial load time. You can use an in-memory cache (ExtractCacheOptions) to improve performance when accessing extract data.
Use the DashboardExtractDataSource class to bind a dashboard to a data extract.
Tip
Documentation:
XPO Data Source
The XPO data source gets data from eXpress Persistent Objects.
Use the DashboardXpoDataSource class to bind a dashboard to eXpress Persistent Objects.
Tip
Documentation:
JSON Data Source
The JSON data source retrieves data from a Web-service endpoint, text file, or string in JSON format.
Use the DashboardJsonDataSource class to bind a dashboard to JSON-formatted data.
Important
The DashboardJsonDataSource object requires the open source Newtonsoft.Json library. Install the Newtonsoft.Json NuGet package in Visual Studio.
Tip
Documentation:
Federated Data Source
You can create a query that combines data sources to provide uniform access. 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. A federated data source does not support OLAP data sources.
Use the DashboardFederationDataSource class to bind a dashboard to a federated data source.