ANY DATA SOURCE, AS A VIRTUAL DATABASE

SQL Access to Cloud Data


The CData Cloud Hub provisions a virtual MySQL/SQL server where each database represents one of the 100+ Enterprise Data Sources.





MySQL Access to Cloud Data Sources


Write SQL, Get Data

Powerful SQL abstraction simplifies connectivity and decouples data access.

SQL / MySQL Wire Protocol

Use any application or driver that can communicate with MySQL or SQL Server.

Full CRUD Support

Bi-directional data access with full Read, Write, Update, and Delete support.

Enterprise-Class Security

Advanced Security and Authentication. Secure TLS/ SSL data encryption.



How Does It Work?

Configuring CData Cloud Hub to create data connections.

The CData Cloud Hub allows users to connect to data from any cloud application or databases through standard database access. With the CData Cloud Hub supported data sources are configured to look and behave like a standard MySQL databases.

When you sign up to use the CData Cloud Hub you are given a private virtual database server instance. (e.g. yourinstance.cdatacloud.net). To your applications, your instance of CData Cloud Hub looks exactly like an instance of MySQL or SQL Server.

To interact with new cloud applications and databases users create new connections (virtual databases) through standard DDL statements. For example : CREATE DATABASE Salesforce1 as ... will create a new virtual Salesforce database that can be used by any application that supports SQL/MySQL to interact with live Salesforce data in real-time.

   
myinstance.cloudhub.net
-----------------------

MYSQL> CREATE DATABASE salesforce
  DRIVER='Salesforce',
  DBURL='User=test@cloudhub.com;
    Password=p4ssw0rd;'

Read/Write/Update Cloud Data

SQL-based data access to cloud data. Just like any SQL/MySQL database


After creating a new connection the CData Cloud Hub acts like a data gateway, translating SQL and securely proxying requests to data source APIs.



Robust SQL Support

Full-featured and consistent SQL access to any supported data source


  • Wire-compliant with MySQL and SQL Server

    The CData Cloud Hub is wire-compliant with MySQL and SQL Server (TDS), meaning that connecting to the the cloud service is as easy as connecting to any MySQL/SQL database. Any standard application or driver that can communicate with MySQL or SQL Server can be used to connect.

  • Unicode, 32-bit and 64-bit support

    32-bit and 64-bit applications and unicode APIs.

  • Certified Compatibility

    Our drivers undergo extensive testing and are certified to be compatible with leading analytics and reporting applications like Tableau, Microsoft Excel, and many more.

    * Please visit our knowledge base to access how-to articles.
  • Intelligent Query Folding

    Queries are intelligently parsed to determine how much of the request can be passed to the underlying data source APIs. The Cloud Hub optimizes performance, passing off as much processing as possible to the requested data source. Whatever functions cannot be handled by the data source are handled internally through our proprietary SQL engine.

  • String, Date, Numeric SQL Functions

    The CData Cloud Hub includes a library of 50 plus functions that can manipulate column values into the desired result. Popular examples include Regex, JSON, and XML processing functions.

  • Collaborative Query Processing

    The Cloud Hub leverages the same enterprise-class query engine as our drivers, enhancing the data source's capabilities with additional client-side processing, when needed, to enable analytic summaries of data such as SUM, AVG, MAX, MIN, etc.

  • Enterprise-class Secure Connectivity

    Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.

  • Metadata Discovery

    Supports metadata discovery for supported data sources. Data types are returned as standard database types facilitating data operation from BI, ETL & Reporting.

Connectivity from On-Premise or Cloud BI, ETL, & Reporting






MySQL & SQL connectivity are the most widely supported interfaces for connecting applications with data. The CData Cloud Hub enables direct connectivity from any applications that support standard database connectivity, including popular cloud BI and ETL applications, such as:

  • Amazon Glue
  • Amazon QuickSight
  • Domo
  • Google Apps Script
  • Google Cloud Data Flow
  • Google Cloud Data Studio
  • Looker
  • Microsoft Power Apps
  • Microsoft Power Query
  • MicroStrategy Cloud
  • Qlik Sense Cloud
  • SAP Analytics Cloud
  • SAS Cloud
  • SAS Viya
  • Tableau Online
  • ... and many more!

Frequently Asked Questions

Common questions about CData Cloud Hub




 What types of applications can connect with CData Cloud Hub?

The Cloud Hub is a general purpose data pipeline that provides real-time access to data from any supported data source. Any data-centric application can use the CData Cloud Hub to read and write data from a connected source, including popular BI & Analytics applications, ETL Tools and data movement products, Data Virtualization, Data Warehousing, Data Governance, Master Data Management, and Data Integration tools.

The Cloud Hub is uniquely suited for applications without fully-baked or accessible extensibility models, that still support database (SQL/MySQL) integration.

 Why wouldn't I use Drivers for direct connectivity?

In many cases, the CData Drivers will provide a better experience. For starters, the CData Drivers offer direct, fully-integrated point-to-point connectivity. In addition, the drivers run on your hardware, allowing granular user control of performance.

However, the CData Drivers require installation into a host application, or on a host system. There are many instances where users do not have access to install drivers. The CData Cloud Hub piggybacks on the universal support for standard database wire protocols (like MySQL) to enable connectivity from applications where additional driver installation is otherwise impossible. For example, cloud analytics applications like Tableau Cloud, SAP Analytics Cloud, Google Data Studio, etc. can all connect to MySQL, and consequently can leverage the CData Cloud Hub to connect to any of the supported 100+ Data Sources.

Also, the Cloud Hub provides a single managed installation supporting multiple data sources. When underlying APIs change or evolve, there is no need to install a new driver; the managed Cloud Hub is updated automatically with support for the latest API changes.

 What about data storage?

The CData Cloud Hub behaves like a proxy, translating SQL/MySQL queries into API calls, and returning that data to the requesting application. The Cloud Hub acts only as a passthrough and does not store any data itself.

 Can you add new seats to a subscription contract?

Absolutely. New licenses or additional seats may be added at any time.

 How does performance measure up?

Powered by the same blazing SQL engine that powers all of our drivers, the CData Cloud Hub boasts similar high-performance capabilities, such as query-folding, bulk loading, and collaborative query processing. These features ensure the absolute best data access performance with the smallest wire footprint.

 How do you manage security?

The CData Cloud Hub supports enterprise-class secure communications from end-to-end. All wire protocol connections between your applications and the Cloud Hub require strong SSL/TLS encrypted connection, and the communications from the data hub and a cloud data source are encrypted to the highest level supported by that source (typically SSL).

With regards to user management, the Cloud Hub leverages the same user creation and identity management facilities that are available in MySQL/SQL. Users and roles can be created and defined with a managed set of permissions to access limited virtual data resources.

Physical Security is strictly managed and maintained by our cloud service provider. For additional details and complete security documentation, please contact us.

 Are there plans to support other wire protocols beyond MySQL & SQL (TDS)?

Absolutely. In addition to MySQL and SQL, our engineering teams are actively working on support for other wire database protocols like Postgres and HTTP-based protocols like OData. If you are interested in support for additional protocols or integration methods, please let us know, and we can discuss further options.

 Do you support a common 'data model' across applications?

Our goal with data source connectivity has always been to present as much data as possible from the data sources that we expose. Database constructs like tables and views contain rich metadata about the connected data source and are very easy to work use. A common data model limits the ability to access data that does not fit the predefined model. Customers interested in a common data model can use the Cloud Hub to replicate data to a destination like Microsoft Common Data Service.

 We love the Cloud Hub concept but want to manage a private instance. Is this possible?

Absolutely. Our Data Hub has been designed for private consumption and supports multiple delivery models. In addition to a common managed instance, we support additional deployment options, including:

  1. Private Managed Instance (Our Cloud)
  2. Virtual Deployment (Your Cloud)
  3. Packaged Deployment (Packaged Software)

For additional details about these options, please contact a member of our team and we will discuss your requirements.

 Is it possible to OEM / Whitelabel CData Cloud Hub?

Yes - the CData Cloud Hub is designed for embedding and can be easily integrated. For additional details, please reach out to our OEM partnership team and we will get back to you about integration opportunities.





Questions? Our Team Is Here To Help


Ready to unlock the world of BI, Analytics, ETL, and Reporting for your data? Let us know and a member of our team will get back to you to discuss your integration challenges.


Contact Us