Select a Data Connection Type

• Jun 06, 2023
• 2 minutes to read

This wizard page allows you to select the required data connection type.

Set the DataSourceWizardSettings.UseMergedConnectionTypePage property to true to use the wizard design illustrated above.

Click Next to proceed to the next wizard page, depending on the selected data connection type.

• Connect to SQL Databases
• Connect to an Entity Framework Data Source
• Connect to an Object Data Source
• Connect to an Excel Data Source
• Connect to a MongoDB Data Source
• Connect to a JSON Data Source
• Connect to an XPO Data Source
• Custom Connection String

The XPO Data Source is hidden from the list of data sources available in the Data Source Wizard.

To customize the list of displayed data connection types, use the DataSourceWizardSettings.AvailableDataSourceTypes property. Also, you can limit the SQL data providers displayed in the Select a Data Connection Type page with the SqlWizardSettings.AvailableDataProviders property.

Supported SQL Data Source Providers

The following table lists all supported data source providers you can select on the Select a Data Connection Type page:

Relational Database System	Supported Versions	.NET Framework Data Provider	.NET 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 (Included in .NET Framework)
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.Core.dll
Amazon Redshift	n/a	Npgsql.dll	Npgsql.dll
Google BigQuery	Only legacy SQL functions and operations are supported	ODBC	ODBC
Teradata	13.0 or higher	Teradata.Client.Provider.dll	Teradata.Client.Provider.dll
SAP HANA	2.0 or higher	SAP HANA Client 2.0	SAP HANA Client 2.0 Sap.Data.Hana.Core.v2.1.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	VistaDB.5.NET40.dll
SQLite	3.x	System.Data.SQLite.dll Microsoft.Data.SQLite.dll	System.Data.SQLite.Core.dll Microsoft.Data.Sqlite.Core.dll
XML file	n/a	Built-in support	Built-in support