How to Install ODBC Driver for Dynamics 365?

1. Download the Devart ODBC driver for Dynamics 365 from the official website. 2. Run the installer and follow the wizard instructions. 3. If the installation folder already exists or another driver version is installed, you will see a warning. Click Yes to overwrite the old files or uninstall the previous version (recommended). 4. On the Select Components page, choose to install the 64-bit or 32-bit version. 5. In the License Information dialog, select the license type and activate the product. You can choose Trial if you don't have an activation key. 6. If you have an activation key, select the Activation Key option and paste it from your registration email or Customer Portal. 7. If you have an activation key file, click Load Activation Key and browse to the file. 8. Click Next, then Install, and finally Finish.

How to configure an ODBC connection to Dynamics 365 database on Windows?

1. Open the ODBC Data Source Administrator. 2. Select the User DSN or System DSN tab. 3. Click Add to open the Create New Data Source dialog. 4. Select Devart ODBC Driver for Dynamics 365 and click Finish. 5. Enter the required connection information. 6. If using OAuth2, click Sign In with Dynamics 365, enter your credentials, and grant access to generate a refresh token. 7. Click Test Connection to verify the setup. 8. Click OK to save the DSN.

How to configure an ODBC connection to Dynamics 365 database on Linux?

After installing the Linux DEB or RPM driver, a DSN named DEVART_DYNAMICS is created. Steps: 1. Open the odbc.ini file in the /etc directory. 2. Find the DEVART_XBASE section and enter the following connection settings: Server, User ID, and Password. 3. Run the UnixODBC Test Command utility with: isql -v DEVART_DYNAMICS.

How to use Devart ODBC Driver for Dynamics 365?

You can use the ODBC driver for MySQL to connect to Dynamics 365 from various ODBC-compliant tools such as BI, ETL, or analytics software. For example, in DBeaver: 1. Configure a Data Source Name in the Data Source Administrator. 2. To avoid display issues with SQL_WVARCHAR data types, set String Types to Ansi in Advanced Settings. 3. Open DBeaver and choose New Database Connection from the Database menu. 4. Click Add to create a new data source. 5. In the wizard, select ODBC and click Next. 6. Enter the previously configured DSN in the Database/Schema field. 7. Click Test Connection. If successful, you will see a confirmation message.

ODBC Driver for Dynamics 365

Devart ODBC Driver for Dynamics 365 is a high-performance data integration connector for developers and data analysts, with enterprise-level features for accessing Dynamics 365 (formerly Dynamics CRM) from ODBC — compliant reporting, analytics, BI, and ETL tools.

The Driver, with implemented OAuth, allows you to simply enter credentials and start using our app without the need to register it, thereby streamlining and securing data access via the HTTPS protocol.

Supported platforms

Simple installation on multiple computers
Easy access to real-time data from anywhere
OAuth 2.0 support
Bulk operations support for improved efficiency
Full unicode support

Dynamics 365 data integration

Access Microsoft Dynamics 365 data from the tools and systems you rely on — BI and analytics platforms, database management software, and app development tools. This integration helps you:

Combine customer data from sales, marketing, and support into a single, consistent view
Use Dynamics CRM as your primary data source or keep it synchronized with other systems
Work with all Dynamics CRM data and metadata, including custom entities, fields, and calculated values
Address common Dynamics 365 integration challenges such as API limits, throttling, security configurations, schema complexity, and versioning

Verified compatibility with data integration tools

Devart ODBC Drivers are verified to be compatible with leading analytics and reporting tools, various IDEs and programming languages. Get fast and secure access to your data in any application using our ODBC Drivers!

Databases & DB management software

Business intelligence & analytics software

Document management software

Application development tools

Extended SQL syntax

Our ODBC Driver provides an unrivalled opportunity to work with Dynamics 365 CRM objects as if they were standard SQL tables. The extended SQL syntax enables you to leverage the full power of SQL in SQL-92 compatible SELECT statements:

Complex JOIN operations
WHERE conditions
Subqueries
GROUP statements

Aggregate functions
ORDER statements
...and much more

Smart data integration starts with the ODBC Driver

Choose the most suitable licensing model from the available options for the ODBC Driver you need.

Start from:

$179.95

Purchase now

Explore the OEM licensing model

Get a personal consultation and discover how our ODBC Driver can streamline your database development.

Request a quote

Get started with the ODBC Driver at no cost

Download a FREE, fully functional trial version and elevate your data integration capabilities today!

Download free trial

Features overview

Cost-effective deployment

Our ODBC Driver is a standalone installation file that doesn't require deploying and configuring any additional software such as database clients or vendor libraries. Deployment costs are reduced drastically, especially when using the silent install method with an OEM license in large organizations that have hundreds of machines.

ODBC conformance

The ODBC Driver for Dynamics 365 provides full support for common ODBC interface, including:

ODBC API functions
ODBC data types

It offers advanced connection string parameters and allows any ODBC-compliant desktop or web application to connect to Dynamics 365 from various environments and platforms.

High performance

Every operation with Dynamics 365 data becomes significantly faster with the rich capabilities of Devart ODBC Driver, which include local data caching, connection pooling, and much more.