Devart ODBC Driver allows Windows 32-bit and 64-bit users to efficiently access BigCommerce through an ODBC interface. It is specifically designed for enterprise-level usage, facilitating seamless integration with robust reporting, analytics, and ETL tools.
One of the standout features of this ODBC driver is its ability to establish connections to BigCommerce cloud databases directly via HTTP, even when direct HTTP access to BigCommerce is not available. Additionally, the Devart ODBC Driver for BigCommerce offers convenient options for connecting via Proxy, including Host, Port, Username, and Password settings.
Another major advantage of this driver is its seamless integration with BigCommerce objects, allowing users to work with them as if they were SQL tables. This means that you can leverage SQL-92 compatible SELECT statements with extended SQL syntax, enjoying all the benefits of SQL query capabilities. Furthermore, the driver supports DML operations such as INSERT, UPDATE, and DELETE, enabling convenient modification of data in BigCommerce similar to SQL databases.
Deploying the Devart ODBC Driver for BigCommerce is hassle-free, as it is a standalone installation file that does not require additional software configuration. This is especially beneficial for large organizations with numerous machines, as the driver can be installed silently using an OEM license, greatly reducing deployment costs. The driver also provides comprehensive support for common ODBC interface, including ODBC API Functions and Data Types, as well as Advanced Connection String parameters, allowing connection to BigCommerce from various environments and platforms that support ODBC.
To access the latest version of the Devart ODBC Driver for BigCommerce, visit the official Devart website. With its exceptional features and comprehensive support, this driver is an excellent choice for anyone in need of a reliable and efficient ODBC driver for accessing BigCommerce data.
Version 2.4.2: *Fixed bug with re-activation ODBC driver via another Windows user
Version 2.4.1:
*Now tokens and passwords are stored in an encrypted form in the DSN record
*Added metadata cache
*Improved compatibility with FileMaker Server for Linux and macOS
Version 2.4.0:
*Now tokens and passwords are stored in an encrypted form in the DSN record
*Added metadata cache
*Improved compatibility with FileMaker Server for Linux and macOS
Version 2.3.1:
*Fixed bug with driver license validation for Linked Server in MSSMS
*Fixed bug with reading DATETIMEs columns in Tableau
Version 2.3.0: *Oracle 23c, SQL Server 2022, and Maria DB 11 support.
Version 2.2.0:
*Added support for SQL_ATTR_MAX_ROWS attribute
*Improved compatibility with Linked Server in SQL Server
*Improved compatibility with Visual Basic in Visual Studio
*Improved compatibility with Alteryx
Version 2.1.0:
*Added support for macOS 13 Ventura
*Improved compatibility with Tableau Prep Builder
*Improved compatibility with Crystal Reports