You may have to install a free third party component to access your specific platform. Look for the entries in red in your File – Data Providers form, with registered ADO.NET Data Providers. After you install a specific data provider for your platform, restart the application and look for your new installed provider.
MySQL, MariaDB and Amazon Aurora
- If we cannot find MySql.Data.MySqlClient.
- Download and run the free Connector/Net MSI installer from MySQL’s website.
- This should register the MySQL Data Provider (.Net Framework Data Provider for MySQL) on your machine.
PostgreSQL and Amazon Redshift
- If we cannot find Npgsql.
- Download and run the free Npgsql MSI installer from github.
- This should register the Npgsql Data Provider (.NET Data Provider for PostgreSQL) on your machine.
- If we cannot find Oracle.ManagedDataAccess.Client.
- Download and unzip the free ODP.NET_Managed file from Oracle’s website.
- This should register the ODP.NET, Managed Driver (Oracle Data Provider for .NET, Managed Driver) on your machine.
Microsoft SQL Server and Microsoft Azure SQL Database
- If we cannot find System.Data.SqlClient.
- You should upgrade your .NET Framework to 4.0 or higher.
- This should register the SqlClient Data Provider 4.0 (.Net Framework Data Provider for SqlServer) on your machine.
- As an alternative, download and install a free version of SQL Server Express.
Microsoft SQL Server CE
- If we cannot find System.Data.SqlServerCe (which should be included in the .NET Framework).
- Download and run the free Microsoft SQL Server Compact 4.0 from Microsoft’s website.
- This should register the Microsoft SQL Server Compact Data Provider 4.0 (.NET Framework Data Provider for Microsoft SQL Server Compact) on your machine.
- You must have Microsoft Access installed on your computer.
- If we cannot find System.Data.OleDb, or one of the OLE DB providers for Access Microsoft.Jet.OLEDB.4.0 (for MDB files) or Microsoft.ACE.OLEDB.12.0 (for ACCDB files, since MS Access 2007).
- Download and install the free Microsoft Access Database Engine 2010 Redistributable (for x32) from Microsoft’s website.
- This should register the OleDb Data Provider (.Net Framework Data Provider for OleDb) and the MS Access OLE DB providers on your machine.
- If we cannot find Sybase.Data.AseClient.
- Get a free Developer Edition of SAP Adaptive Server Enterprise from SAP’s website, run the setup as Custom and install just ADO.NET.
- This should register the Sybase ASE Data Provider (.NET Framework Data Provider for Sybase ASE) on your machine.
Sybase/SAP SQL Anywhere
- If we cannot find iAnywhere.Data.SQLAnywhere.
- Download and run the free SQL Anywhere Windows Client (x64 on Vista 64 or above) from SAP’s website.
- This should register the SQL Anywhere 16 Data Provider (.Net Data Provider for SQL Anywhere 16) on your machine.
- If we cannot find IBM.Data.DB2.
- Download and install the IBM Data Server Driver Package (DS Driver) from IBM’s website.
- This should register the IBM DB2 .NET Data Provider (IBM DB2 Data Provider for .NET Framework 4.0) on your machine.
- If we cannot find Ingres.Client.
- Download, unzip and run the free Ingres .NET Data Provider from Actian’s website.
- This should register the Ingres Data Provider (.NET Data Provider for Ingres) on your machine.
- There is no need of a third party data provider for SQLite.
- We use a built-in driver, distributed and installed automatically with our own product.
- If we cannot find FirebirdSql.Data.FirebirdClient.
- Download and run the free Firebird ADO.NET MSI installer from Firebird’s website.
- This should register the FirebirdClient Data Provider (.NET Framework Data Provider for Firebird) on your machine.
- Aggregate Queries
- Basic Joins
- Conditional Formula
- Configuration Options
- Crosstab Queries
- Custom Joins
- Data Providers
- Database Connections
- Date and Time
- Demo Queries
- Diagram Options
- ER Notation
- Filter Data
- Fluent Expressions
- Generated Models
- Grouping Sets
- Inline Subqueries
- Many-to-Many Relationships
- Metadata Synchronization
- Join Notation
- Nesting Queries
- Null Issues and Fixes
- One-to-Zero/One Relationships
- Parameterized Queries
- Query Types
- Relationship Items
- Result Extensions
- Skip-and-Keep Queries
- Sorting Data
- Supported Databases
- Union Joins
- Window Functions