MySQL Integration
 

MySQL Drivers & Connectors for Data Integration

Easy-to-use wire-protocol Drivers for accessing MySQL-compatible databases. Easily integrate MySQL data with BI, Reporting, Analytics, ETL Tools, and Custom Solutions.


Decorative Icon MySQL Logo

Other Database Technologies

Other Database Drivers



Connect to MySQL Data from Anywhere!

Universal MySQL data integration. Easily access live MySQL data from BI, Analytics, Reporting, ETL, & Custom Apps.






MySQL Integration Guides and Tutorials

BI & Analytics


Our drivers offer the fastest and easiest way to connect real-time MySQL data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to MySQL data and metadata, and seamlessly integrate with your favorite analytics tools.

LEARN MORE: Connectivity for BI & Analytics

Popular BI & Analytics Integrations


Alteryx Designer: Prepare, Blend, and Analyze MySQL in Alteryx Designer (ODBC) Alteryx Designer: Work with Live MySQL Data in Alteryx Designer (Connect Cloud) Amazon QuickSight: Build Interactive Dashboards from MySQL Data in Amazon QuickSight Amazon SageMaker: Integrate Live MySQL data into Amazon SageMaker Canvas Aqua Data Studio: Connect to MySQL in Aqua Data Studio AWS Databricks: Process & Analyze MySQL Data in Databricks (AWS) Azure Analysis Services: Model MySQL Data Using Azure Analysis Services Birst: Build Visualizations of MySQL in Birst BIRT: Design BIRT Reports on MySQL Clear Analytics: Build Charts with MySQL in Clear Analytics Cognos Analytics (On-Prem): Analyze MySQL Data in Cognos Analytics DBxtra: Build Dashboards with MySQL in DBxtra Domo: Create Datasets from MySQL in Domo Workbench Dundas BI: Build Dashboards with MySQL in Dundas BI Excel (on Mac OS): Work with MySQL Data in MS Excel on Mac OS X FineReport: Feed MySQL into FineReport Gecokboard: Create Dashboards and Visualize Live MySQL Data in Geckoboard Google Sheets: Access Live MySQL Data in Google Sheets Grafana: Create MySQL-Connected Dashboards in Grafana IBM Cognos BI: Create Data Visualizations in Cognos BI with MySQL Infragistics Reveal: Analyze MySQL Data in Infragistics Reval JasperServer: Create MySQL Reports on JasperReports Server Jaspersoft BI Suite: Connect to MySQL in Jaspersoft Studio JReport Designer: Integrate with MySQL in JReport Designer Klipfolio: Create MySQL-Connected Visualizations in Klipfolio KNIME: Enable the MySQL JDBC Driver in KNIME LINQPad: Working with MySQL in LINQPad Looker: Analyze MySQL Data in Looker Looker Studio: Create Reports from MySQL Data in Looker Studio Metabase: Create Interactive MySQL-Connected Metabase Dashboards Microsoft Excel: Access Live MySQL Data in Excel Desktop Microsoft Excel for the Web: Access Live MySQL Data in Excel for the Web Microsoft SSAS: Build an OLAP Cube in SSAS from MySQL MicroStrategy: Connect to Live MySQL Data in MicroStrategy through Connect Cloud MicroStrategy: Use the CData JDBC Driver for MySQL in MicroStrategy Microstrategy Desktop: Use the CData JDBC Driver for MySQL in MicroStrategy Desktop Microstrategy Web: Use the CData JDBC Driver for MySQL in MicroStrategy Web Mode Analytics: Create MySQL-Connected Visualizations in Mode OBIEE: MySQL Reporting in OBIEE with the MySQL JDBC Driver pandas: Use pandas to Visualize MySQL in Python Pentaho Report Designer: Integrate MySQL in the Pentaho Report Designer Power BI Desktop: Author Power BI Reports on Real-Time MySQL Power BI Service: Visualize Live MySQL Data in the Power BI Service Power Pivot: Access MySQL Data in Microsoft Power Pivot Power Query: Access MySQL Data in Microsoft Power Query Qlik Cloud: Create Apps from MySQL Data in Qlik Sense Cloud QlikView: Connect to and Query MySQL in QlikView over ODBC R: Analyze MySQL in R (JDBC) R: Analyze MySQL in R (ODBC) RapidMiner: Connect to MySQL in RapidMiner Redash: Query, Visualize, and Share live MySQL Data in Redash SAP Analytics Cloud: Analyze MySQL Data in SAP Analytics Cloud SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for MySQL SAP Crystal Reports: Publish Reports with MySQL in Crystal Reports (JDBC) SAP Crystal Reports: Publish Reports with MySQL in Crystal Reports (Connect Cloud) SAS: Use the CData ODBC Driver for MySQL in SAS for Real-Time Reporting and Analytics SAS JMP: Use the CData ODBC Driver for MySQL in SAS JMP SAS Viya: Analyze Live MySQL Data in SAS Viya Sisense: Visualize Live MySQL in Sisense Spago BI: Connect to MySQL in SpagoBI Tableau: Visualize MySQL in Tableau Desktop Tableau: Visualize MySQL in Tableau Desktop (Connect Cloud) Tableau Cloud: Build MySQL Visualizations in Tableau Cloud Tableau Server: Publish MySQL-Connected Dashboards in Tableau Server ThoughtSpot: Model, Search, and Visualize Live MySQL Data in ThoughtSpot TIBCO Spotfire: Visualize MySQL in TIBCO Spotfire through ADO.NET TIBCO Spotfire Server: Operational Reporting on MySQL from Spotfire Server Visio: Link Visio Shapes to MySQL Zoho Analytics: Create MySQL-Connected Dashboards in Zoho Analytics

