/
/
ODBC
Read, write, and update MySQL through ODBC
New
CData Drivers now work with AI Coding tools
The MySQL ODBC Driver is a powerful tool that allows you to connect with live data from MySQL, directly from any applications that support ODBC connectivity. Access MySQL data like you would a database - read, write, and update MySQL data through a standard ODBC Driver interface.
MySQL
See what you can do with MySQL ODBC Driver
Server
SQL Server Linked-Server
Connect to MySQL from SQL Server as Linked-Server. You can query MySQL from familiar Transact-SQL without need of setting up another application.
Data Integration & ETL
Integrate MySQL to your system through popular ETL / EAI tools such as Informatica PowerCenter. Standard SQL and Stored Procedures enable fast delivery of your integration projects.
MySQL ODBC Connectivity Features
- SQL-92 queries are seamlessly translated to MySQL syntax
- Embedded SSH Tunneling support for secure MySQL access.
- Wire Protocol ADO.NET Provider for MySQL, compatible with MySQL Client Protocol v4.1 and above
- Embedded SSH tunneling enables secure connections to remote MySQL databases
- Seamless integration with MySQL compatible solutions, like Google Cloud SQL, MariaDB, Amazon Aurora, Amazon Relational Database Service (RDS), etc.
- Connect to live MySQL data, for real-time data access with the MySQL ADO.NET Provider
- Full support for data aggregation and complex JOINs in SQL queries
- Secure connectivity through modern cryptography, including TLS 1.2, SHA-256, ECC, etc.
- Seamless integration with leading BI, reporting, and ETL tools and with custom applications via the MySQL Connector.
Target Service, API
The MySQL ODBC driver provides native connectivity to MySQL databases including MySQL 5.x, 8.x, MariaDB, Amazon RDS for MySQL, Azure Database for MySQL, and Google Cloud SQL for MySQL.
Schema, Data Model
Models MySQL with access to databases, tables, views, stored procedures, functions, and events. Dynamic metadata discovery with support for all MySQL data types including JSON and spatial types.
Key Objects
Databases, Tables, Views, Stored Procedures, Functions, Triggers, Events, and system tables. Access to information_schema and performance_schema for metadata and monitoring.
Operations
Full MySQL SQL dialect support with ANSI SQL-92 compliance. All DML operations, stored procedure execution, prepared statements, and MySQL-specific features. Supports transactions and batch operations.
Authentication
Standard MySQL authentication with Username/Password. Supports SSL/TLS connections, SSH tunneling, and MySQL native authentication plugins. Connection properties include Host, Port, Database, Username, Password.
AI-assisted development with CData CLI
Build MySQL integrations faster with AI that understands your schema
Schema-aware AI
CData CLI gives AI coding tools access to your MySQL schema. No more guessing table names or column types—AI sees the same metadata in your ODBC Drivers.
Your AI Knows SQL
How to find table names, column names, and how to generate SQL syntax are things that AI knows well from millions of training data. No need for customization, no hallucinations. Your AI acts like a domain specialist to MySQL.
More Accurate, More Token-Efficient
With CData CLI's queryable schema detection and highly efficient queries with filters, aggregation, joins with correct pushdown, your AI will achieve more accuracy with less token usage.
FAQs
Frequently asked MySQL ODBC driver questions
Learn more about MySQL ODBC drivers for data and analytics integration
Download the MySQL ODBC Driver today!
Get the latest MySQL ODBC Drivers for Windows, Linux, and macOS. Install in minutes and connect your MySQL data to Power BI, Tableau, and more.
Download MySQL ODBC Driver
Please select from the following download options:
Windows