ODBC Drivers
This page provides resources for people looking for ODBC drivers which they can then use with one of the available Python ODBC interfaces.
We group drivers by database backend. Where available, please add the database vendor drivers as first entry in each section.
Contents
-
ODBC Drivers
- Generic Lists
- ODBC Driver Vendors
-
Drivers by Data Source
- Amazon DynamoDB
- Amazon SimpleDB
- Apache Cassandra
- Apache HBase
- Apache Hive
- Authorize.Net
- Azure Management
- Azure Table
- Couchbase
- CSV/TSV Files
- E*TRADE
- Exact Online
- FreshBooks Accounting
- Firebird (and Interbase)
- Gmail
- Google AdWords
- Google Analytics
- Google Apps
- Google BigQuery
- Google Sheets
- HPCC ECL Queries
- HubSpot
- IBM DB2
- IBM Informix
- IBM Netezza
- Ingres
- Intacct
- JSON Services
- LDAP Directory Services
- MailChimp
- MariaDB
- Marketo
- Microsoft Access
- Microsoft Active Directory
- Microsoft Dynamics CRM
- Microsoft Dynamics GP
- Microsoft Dynamics NAV
- Microsoft Exchange
- Microsoft Project
- Microsoft SharePoint
- Microsoft SQL Server
- MongoDB
- MySQL
- NetSuite CRM & ERP
- OData Services
- Office 365
- OFX Financial Accounts
- Oracle
- Oracle Eloqua
- PayPal
- PowerShell
- PreEmptive Analytics
- PostgreSQL
- Quandl
- Reckon
- RSS Feeds
- SAP ASE / Sybase ASE
- SAP DB / MaxDB
- SAP NetWeaver
- Sage 50 UK
- Salesforce & Force.com
- SharePoint Excel Services
- Smartsheet.com
- Spark
- Square
- Sugar
- Teradata
- Twilio
- xBase
- XML Files
- Xero Accounting
- YouTube
- YouTube Analytics
- Zoho CRM
Generic Lists
SQL Summit list of ODBC drivers and vendors
This was once the most comprehensive listing of ODBC drivers. Unfortunately, the site stopped working in 2014, so the above is a link to the last archive.org version. Even though it is not updated anymore, it still provides a good overview of where to look for drivers.ODBC Drivers on databasedrivers.com Listing of available ODBC drivers. This is also available as list based on database backend.
ODBC Driver Vendors
There are a couple of companies which focus on creating commercial quality ODBC drivers for various backends:
Actual Technologies (specialized on Mac OS X)
CData Software ODBC Drivers for more than 60 data sources.
Devart (Windows, Linux, Mac OS X)
Simba Technologies Drivers and driver development tools for Windows, Linux, Mac OS X: SQL Server, Couchbase, MongoDB, Hive, DynamoDB, Redshift, Cassandra, Spark, Impala, BigQuery, HBase, Salesforce.
Drivers by Data Source
Amazon DynamoDB
Please add new entries here
Amazon SimpleDB
Please add new entries here
Apache Cassandra
Please add new entries here
Apache HBase
Please add new entries here
Apache Hive
Please add new entries here
Authorize.Net
Please add new entries here
Azure Management
Please add new entries here
Azure Table
Please add new entries here
Couchbase
Please add new entries here
CSV/TSV Files
Please add new entries here
E*TRADE
Please add new entries here
Please add new entries here
Exact Online
Please add new entries here
Please add new entries here
FreshBooks Accounting
Please add new entries here
Firebird (and Interbase)
Devart Firebird ODBC Driver
Works on Windows, Linux, Mac OS X 32/64 bits.
Supports Firebird server and client versions 2.x, 1.x.Devart Interbase ODBC Driver
Works on Windows, Linux, Mac OS X 32/64 bits.
Supports all the InterBase server and client versions.Please add new entries here
Gmail
Please add new entries here
Google AdWords
Please add new entries here
Google Analytics
Please add new entries here
Google Apps
Please add new entries here
Google BigQuery
Please add new entries here
Google Sheets
Please add new entries here
HPCC ECL Queries
Please add new entries here
HubSpot
Please add new entries here
IBM DB2
IBM DB2 ODBC driver for Windows and Unix
Come with IBM DB2, but can also be downloaded separately. Supports Windows and Unix.Please add new entries here
IBM Informix
Please add new entries here
IBM Netezza
- Netezza ODBC driver
Since IBM acquired Netezza, the ODBC drivers are only available to customers with active support contracts. If you have one, you can download the driver as part of the software bundles from IBM FixCentral (search for "Netezza").
Please add new entries here
Ingres
Please add new entries here
Intacct
Please add new entries here
JSON Services
Please add new entries here
LDAP Directory Services
Please add new entries here
MailChimp
Please add new entries here
MariaDB
MariaDB is a fork of MySQL.
Devart MariaDB ODBC Driver
Works on Windows, Linux, Mac OS X 32/64 bits.
Supports MariaDB 5.x. LGPLed ODBC driver for Windows.Please add new entries here
Marketo
Please add new entries here
Microsoft Access
Please add new entries here
Microsoft Active Directory
Please add new entries here
Microsoft Dynamics CRM
Please add new entries here
Microsoft Dynamics GP
Please add new entries here
Microsoft Dynamics NAV
Please add new entries here
Microsoft Exchange
Please add new entries here
Microsoft Project
Please add new entries here
Microsoft SharePoint
Please add new entries here
Microsoft SQL Server
MS SQL Server Native Client for SQL Server 2005, 2008 and later
Free, supported by Microsoft and available for Windows and 64-bit Linux.Devart SQL Server ODBC Driver
Works on Windows, Linux, Mac OS X 32/64 bits.
Compatible with SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000 (including MSDE), SQL Server 7, SQL Server Compact 4.0, 3.5, 3.1FreeTDS Unix ODBC Driver for SQL Server
Open-source TDS protocol client library, which comes with an ODBC driver. The TDS protocol is used by SQL Server and Sybase ASE.Simba SQL Server ODBC drivers Supports Linux, Mac and Windows. Available in client and server (two-tier) versions.
Please add new entries here
MongoDB
Please add new entries here
MySQL
MySQL ODBC Driver GPLed ODBC driver for Windows, Linux, Mac OS X, and Unix platforms.
Devart MySQL ODBC Driver
Works on Windows, Linux, Mac OS X 32/64 bits.
Supports MySQL servers: 6.0, 5.6, 5.5, 5.1, 5.0, 4.1, 4.0, and 3.23Please add new entries here
NetSuite CRM & ERP
Please add new entries here
OData Services
Please add new entries here
Office 365
Please add new entries here
OFX Financial Accounts
Please add new entries here
Oracle
Oracle Instant Client ODBC driver
Free, supported by Oracle. Works on Windows, Linux, Mac OS X, AIX, z/Linux, Solaris, HP-UX.Devart Oracle ODBC Driver
Works on Windows, Linux, Mac OS X 32/64 bits.
Supports Oracle servers: 12c, 11g, 10g, 9i, 8i, 8.0, including Oracle Express Edition 11g and 10g.
Supports both x86 and x64 versions of the following Oracle Clients: 12c, 11g, 10g, 9i, 8i, 8.0.Please add new entries here
Oracle Eloqua
Please add new entries here
PayPal
Please add new entries here
PowerShell
Please add new entries here
PreEmptive Analytics
Please add new entries here
PostgreSQL
PostgreSQL ODBC Driver]
Open-source driver developed as part of the PostgreSQL project.Devart PostgreSQL ODBC Driver
Works on Windows, Linux, Mac OS X 32/64 bits.
Supports PostgreSQL server versions since 7.1 up to 9.4.Please add new entries here
Quandl
Please add new entries here
Reckon
Please add new entries here
RSS Feeds
Please add new entries here
SAP ASE / Sybase ASE
SAP/Sybase ASE ODBC driver
The ASE ODBC driver comes as part of the ASE installer. Simply select the ODBC driver when running the installer on a client.FreeTDS Unix ODBC Driver for SQL Server
Open-source TDS protocol client library, which comes with an ODBC driver. ASE talks TDS on the wire and the FreeTDS driver also supports ASE.Please add new entries here
SAP DB / MaxDB
MaxDB ODBC Driver
The driver comes as part of the MaxDB downloads.Please add new entries here
SAP NetWeaver
Please add new entries here
Sage 50 UK
Please add new entries here
Salesforce & Force.com
Please add new entries here
SharePoint Excel Services
Please add new entries here
Smartsheet.com
Please add new entries here
Spark
Please add new entries here
Square
Please add new entries here
Sugar
Please add new entries here
Teradata
Teradata ODBC Driver
ODBC driver is available for Windows, Linux, Solaris, AIX, HP-UX and Mac.Please add new entries here
Twilio
Please add new entries here
Please add new entries here
xBase
Please add new entries here
XML Files
Please add new entries here
Xero Accounting
Please add new entries here
YouTube
Please add new entries here
YouTube Analytics
Please add new entries here
Zoho CRM
Please add new entries here