ETL, Replication, & Warehousing


From drivers and adapters that extend your favorite ETL tools with MySQL connectivity to ETL/ELT tools for MySQL data integration — our MySQL integration solutions provide robust, reliable, and secure data movement.

Connect your RDBMS or data warehouse with MySQL to facilitate operational reporting, offload queries and increase performance, support data governance initiatives, archive data for disaster recovery, and more.


Popular Data Warehousing Integrations


Airbyte: Connect to MySQL Data in Airbyte ELT Pipelines Amazon Redshift: Automated Continuous MySQL Replication to Amazon Redshift Amazon S3: Automated Continuous MySQL Replication to Amazon S3 Apache Airflow: Bridge MySQL Connectivity with Apache Airflow Apache Camel: Integrate with MySQL using Apache Camel Apache Cassandra: Automated Continuous MySQL Replication to Apache Cassandra Apache Kafka: Automated Continuous MySQL Replication to Apache Kafka Apache NiFi: Bridge MySQL Connectivity with Apache NiFi Apache NiFi Batch Operations: Perform Batch Operations with MySQL Data in Apache NiFi AWS Glue: Build ETL Jobs with MySQL Data in AWS Glue Jobs Azure Data Factory: Import MySQL Data Using Azure Data Factory Azure Data Lake: Automated Continuous MySQL Replication to Azure Data Lake Azure Synapse: Automated Continuous MySQL Replication to Azure Synapse BIML: Use Biml to Build SSIS Tasks to Replicate MySQL to SQL Server CloverDX: Connect to MySQL in CloverDX (formerly CloverETL) Couchbase: Automated Continuous MySQL Replication to Couchbase CSV: Automated Continuous MySQL Replication to Local Delimited Files Databricks: Automated Continuous MySQL Replication to Databricks ETL Validator: How to Work with MySQL in ETL Validator FoxPro: Work with MySQL in FoxPro Google AlloyDB: Automated Continuous MySQL Replication to Google AlloyDB Google BigQuery: Automated Continuous MySQL Replication to Google BigQuery Google Cloud SQL: Automated Continuous MySQL Replication to Google Cloud SQL Google Data Fusion: Build MySQL-Connected ETL Processes in Google Data Fusion Google Data Fusion: Build Pipelines with Live MySQL Data in Google Cloud Data Fusion (CData Connect Cloud) Heroku / Salesforce Connect: Replicate MySQL for Use in Salesforce Connect HULFT Integrate: Connect to MySQL in HULFT Integrate IBM DB2: Automated Continuous MySQL Replication to IBM DB2 Informatica Cloud: Integrate MySQL in Your Informatica Cloud Instance Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for MySQL Jaspersoft ETL: Connect to MySQL in Jaspersoft Studio Microsoft Access: Automated Continuous MySQL Replication to Microsoft Access Microsoft Azure Tables: Automated Continuous MySQL Replication to Azure SQL Microsoft Excel: Transfer Data from Excel to MySQL Microsoft Power Automate: Build MySQL-Connected Automated Tasks with Power Automate (Desktop) Microsoft OneLake: Automated Continuous MySQL Replication to Microsoft OneLake (Fabric} MongoDB: Automated Continuous MySQL Replication to MongoDB Oracle Data Integrator: ETL MySQL in Oracle Data Integrator Oracle Database: Automated Continuous MySQL Replication to Oracle Pentaho Data Integration: Integrate MySQL in Pentaho Data Integration petl: Extract, Transform, and Load MySQL in Python PostgreSQL: Automated Continuous MySQL Replication to PostgreSQL SAP HANA: Automated Continuous MySQL Replication to SAP HANA SingleStore: Automated Continuous MySQL Replication to SingleStore SnapLogic: Integrate MySQL with External Services using SnapLogic (JDBC) SnapLogic: Integration with MySQL Data in SnapLogic (Connect Cloud) Snowflake: Automated Continuous MySQL Replication to Snowflake SQL Server: Automated Continuous MySQL Replication to SQL Server SQL Server Linked Server: Connect to MySQL Data as a SQL Server Linked Server SQLite: Automated Continuous MySQL Replication to SQLite Talend: Connect to MySQL and Transfer Data in Talend UiPath Studio: Create an RPA Flow that Connects to MySQL in UiPath Studio Vertica: Automated Continuous MySQL Replication to a Vertica Database Workato: Build Automated Workflows with Live MySQL Data in Workato Zapier: Build Automated MySQL-Connected Workflows in Zapier

