Get firewall-friendly connectivity to any databases compatible with the MySQL wire protocol using standard interfaces of Hybrid Data Pipeline 4.1.
With release 4.1, Progress DataDirect Hybrid Data Pipeline supports MySQL Community Edition (CE). We now provide firewall-friendly on-premises connectivity over standard SQL (ODBC, JDBC), and REST (OData) to any databases that are compatible with the MySQL Client.
MySQL is the most popular open source RDBMS. MySQL, originally created by a Swedish company called MySQL AB, was first acquired by Sun Microsystems in 2008. MySQL later became a part of Oracle when Oracle bought Sun Microsystems in 2010.
During these acquisitions, the MySQL community began to worry about the future of MySQL. At this point, several active contributors started forking the project. The day Oracle announced the purchase of Sun Microsystems, Michael Widenius forked MySQL and launched MariaDB, taking a swath of MySQL developers with him. Some of the other major forks from the MySQL codebase are MySQL Community Edition, Percona Server, WebScale and Drizzle. All these forks support the MySQL wire protocol.
Thanks to MySQL's popularity, many other databases like MemSQL and are also designed to be compatible with MySQL Client/ MySQL wire protocol. This led to a huge ecosystem of databases that are based on MySQL Client. Going forward, we will refer to all these databases as “MySQL CE” in this blog to refer to all of these databases.
Until today, Hybrid Data Pipeline only supported the MySQL Enterprise Edition. With version 4.1, the solution supports the Community Edition as well, based on customer feedback. This means you can use the open source MySQL CE JDBC driver to plug into Hybrid Data Pipeline. Once you plug it in, you can:
As noted above, many are MySQL wire-compliant. So, you can now connect to any of these databases with Hybrid Data Pipeline:
Please note that this is just a part of the huge list of databases that support the MySQL wire protocol (MySQL Client).
In this release, we are also adding features that make Hybrid Data Pipeline even more robust:
Our hybrid connectivity services enable organizations like BOARD International (a visionary in the Magic Quadrant for CPM Suites) to expose their databases and securely access data behind customer firewalls. If you want to play with our product, you can easily register for a trial version and get started with our tutorials on AWS, Azure, Google, Digital Ocean or other clouds.
Nishanth Kadiyala is a Technical Marketing Manager at Progress. He got his B.Tech degree from IIT Guwahati and his MBA from UNC Chapel Hill. He has worked on several technologies including database designing, SQL querying and Cloud Computing in the past. Currently, he is committed to educating enterprises about standards based connectivity via ODBC, JDBC, ADO.NET and OData. He is also proficient with DataDirect Hybrid Connectivity Services – DataDirect Cloud and Hybrid Data Pipeline. You can stay in touch with him through Twitter.
Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.