|
<< Click to Display Table of Contents >> Navigation: Dashboard Designer > Provide Data > Supported Data Sources > SQL Data Source |
SQL Data Source
To connect to various SQL databases, the Dashboard Designer requires corresponding providers to be installed on your machine.
The table below lists the supported data sources and the required data providers.
SQL DATA SOURCE |
SUPPORTED VERSIONS |
PROVIDER |
DATABASE PROVIDER ASSEMBLY |
DOWNLOAD LINK |
Microsoft SQL Server |
2005, 2008, 2008R2, 2012, 2014, 2016, 2005 Express Edition, 2008 R2 Express, 2012 Express, 2014 Express, 2016 Express, Azure SQL Database |
.NET Framework Data Provider for SQL Server |
System.Data.dll |
Included in .NET Framework |
Microsoft Access |
2000 or higher |
Microsoft Jet OLE DB Provider / Microsoft Access Database Engine (ACE) |
System.Data.dll |
Microsoft Access 2000-2003 Microsoft Access 2007 and later Access |
Microsoft SQL Server CE |
3.5, 4.0 |
.NET Framework Data Provider for SQL Server Compact |
System.Data.SqlServerCe.dll |
Included in .NET Framework |
Oracle Database |
9i or higher |
Oracle Data Provider for .NET / .NET Framework Data Provider for Oracle |
Oracle.DataAccess.dll, Oracle.ManagedDataAccess.dll, System.Data.OracleClient.dll |
(Included in .NET Framework) |
|
||||
SQL DATA SOURCE |
SUPPORTED VERSIONS |
PROVIDER |
DATABASE PROVIDER ASSEMBLY |
DOWNLOAD LINK |
Amazon Redshift |
n/a |
.NET data provider for PostgreSQL |
Npgsql.dll |
|
Google BigQuery |
n/a |
DevExpress.DataAccess.BigQuery ADO.NET provider |
DevExpress.DataAccess.BigQuery.dll |
|
Teradata |
13.0 or higher |
.NET Data Provider for Teradata |
Teradata.Client.Provider.dll |
|
SAP Sybase Advantage |
Advantage Database Server 9.1 or higher |
Advantage .NET Data Provider |
Advantage.Data.Provider.dll |
|
SAP Sybase ASE |
Sybase Adaptive Server 12.0 or higher |
SAP Sybase ASE Database Client |
Sybase.Data.AseClient.dll |
|
SAP SQL Anywhere |
11 or higher |
SAP SQL Anywhere Database Client |
iAnywhere.Data.SQLAnywhere.dll |
|
IBM DB2 |
9.5 or higher |
ADO.Net client from IBM |
IBM.Data.DB2.dll |
|
Firebird |
1.5 or higher, Dialect 3 |
Firebird ADO.NET Data Provider |
FirebirdSql.Data.Firebird.dll, FirebirdSql.Data.FirebirdClient.dll |
|
MySQL |
4.1 or higher |
ADO.NET driver for MySQL |
MySql.Data.dll |
|
Pervasive PSQL |
9.x or higher |
PSQL ADO.NET Data Provider |
Pervasive.Data.SqlClient.dll |
|
PostgreSQL |
7.x or higher |
.NET data provider for PostgreSQL |
Npgsql.dll |
|
VistaDB |
4, 5 |
VistaDB ADO.NET Provider |
VistaDB.5.NET40.dll |
|
SQLite |
3.x |
ADO.NET provider for SQLite |
System.Data.SQLite.dll |
|
XML file |
n/a |
n/a |
n/a |
n/a |
To create a connection to a SQL data source, see Binding to SQL databases.