Workflow & Automation Tools


Connect to MySQL from popular data migration, ESB, iPaaS, and BPM tools.

Our drivers and adapters provide straightforward access to MySQL data from popular applications like BizTalk, MuleSoft, SQL SSIS, Microsoft Flow, Power Apps, Talend, and many more.

Popular Workflow & Automation Tool Integrations


Blue Prism: Integrate Live MySQL Data for Intelligent Robotic Process Automation MuleSoft Anypoint: Access MySQL in Anypoint Using SQL Nintex Workflow Cloud: Build MySQL-Connected Workflows in Nintex Power Automate: Integrate MySQL Data into Power Automate Automated Tasks SSIS Export: Export Data from SQL Server to MySQL through SSIS SSIS Import: Import MySQL Data into SQL Server using SSIS SSIS Lookup: Insert New or Update Existing MySQL Records from SQL Server

Developer Tools & Technologies


The easiest way to integrate with MySQL from anywhere. Our MySQL drivers offer a data-centric model for MySQL that dramatically simplifies integration — allowing developers to build higher quality applications, faster than ever before. Learn more about the benefits for developers:



Popular Developer Integrations


AWS Lambda: Access Live MySQL Data in AWS Lambda Axios: Build MySQL-Connected Web Apps with Axios and CData Connect Cloud .NET Charts: DataBind Charts to MySQL .NET QueryBuilder: Rapidly Develop MySQL-Driven Apps with Active Query Builder Apache Spark: Work with MySQL in Apache Spark Using SQL AppSheet: Create MySQL-Connected Business Apps in AppSheet Bubble.io: Build MySQL-Connected Apps in Bubble C++Builder: DataBind Controls to MySQL Data in C++Builder Choreo: Build Custom Apps on MySQL Data in Choreo ColdFusion: Query MySQL in ColdFusion Using JDBC ColdFusion: Query MySQL in ColdFusion Using ODBC Dash: Use Dash & Python to Build Web Apps on MySQL Delphi: DataBind Controls to MySQL Data in Delphi DevExpress: DataBind MySQL to the DevExpress Data Grid EF - Code First: Access MySQL with Entity Framework 6 EF - LINQ: LINQ to MySQL EF - MVC: Build MVC Applications with Connectivity to MySQL Filemaker Pro: Bidirectional Access to MySQL from FileMaker Pro Filemaker Pro (on Mac): Bidirectional Access to MySQL from FileMaker Pro (on Mac) Go: Write a Simple Go Application to work with MySQL on Linux Google Apps Script: Connect to MySQL Data in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with MySQL Entities in Java IntelliJ: Connect to MySQL in IntelliJ JBoss: Connect to MySQL from a Connection Pool in JBoss JDBI: Create a Data Access Object for MySQL using JDBI Jitterbit: Integrate with Live MySQL Data in Jitterbit JRuby: Connect to MySQL in JRuby Lazarus IDE: Easily Integrate MySQL Data in Lazarus Pascal IDE Mendix: Build MySQL-Connected Apps in Mendix (Connect Cloud) Mendix: Build MySQL-Connected Apps in Mendix (JDBC) Microsoft Power Apps: Integrate Live MySQL Data into Custom Business Apps Built in Power Apps OutSystems: Create MySQL-Connected Enterprise Applications in OutSystems PowerBuilder: Connect to MySQL from PowerBuilder PowerShell: Pipe MySQL to CSV in PowerShell PyCharm: Using the CData ODBC Driver for MySQL in PyCharm Python: Connect to MySQL in Python on Linux/UNIX Retool: Build MySQL-Connected Apps in Retool Ruby: Connect to MySQL in Ruby RunMyProcess: Connect to MySQL Data in RunMyProcess RunMyProcess DSEC: Connect to MySQL in DigitalSuite Studio through RunMyProcess DSEC Servoy: Build MySQL-Connected Apps in Servoy Spring Boot: Access Live MySQL Data in Spring Boot Apps SQLAlchemy: Use SQLAlchemy ORMs to Access MySQL in Python Tomcat: Configure the CData JDBC Driver for MySQL in a Connection Pool in Tomcat Unqork: Create MySQL-Connected Applications in Unqork VCL App (RAD Studio): Build a Simple VCL Application for MySQL WebLogic: Connect to MySQL from a Connection Pool in WebLogic


