High-Performance Access to MySQL and MariaDB With an ODBC Driver

Devart ODBC Driver for MySQL is a high-performance connectivity solution with enterprise-level features for accessing MySQL and related databases. It is compatible with 200+ ODBC-compliant reporting, analytics, BI, and ETL tools and works on 32-bit and 64-bit versions of Windows, macOS, and Linux. Devart ODBC Driver fully supports standard ODBC API functions and data types, enabling straightforward and secure access to live MySQL data from anywhere.

  • Verified compatibility with multiple BI and ETL tools
  • Simple installation on several computers
  • Easy access to live data from anywhere
  • Fast data transmission
How ODBC Driver for MySQL works

Direct connection to MySQL and MariaDB

Our data connector enables various ODBC-aware applications to establish a direct connection to MySQL via TCP/IP and thus eliminate the need for any MySQL clients. A direct connection increases the speed of data transmission between an external application and MySQL for real-time analytics. It streamlines the deployment process, since there is no need to distribute any additional client-side software with the Devart ODBC Driver at hand.

The Driver enables connections to the following databases:
  • MySQL
  • Microsoft Azure Database for MySQL
  • MariaDB
  • Amazon RDS for MySQL
  • Amazon Aurora

Features

Direct connection to MySQL databases

Direct connection

You can connect to databases directly via TCP/IP without requiring any additional MySQL client libraries.

Access to database structures schemas tables and procedures

Objects and metadata access

The Driver allows you to retrieve tables, columns, indexes, primary keys, and metadata through ODBC functions.

Full support of ODBC functions data types and standards

ODBC conformance

The Driver fully supports the ODBC API and data types, allowing any ODBC-aware application to work with MySQL.

Bidirectional mapping between MySQL and ODBC data formats

Advanced data conversion

The Driver provides advanced bidirectional mapping between MySQL and ODBC data types.

Executing batch SQL operations for large data changes

Bulk updates

You can modify large amounts of data effortlessly with bulk updates that can be performed by executing SQL queries.

Secure encrypted connections using SSL TLS SSH and HTTPS tunnels

Secure connections

Your data is consistently and reliably protected with enterprise-grade encryption, SSL/TLS, SSH, and HTTP/HTTPS tunneling.

Compatibility with multiple ODBC-aware tools

MySQL compatibility

The Driver works with 200+ ODBC-compatible tools, including reporting, BI, data integration, and analytics platforms.

Straightforward Driver deployment without client software

Easy deployment

You can install the Driver as a standalone tool without deploying vendor-specific client libraries or additional dependencies.

How does Devart ODBC Driver stack up against standard database vendor drivers?

Features
Devart ODBC Driver
Database vendor driver
Direct connections to data sources without client software
Included
Not included
Compliance with ODBC 3.52
Included
Included
Full compliance with the ODBC API and data types
Included
Not included
Compatibility with the latest server versions
Included
Included
SSL-protected communication without third-party libraries
Included
Not included
SSH-protected communication
Included
Not included
HTTP/HTTPS tunneling
Included
Not included
Verified compatibility with multiple BI and ETL tools
Included
Not included
Fast parallel bulk data loading
Included
Included
Auto-installation in a few clicks
Included
Not included
Support for 32-bit and 64-bit applications
Included
Included
Availability on Windows, Linux, and macOS
Included
Included
Unicode support: different languages and data types
Included
Included
Nightly builds with the most recent changes and hotfixes
Included
Not included
Dedicated support team of software engineers
Included
Not included
Active community
Included
Not included
ODBC 2.x behavior emulation
Included
Not included
Support for popular programming languages
Included
Included
Advanced login
Included
Not included
Convenient GUI on Linux and macOS
Included
Not included
Connection pooling
Included
Included
Premium support
Included
Not included
Open source code
Not included
Included
Open source code
Not included
Included
Cost
Paid (with multiple licensing options and bulk discounts)
Free

Pricing

ODBC Driver for MySQL

Starts from

$139.95
per year
Try the Driver

Key features:

  • Compliance with ODBC 3.52
  • Direct connections to data sources without client software
  • Full compliance with the ODBC API and data types
  • Compatibility with the latest server versions
  • Verified compatibility with 200+ BI and ETL tools
  • Fast parallel bulk data loading

ODBC Drivers Universal Bundle

Starts from

$499.95
per year
Try the Universal Bundle

Key features:

  • Support for all 92 ODBC Drivers
  • Easy access to live data from anywhere
  • Full support for standard ODBC API functions and data types
  • No need for database client libraries
  • Support for ODBC-compliant reporting, analytics, BI, and ETL tools
  • Secure connections via SSL, SSH, and HTTPS tunneling

Verified compatibility with 200+ 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!

Roles

People working at their computers in an office

Managers and analysts

Use MySQL or MariaDB through ODBC to access, analyze, and report on data with familiar BI, analytics, and reporting tools. Quickly connect to operational datasets, run ad-hoc queries, and generate reliable insights without complex setup, scripts, or proprietary interfaces.

IT & data teams

Manage, secure, and integrate MySQL and MariaDB data sources across enterprise environments through standardized ODBC connectivity.

Developers

Build, test, and deploy applications that work with MySQL and MariaDB using a unified ODBC interface.

ODBC Universal Bundle

Get high-performance ODBC Drivers for 92 databases and cloud services in a single Universal Bundle with a 95% discount

Ready to get started?

Get a 30-day free trial now

Get a 30-day free trial now

You can download our ODBC Driver for a free 30-day trial. It is a great way to see the Driver in action with no hurry.

Enjoy bulk discounts

Enjoy bulk discounts

We offer flexible options to meet your budget in the optimal way. You can get bulk discounts for multiple purchases.

Need a hand?

Need a hand?

If you need any help or have questions about our connectivity solutions or purchasing options, feel free to get in touch.

FAQ

Which operating systems does the Devart ODBC Driver for MySQL and MariaDB support?

The Driver supports Windows, macOS, and Linux, and is available in both 32-bit and 64-bit versions.

Do I need to install MySQL or MariaDB client libraries?

No. When using Direct mode, the driver connects to MySQL and MariaDB servers without requiring any external client software. Client libraries are needed only if you choose Client mode.

What security features are included in the MySQL/MariaDB ODBC Driver?

The Driver supports SSL/TLS encryption, SSH tunneling, and HTTPS tunnels, ensuring secure and protected communication with your MySQL or MariaDB servers.

Which BI and analytics tools are compatible with the Devart MySQL & MariaDB ODBC Driver?

The Driver works with leading BI and analytics platforms, including Power BI, Tableau, Qlik Sense/View, MicroStrategy, IBM SPSS, SAS JMP, Crystal Reports, RStudio, Spotfire, and Alteryx.

Does the ODBC Driver provide data encryption features?

Yes. The Driver offers secure encrypted communication channels and supports secure authentication methods for compliance and data protection.

Is the Devart ODBC Driver for MySQL/MariaDB compatible with both 32-bit and 64-bit applications?

Yes, the Driver fully supports both 32-bit and 64-bit applications on all supported operating systems.