= ODBC Drivers = This page provides resources for people looking for ODBC drivers which they can then use with one of the available [[ODBC|Python ODBC interfaces]]. We group drivers by database backend. Where available, please add the database vendor drivers as first entry in each section. <<TableOfContents()>> == Generic Lists == * [[https://web.archive.org/web/20140209203657/http://www.sqlsummit.com/ODBCVend.HTM|SQL Summit list of ODBC drivers and vendors]] <<BR>> 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. * [[http://www.databasedrivers.com/odbc/|ODBC Drivers on databasedrivers.com]] Listing of available ODBC drivers. This is also available as [[http://www.databasedrivers.com/sources/|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: * [[http://www.actualtech.com/|Actual Technologies]] (specialized on Mac OS X) * [[http://www.cdata.com/|CData Software]] ODBC Drivers for more than 60 data sources. * [[https://www.devart.com/odbc/|Devart]] (Windows, Linux, Mac OS X) * [[http://www.datadirect.com/|DataDirect]] * [[http://www.easysoft.com/|EasySoft]] * [[http://www.openlinksw.com/|OpenLink]] * [[http://www.simba.com/connectors|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 === * [[http://www.cdata.com/drivers/dynamodb/odbc|CData ODBC Driver for Amazon DynamoDB]] * ''Please add new entries here'' === Amazon SimpleDB === * [[http://www.cdata.com/drivers/simpledb/odbc|CData ODBC Driver for Amazon SimpleDB]] * ''Please add new entries here'' === Apache Cassandra === * [[http://www.cdata.com/drivers/cassandra/odbc|CData ODBC Driver for Apache Cassandra]] * [[http://www.simba.com/connectors/apache-cassandra-odbc|Simba Cassandra ODBC driver with SQL connector]] * ''Please add new entries here'' === Apache HBase === * [[http://www.cdata.com/drivers/hbase/odbc|CData ODBC Driver for Apache HBase]] * ''Please add new entries here'' === Apache Hive === * [[http://www.simba.com/connectors/apache-hadoop-hive-driver|Simba Hive ODBC driver with SQL connector]] * ''Please add new entries here'' === Authorize.Net === * [[http://www.cdata.com/drivers/authorizedotnet/odbc|CData ODBC Driver for Authorize.Net]] * ''Please add new entries here'' === Azure Management === * [[http://www.cdata.com/drivers/azuremanagement/odbc|CData ODBC Driver for Azure Management]] * ''Please add new entries here'' === Azure Table === * [[http://www.cdata.com/drivers/azure/odbc|CData ODBC Driver for Azure Table]] * ''Please add new entries here'' === Couchbase === * [[http://www.cdata.com/drivers/couchbase/odbc|CData ODBC Driver for Couchbase Server]] * [[http://www.simba.com/connectors/couchbase-odbc-jdbc-drivers|Simba Couchbase ODBC driver with SQL connector]] * ''Please add new entries here'' === CSV/TSV Files === * [[http://www.cdata.com/drivers/csv/odbc|CData ODBC Driver for CSV/TSV Files]] * ''Please add new entries here'' === E*TRADE === * [[http://www.cdata.com/drivers/etrade/odbc|CData ODBC Driver for E*TRADE]] * ''Please add new entries here'' === Email === * [[http://www.cdata.com/drivers/email/odbc|CData ODBC Driver for Email]] * ''Please add new entries here'' === Exact Online === * [[http://www.cdata.com/drivers/exact/odbc|CData ODBC Driver for Exact Online]] * ''Please add new entries here'' === Facebook === * [[http://www.cdata.com/drivers/facebook/odbc|CData ODBC Driver for Facebook]] * ''Please add new entries here'' === FreshBooks Accounting === * [[http://www.cdata.com/drivers/freshbooks/odbc|CData ODBC Driver for FreshBooks Accounting]] * ''Please add new entries here'' === Firebird (and Interbase) === * [[https://www.devart.com/odbc/firebird/download.html|Devart Firebird ODBC Driver]] <<BR>> Works on Windows, Linux, Mac OS X 32/64 bits. <<BR>> Supports Firebird server and client versions 2.x, 1.x. * [[https://www.devart.com/odbc/interbase/download.html|Devart Interbase ODBC Driver]] <<BR>> Works on Windows, Linux, Mac OS X 32/64 bits. <<BR>> Supports all the InterBase server and client versions. * ''Please add new entries here'' === Gmail === * [[http://www.cdata.com/drivers/gmail/odbc|CData ODBC Driver for Gmail]] * ''Please add new entries here'' === Google AdWords === * [[http://www.cdata.com/drivers/adwords/odbc|CData ODBC Driver for Google AdWords]] * ''Please add new entries here'' === Google Analytics === * [[http://www.cdata.com/drivers/ganalytics/odbc|CData ODBC Driver for Google Analytics]] * ''Please add new entries here'' === Google Apps === * [[http://www.cdata.com/drivers/google/odbc|CData ODBC Driver for Google Apps]] * ''Please add new entries here'' === Google BigQuery === * [[http://www.cdata.com/drivers/bigquery/odbc|CData ODBC Driver for Google BigQuery]] * ''Please add new entries here'' === Google Sheets === * [[http://www.cdata.com/drivers/gsheets/odbc|CData ODBC Driver for Google Sheets]] * ''Please add new entries here'' === HPCC ECL Queries === * [[http://www.cdata.com/drivers/hpcc/odbc|CData ODBC Driver for HPCC ECL Queries]] * ''Please add new entries here'' === HubSpot === * [[http://www.cdata.com/drivers/hubspot/odbc|CData ODBC Driver for HubSpot]] * ''Please add new entries here'' === IBM DB2 === * [[http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.swg.im.dbclient.install.doc/doc/c0059871.html?lang=en|IBM DB2 ODBC driver for Windows and Unix]] <<BR>> Come with IBM DB2, but can also be downloaded separately. Supports Windows and Unix. * [[http://www-03.ibm.com/systems/power/software/i/access/linux/guide.html|IBM ODBC Driver for Linux on iSeries / AS/400 DB2 servers]] * [[http://www.datadirect.com/|DataDirect ODBC Driver for IBM DB2]] * [[http://www.openlinksw.com/|OpenLink ODBC Driver for IBM DB2]] * ''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 [[http://www-933.ibm.com/support/fixcentral/options|IBM FixCentral]] (search for "Netezza"). * ''Please add new entries here'' === Ingres === * ''Please add new entries here'' === Intacct === * [[http://www.cdata.com/drivers/intacct/odbc|CData ODBC Driver for Intacct]] * ''Please add new entries here'' === JSON Services === * [[http://www.cdata.com/drivers/json/odbc|CData ODBC Driver for JSON Services]] * ''Please add new entries here'' === LDAP Directory Services === * [[http://www.cdata.com/drivers/ldap/odbc|CData ODBC Driver for LDAP Directory Services]] * ''Please add new entries here'' === MailChimp === * [[http://www.cdata.com/drivers/mailchimp/odbc|CData ODBC Driver for MailChimp]] * ''Please add new entries here'' === MariaDB === MariaDB is a fork of MySQL. * [[https://mariadb.com/kb/en/mariadb/about-mariadb-connector-odbc/|MariaDB ODBC Driver]] * [[https://www.devart.com/odbc/mysql/download.html|Devart MariaDB ODBC Driver]] <<BR>> Works on Windows, Linux, Mac OS X 32/64 bits. <<BR>> Supports MariaDB 5.x. LGPLed ODBC driver for Windows. * ''Please add new entries here'' === Marketo === * [[http://www.cdata.com/drivers/marketo/odbc|CData ODBC Driver for Marketo]] * ''Please add new entries here'' === Microsoft Access === * ''Please add new entries here'' === Microsoft Active Directory === * [[http://www.cdata.com/drivers/activedirectory/odbc|CData ODBC Driver for Microsoft Active Directory]] * ''Please add new entries here'' === Microsoft Dynamics CRM === * [[http://www.cdata.com/drivers/dynamicscrm/odbc|CData ODBC Driver for Microsoft Dynamics CRM]] * ''Please add new entries here'' === Microsoft Dynamics GP === * [[http://www.cdata.com/drivers/dynamicsgp/odbc|CData ODBC Driver for Microsoft Dynamics GP]] * ''Please add new entries here'' === Microsoft Dynamics NAV === * [[http://www.cdata.com/drivers/dynamicsnav/odbc|CData ODBC Driver for Microsoft Dynamics NAV]] * ''Please add new entries here'' === Microsoft Exchange === * [[http://www.cdata.com/drivers/exchange/odbc|CData ODBC Driver for Microsoft Exchange]] * ''Please add new entries here'' === Microsoft Project === * [[http://www.cdata.com/drivers/msproject/odbc|CData ODBC Driver for Microsoft Project]] * ''Please add new entries here'' === Microsoft SharePoint === * [[http://www.cdata.com/drivers/sharepoint/odbc|CData ODBC Driver for Microsoft SharePoint]] * ''Please add new entries here'' === Microsoft SQL Server === * [[https://msdn.microsoft.com/en-us/sqlserver/connectivity.aspx#SNAC|MS SQL Server Native Client for SQL Server 2005, 2008 and later]] <<BR>> Free, supported by Microsoft and available for Windows and 64-bit Linux. * [[http://www.actualtech.com/|Actual Technologies Mac OS X ODBC Driver for SQL Server]] * [[http://www.datadirect.com/|DataDirect ODBC Driver for SQL Server]] * [[https://www.devart.com/odbc/sqlserver/|Devart SQL Server ODBC Driver]] <<BR>> Works on Windows, Linux, Mac OS X 32/64 bits. <<BR>> 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.1 * [[http://www.easysoft.com/|EasySoft ODBC Driver for SQL Server]] * [[http://www.freetds.org/|FreeTDS Unix ODBC Driver for SQL Server]] <<BR>> Open-source TDS protocol client library, which comes with an ODBC driver. The TDS protocol is used by SQL Server and Sybase ASE. * [[http://www.openlinksw.com/|OpenLink ODBC Driver for SQL Server]] * [[http://www.simba.com/connectors/sql-server-odbc-driver|Simba SQL Server ODBC drivers]] Supports Linux, Mac and Windows. Available in client and server (two-tier) versions. * ''Please add new entries here'' === MongoDB === * [[http://www.cdata.com/drivers/mongodb/odbc|CData ODBC Driver for MongoDB]] * [[http://www.simba.com/connectors/mongodb-odbc|Simba MongoDB ODBC driver with SQL connector]] * ''Please add new entries here'' === MySQL === * [[http://dev.mysql.com/downloads/connector/odbc/|MySQL ODBC Driver]] GPLed ODBC driver for Windows, Linux, Mac OS X, and Unix platforms. * [[http://www.actualtech.com/|Actual Technologies Mac OS X ODBC Driver for MySQL]] * [[http://www.cdata.com/drivers/mysql/odbc|CData ODBC Driver for MySQL]] * [[http://www.datadirect.com/|DataDirect ODBC Driver for MySQL]] * [[https://www.devart.com/odbc/mysql/download.html|Devart MySQL ODBC Driver]] <<BR>> Works on Windows, Linux, Mac OS X 32/64 bits. <<BR>> Supports MySQL servers: 6.0, 5.6, 5.5, 5.1, 5.0, 4.1, 4.0, and 3.23 * [[http://www.openlinksw.com/|OpenLink ODBC Driver for MySQL]] * ''Please add new entries here'' === NetSuite CRM & ERP === * [[http://www.cdata.com/drivers/netsuite/odbc|CData ODBC Driver for NetSuite CRM & ERP]] * ''Please add new entries here'' === OData Services === * [[http://www.cdata.com/drivers/odata/odbc|CData ODBC Driver for OData Services]] * ''Please add new entries here'' === Office 365 === * [[http://www.cdata.com/drivers/office365/odbc|CData ODBC Driver for Office 365]] * ''Please add new entries here'' === OFX Financial Accounts === * [[http://www.cdata.com/drivers/ofx/odbc|CData ODBC Driver for OFX Financial Accounts]] * ''Please add new entries here'' === Oracle === * [[http://www.oracle.com/technology/tech/oci/instantclient/index.html|Oracle Instant Client ODBC driver]] <<BR>> Free, supported by Oracle. Works on Windows, Linux, Mac OS X, AIX, z/Linux, Solaris, HP-UX. * [[http://www.actualtech.com/|Actual Technologies Mac OS X ODBC Driver for Oracle]] * [[http://www.datadirect.com/|DataDirect ODBC Driver for Oracle]] * [[https://www.devart.com/odbc/oracle/download.html|Devart Oracle ODBC Driver]] <<BR>> Works on Windows, Linux, Mac OS X 32/64 bits. <<BR>> Supports Oracle servers: 12c, 11g, 10g, 9i, 8i, 8.0, including Oracle Express Edition 11g and 10g. <<BR>> Supports both x86 and x64 versions of the following Oracle Clients: 12c, 11g, 10g, 9i, 8i, 8.0. * [[http://www.easysoft.com/|EasySoft ODBC Driver for Oracle]] * [[http://www.openlinksw.com/|OpenLink ODBC Driver for Oracle]] * ''Please add new entries here'' === Oracle Eloqua === * [[http://www.cdata.com/drivers/eloqua/odbc|CData ODBC Driver for Oracle Eloqua]] * ''Please add new entries here'' === PayPal === * [[http://www.cdata.com/drivers/paypal/odbc|CData ODBC Driver for PayPal]] * ''Please add new entries here'' === PowerShell === * [[http://www.cdata.com/drivers/powershell/odbc|CData ODBC Driver for PowerShell]] * ''Please add new entries here'' === PreEmptive Analytics === * [[http://www.cdata.com/drivers/preemptive/odbc|CData ODBC Driver for PreEmptive Analytics]] * ''Please add new entries here'' === PostgreSQL === * [[http://psqlodbc.projects.postgresql.org/|PostgreSQL ODBC Driver]]] <<BR>> Open-source driver developed as part of the PostgreSQL project. * [[http://www.actualtech.com/|Actual Technologies Mac OS X ODBC Driver for PostgreSQL]] * [[http://www.datadirect.com/|DataDirect ODBC Driver for PostgreSQL]] * [[https://www.devart.com/odbc/postgresql/download.html|Devart PostgreSQL ODBC Driver]] <<BR>> Works on Windows, Linux, Mac OS X 32/64 bits. <<BR>> Supports PostgreSQL server versions since 7.1 up to 9.4. * [[http://www.easysoft.com/|EasySoft ODBC Driver for PostgreSQL]] * [[http://www.openlinksw.com/|OpenLink ODBC Driver for PostgreSQL]] * ''Please add new entries here'' === Quandl === * [[http://www.cdata.com/drivers/quandl/odbc|CData ODBC Driver for Quandl]] * ''Please add new entries here'' === Reckon === * [[http://www.cdata.com/drivers/reckon/odbc|CData ODBC Driver for Reckon]] * ''Please add new entries here'' === RSS Feeds === * [[http://www.cdata.com/drivers/rss/odbc|CData ODBC Driver for RSS Feeds]] * ''Please add new entries here'' === SAP ASE / Sybase ASE === * [[http://scn.sap.com/community/developer-center/oltp-db|SAP/Sybase ASE ODBC driver]] <<BR>> The ASE ODBC driver comes as part of the ASE installer. Simply select the ODBC driver when running the installer on a client. * [[http://www.actualtech.com/|Actual Technologies Mac OS X ODBC Driver for SQL Server]] * [[http://www.datadirect.com/|DataDirect ODBC Driver for SQL Server]] * [[http://www.easysoft.com/|EasySoft ODBC Driver for SQL Server]] * [[http://www.freetds.org/|FreeTDS Unix ODBC Driver for SQL Server]] <<BR>> 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. * [[http://www.openlinksw.com/|OpenLink ODBC Driver for SQL Server]] * ''Please add new entries here'' === SAP DB / MaxDB === * [[http://scn.sap.com/community/maxdb|MaxDB ODBC Driver]] <<BR>> The driver comes as part of the [[https://store.sap.com/sap/cpa/ui/resources/store/html/Search.html?searchText=maxdb|MaxDB downloads]]. * ''Please add new entries here'' === SAP NetWeaver === * [[http://www.cdata.com/drivers/sap/odbc|CData ODBC Driver for SAP NetWeaver]] * ''Please add new entries here'' === Sage 50 UK === * [[http://www.cdata.com/drivers/sageuk/odbc|CData ODBC Driver for Sage 50 UK]] * ''Please add new entries here'' === Salesforce & Force.com === * [[http://www.cdata.com/drivers/salesforce/odbc|CData ODBC Driver for Salesforce & Force.com]] * ''Please add new entries here'' === SharePoint Excel Services === * [[http://www.cdata.com/drivers/excelservices/odbc|CData ODBC Driver for SharePoint Excel Services]] * ''Please add new entries here'' === Smartsheet.com === * [[http://www.cdata.com/drivers/smartsheet/odbc|CData ODBC Driver for Smartsheet.com]] * ''Please add new entries here'' === Spark === * [[http://www.simba.com/connectors/apache-spark-driver|Simba Spark ODBC driver with SQL connector]] * ''Please add new entries here'' === Square === * [[http://www.cdata.com/drivers/square/odbc|CData ODBC Driver for Square]] * ''Please add new entries here'' === Sugar === * [[http://www.cdata.com/drivers/sugarcrm/odbc|CData ODBC Driver for Sugar]] * ''Please add new entries here'' === Teradata === * [[http://www.teradata.com/downloadcenter/|Teradata ODBC Driver]] <<BR>> ODBC driver is available for Windows, Linux, Solaris, AIX, HP-UX and Mac. * [[http://www.datadirect.com/|DataDirect ODBC Driver for Teradata]] * ''Please add new entries here'' === Twilio === * [[http://www.cdata.com/drivers/twilio/odbc|CData ODBC Driver for Twilio]] * ''Please add new entries here'' === Twitter === * [[http://www.cdata.com/drivers/twitter/odbc|CData ODBC Driver for Twitter]] * ''Please add new entries here'' === xBase === * [[http://www.cdata.com/drivers/xbase/odbc|CData ODBC Driver for xBase]] * ''Please add new entries here'' === XML Files === * [[http://www.cdata.com/drivers/xml/odbc|CData ODBC Driver for XML Files]] * ''Please add new entries here'' === Xero Accounting === * [[http://www.cdata.com/drivers/xero/odbc|CData ODBC Driver for Xero Accounting]] * ''Please add new entries here'' === YouTube === * [[http://www.cdata.com/drivers/youtube/odbc|CData ODBC Driver for YouTube]] * ''Please add new entries here'' === YouTube Analytics === * [[http://www.cdata.com/drivers/youtubeanalytics/odbc|CData ODBC Driver for YouTube Analytics]] * ''Please add new entries here'' === Zoho CRM === * [[http://www.cdata.com/drivers/zohocrm/odbc|CData ODBC Driver for Zoho CRM]] * ''Please add new entries here''