When Only the Best MySQL Drivers Will Do

See what customers have to say about our products and support.



Frequently Asked MySQL Driver Questions

Learn more about MySQL drivers & connectors for data and analytics integration


Many organizations draw attention to their library of connectors. After all, data connectivity is a core capability needed for applications to maximize their business value. However, it is essential to understand exactly what you are getting when evaluating connectivity. Some vendors are happy to offer connectors that implement basic proof-of-concept level connectivity. These connectors may highlight the possibilities of working with MySQL, but often only provide a fraction of capability. Finding real value from these connectors usually requires additional IT or development resources.

Unlike these POC-quality connectors, every CData MySQL driver offers full-featured MySQL data connectivity. The CData MySQL drivers support extensive MySQL integration, providing access to all of the MySQL data and meta-data needed by enterprise integration or analytics projects. Each driver contains a powerful embedded SQL engine that offers applications easy and high-performance access to all MySQL data. In addition, our drivers offer robust authentication and security capabilities, allowing users to connect securely across a wide range of enterprise configurations. Compare drivers and connectors to read more about some of the benefits of CData's driver connectivity.

The MySQL drivers and connectors offer comprehensive access to MySQL data. Our MySQL driver exposes static and dynamic data and metadata, providing universal access to MySQL data for any enterprise analytics or data mangement use. To explore the MySQL driver data model, please review the edition-specific MySQL driver documentation.

Using the CData MySQL drivers and connectors, MySQL can be easily integrated with almost any application. Any software or technology that can integrate with a database or connect with standards-based drivers like ODBC, JDBC, ADO.NET, etc., can use our drivers for live MySQL data connectivity. Explore some of the more popular MySQL data integrations online.

Additionally, since MySQL supported by CData Connect Cloud, we enable all kinds of new MySQL cloud integrations.

MySQL Analytics and MySQL Cloud BI integration is universally supported for BI and data science. In addition, CData provides native client connectors for popular analytics applications like Power BI, Tableau, and Excel that simplify MySQL data integration. Additionally, native Python connectors are widely available for data science and data engineering projects that integrate seamlessly with popular tools like Pandas, SQLAlchemy, Dash, and Petl.

MySQL data integration is typically enabled with CData Sync, a robust any-to-any data pipeline solution that is easy to set up, runs everywhere, and offers comprehensive enterprise-class features for data engineering. CData Sync makes it easy to replicate MySQL data any database or data warehouse, and maintain parity between systems with automated incremental MySQL replication. In addition, our MySQL drivers and connectors can be easily embedded into a wide range of data integration tools to augment existing solutions.

Absolutely. The best way to integrate MySQL with Excel is by using the CData Connect Cloud Excel Add-In. The MySQL Excel Add-In provides easy MySQL integration directly from Microsoft Excel Desktop, Mac, or Web (Excel 365). Our integration offers live bi-directional access to MySQL data directly from Excel. Simply configure your connection to MySQL from the easy-to-use cloud interface, and access MySQL just like you would another native Excel data source.



Industry-Leading Support

Support is not just a part of our business, support is our business. Whenever you need help, please consult the resources below:

Product documentation
Get support