DataDirect Connectors Hybrid Data Connectivity for MySQL CE

My_SQL
  • With support for MySQL Connector/J, our solution can connect to a range of MySQL-compatible data sources, including MariaDB, Drizzle, Percona, MemSQL, Webscale, InfoBright, Amazon RDS, Aurora, InfiniDB, OurDelta, Clustrix, Google Cloud SQL and others
  • Expose your MySQL Data through standard SQL/REST interfaces - ODBC, JDBC or OData
  • Integrate any cloud or on-premises application - even those behind the firewall - with MySQL Community Edition based data sources
Table of Contents:

    Features

    One-Click Docker Image

    A docker image of Hybrid Data Pipeline Server has been made available for download to make it extremely simple for you to install and evaluate our offering. Quick Tutorial


    Lightweight Data Gateway

    Access back-office data behind the firewall securely using our patented on-premises connector that can be optionally deployed in the DMZ or behind the corporate firewall. Get trusted hybrid data access without requiring major network/firewall configurations such as setting up a VPN or SSH tunneling.

    Horizontal Scaling

    Hybrid Data Pipeline can be deployed in cloud and enterprise environments across multiple nodes behind a load balancer. Product has been architected to seamlessly integrate with both AWS load balancer and Azure load balancer.

    Universal Connectivity

    Get real-time connectivity to the latest SaaS, SQL, Big Data and NoSQL data sources such as Salesforce, Apache Hive, Amazon Redshift, Oracle, SQL Server, IBM DB2, Eloqua, Google Analytics and more.

    SeeHide supported data sources
    Third Party JDBC Support

    Hybrid Data Pipeline version 4.5 now supports the use of third party JDBC drivers.  The drivers can be configured as data sources to work with the server or via the on-premises connector.  Connectivity using OData, JDBC or ODBC are all viable options when using third party drivers.  This will broaden the connectivity choices that our customers need.


    Secure

    All customer-sensitive data elements (including remote credential or database pairings stored) are protected by encryption, both at rest (AES-256) and in transit. Our encryption algorithms can be made FIPS-140 compliant using the FIPS Compliance mode (leverages Bouncy Castle as the security provider).  In addition, Hybrid Data Pipeline version 4.5 now features IP Whitelisting to provide an additional layer of security. Read our security paper.


    OAuth 2.0 and Other Authentication Systems

    Hybrid Data Pipeline inherently supports OAuth 2.0 and Basic Authentication. It also offers an easy way to support other external authentication mechanisms so that enterprises can verify users against their in-house authentication systems that may be using LDAP system, Windows (Kerberos), SAML/ADFS or any other authentication service. You can even group multiple external authentication users to map to one Hybrid Data Pipeline user to get access to data sources.

    Throttling

    Limits API allows administrators to set limits on how many rows can be returned for ODBC, JDBC, and OData requests. An error is returned if an application fetches rows beyond the specified limit.

    Data APIs over HTTPS

    A data API management layer provides standard SQL (ODBC, JDBC) or REST (OData) interfaces to support the needs of the new technical data consumers - data engineers, data scientists and business analysts.


    Technical Specifications

    Progress DataDirect Hybrid Data Pipeline

    Data Store Support

    • Hybrid Data Pipeline does not provide a driver for the MySQL Community Edition data store. MySQL Connector/J 5.1 must be used to support the MySQL Community Edition data store. Therefore, you should refer to the MySQL Connector/J 5.1 documentation for information on supported versions of MySQL Community Edition.

    Interface Support

    • ODBC 3.52
    • JDBC 4.0 and earlier
    • Java SE 5 or higher

    Operating System Support

    • Microsoft Windows, Linux, HP-UX, AIX, Solaris and more

    Platform Support

    • Supports both 32-bit and 64-bit applications

    SQL Version

    • ANSI SQL-92 compliant

    On-Premise Connector

    • Windows Vista and higher
    • Windows Server 2008 and higher

    Documentation

    Progress Hybrid Data Pipeline Documentation

    Security Vulnerability Response Policy

    Upon identification of any security vulnerability, Progress will exercise commercially reasonable efforts to address the vulnerability in accordance with the following policy

    Priority* Time Guideline Version(s)
    High Risk
    (CVSS 8+ or industry equivalent)
    30 days Active (i.e. latest shipping version) and all Supported versions
    Medium Risk
    (CVSS 5-to-8 or industry equivalent)
    180 days Active (i.e. latest shipping version)
    Low Risk
    (CVSS 0-to-5 or industry equivalent)
    Next major release or best effort Active (i.e. latest shipping version)

    * Priority is established based on the current version of the Common Vulnerability Scoring System (CVSS), an open industry standard for assessing the severity of computer system security vulnerabilities. For additional information on this scoring system, refer to https://en.wikipedia.org/wiki/CVSS.


    Related Resources

    10_reasons_you need_high_performance

    IN THE SPOTLIGHT

    Top 10 Reasons You Need High-Performance Data Connectivity

    Data Connectivity is a critical, but often overlooked component of the IT infrastructure. These components have dramatic effects on application performance, reliability and portability. Learn about for your business.

    Download the Flyer
    Hybrid Connectivity Services

    IN THE SPOTLIGHT

    Learn how DataDirect’s Hybrid Connectivity Services solve the biggest integration challenges

    1. Keep up with data access needs to all latest SaaS sources
    2. Access data from behind the firewall
    3. Democratize your data stored in your home-grown apps

      Explore Hybrid Connectivity Solutions
    bg-air-dci-revamp
    MySQL Community Edition Connectors are Part of Progress Data Connectivity & Integration Solutions
    icon-info-b

    DataDirect Connectors

    Connect any data source to any application

    icon-contact-us-b

    Contact Us

    A product specialist will be glad to get in touch with you