Supported Data Sources

  • 5 min to read

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.SqlClient.dll

System.Data.dll (Included in .NET Framework)

System.Data.SqlClient.dll

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

Oracle.ManagedDataAccess.dll

System.Data.OracleClient.dll

Oracle.DataAccess.dll

Oracle.ManagedDataAccess.dll

Amazon Redshift

n/a

Npgsql.dll

Npgsql.dll

Google BigQuery

Only legacy SQL functions and operations are supported

DevExpress.DataAccess.BigQuery.dll

DevExpress.DataAccess.BigQuery.dll

Teradata

13.0 or higher

Teradata.Client.Provider.dll

Teradata.Client.Provider.dll

SAP Sybase Advantage

Advantage Database Server 9.1 or higher

Advantage.Data.Provider.dll

 

SAP Sybase ASE

Sybase Adaptive Server 12.0 or higher

Sybase.AdoNet4.AseClient.dll

 

SAP SQL Anywhere

11 or higher

Sap.Data.SQLAnywhere.dll

 

IBM DB2

9.5 or higher

IBM.Data.DB2.dll

IBM.Data.DB2.Core.dll

Firebird

1.5 or higher, Dialect 3

FirebirdSql.Data.FirebirdClient.dll

FirebirdSql.Data.Firebird.dll

FirebirdSql.Data.FirebirdClient.dll

MySQL

4.1 or higher

MySql.Data.dll

MySql.Data.dll

Pervasive PSQL

9.x or higher

Pervasive.Data.SqlClient.dll

 

PostgreSQL

7.x or higher

Npgsql.dll

Npgsql.dll

VistaDB

4, 5, 6

VistaDB.5.NET40.dll

 

SQLite

3.x

System.Data.SQLite.dll

Microsoft.Data.SQLite

System.Data.SQLite.dll

Microsoft.Data.SQLite

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 How to Specify a Custom Connection String for an SQL Data Source 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.

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.

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.

Entity Framework Data Source

The DevExpress Dashboard supports the following Entity Framework versions:

  • 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 using Entity Framework 6.

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 in code.

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.

Extract Diagram

Use the DashboardExtractDataSource class to bind a dashboard to a data extract in code.

Note

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.

XPO Data Source

The XPO data source gets data from eXpress Persistent Objects.

End-users can create an XPO data source and specify connection parameters in the Data Source Wizard.

Use the DashboardXpoDataSource class to bind a dashboard to eXpress Persistent Objects.

JSON Data Source

The JSON data source retrieves data from a Web-service endpoint, text file, or a string in JSON format.

End-users can create a JSON data source and specify connection parameters in the Data Source Wizard.

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.

Federated Data Source

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.