Devart ODBC Driver for BigCommerce Crack
Added support for SQL_ATTR_MAX_ROWS attribute.
Improved compatibility with Linked Server in Microsoft SQL Server.
Improved compatibility with Visual Basic in Microsoft Visual Studio.
Improved compatibility with Alteryx.
Devart ODBC Driver for BigCommerce provides a high-performance and feature-rich connectivity solution for ODBC-based applications to access BigCommerce. Full support for standard ODBC API functions and data types implemented in the driver makes interaction of your database applications with BigCommerce fast, easy and extremely handy.
Features
Connection to BigCommerce – The driver provides capabilities to establish connections to BigCommerce data directly via HTTPS. If you have no access to BigCommerce via HTTPS directly, you have also an ability to connect via Proxy using the options: Host, Port, Username, Password.
Extended SQL Syntax – The ODBC driver provides an unrivalled opportunity to work with BigCommerce objects just as with SQL tables. The extended SQL syntax allows you to use all the SQL benefits in SQL-92 compatible SELECT statements:
Complex JOINs
WHERE conditions
Subqueries
GROUP statements
Aggregation functions
ORDER statements
DML Operations – Devart ODBC Driver for BigCommerce provides support for DML:
INSERT
UPDATE
DELETE
which allows you to modify data in BigCommerce the same way as in SQL databases.
Bulk Updates – You can perform bulk updates by combining SQL statements into batches, thus simplifying and speeding up large data modification.
Advanced Data Conversion – Includes advanced Data Conversion mechanisms that provide bi-directional mapping to ODBC data types.
ODBC Conformance – The driver provides full support for common ODBC interface:
ODBC API Functions support
ODBC Data Types support
In addition, it provides support for Advanced Connection String parameters. Thus allowing any desktop and web applications to connect from various environments and platforms that support ODBC.