Devart ODBC Driver for Dynamics 365 provides direct HTTPS connectivity, full ODBC compliance, extended SQL syntax support, and advanced data handling capabilities. It’s designed for efficient and reliable data access across various tools and development environments.
The driver enables various ODBC-compliant applications to connect to Dynamics 365 directly via HTTPS. If direct access is unavailable, you can connect through a proxy server.
The driver lets you work with Dynamics 365 objects just as with standard SQL tables and supports SQL-92 syntax, including:
JOIN operationsWHERE conditionsGROUP BY clausesORDER BY clausesThe driver supports standard Data Manipulation Language (DML) operations, such as INSERT, UPDATE, and DELETE, allowing you to modify Dynamics 365 data directly through SQL commands.
The driver enables bulk updates to Dynamics 365 through batching SQL statements, which simplifies and speeds up large-scale data modification.
The driver offers full support for standard ODBC interfaces, including:
Additionally, it supports advanced connection string parameters, enabling desktop and web applications to connect to Dynamics 365 across various environments and platforms that support ODBC.
The driver is fully compatible with the Dynamics 365 API and supports all native data types.
Advanced data conversion mechanisms are in place, ensuring bi-directional data mapping between Dynamics 365 and ODBC data types.
The driver integrates with popular third-party tools and IDEs such as Microsoft Excel and Visual Studio.
For a full list of compatible tools and environments, see Requirements and compatibility.
The driver offers flexibility across development platforms and environments. It’s available for multiple operating systems, including Windows, macOS, and Linux, in both 32-bit and 64-bit versions. This allows you to build cross-platform applications without limitations, regardless of your target architecture.
The driver provides full Unicode support, allowing you to retrieve and work with data from multilingual Dynamics 365 databases regardless of character set—whether Latin, Cyrillic, Hebrew, Chinese, or others—and independently of the environment’s locale settings.
The driver makes operations with Dynamics 365 significantly faster with features like local data caching, connection pooling, and query optimization.
You can visit our Support page for expert assistance from knowledgeable professionals, fast issue resolution, and access to nightly builds with hotfixes.