Adb Supported Databases
The following Adb providers are available, each of which wraps and extends a single .NET database provider. Each Adb provider can support one or more database server types.
|Adb Provider||Supported Databases|
|MySql.Data.MySqlClient||MariaDB™, v5.5, v10.1 onwards
MySQL™, v5.6 onwards
|Npgsql||PostgreSQL®, current versions (5 years)|
|System.Data.Odbc||Most ODBC data sources|
|System.Data.Odbc for SQL Server||Microsoft SQL Server® 2008 onwards|
|Microsoft.Data.SqlClient||Microsoft SQL Server® 2008 onwards|
- Additional targeted providers for more databases beyond the above are planned, prioritized by user demand.
- While Adb workers can only be used with the above supported Adb providers, and are very easy to use, one can also use traditional .NET data access code to work with other databases. This includes integrating their data with all the non-Adb dataflow workers, e.g.: