SQL Access to Cloud Data

CData Connect provisions a virtual MySQL/SQL server where each database represents one of the 100+ enterprise data sources.

MySQL/SQL/OData 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 Connect to create data connections.

CData Connect allows users to connect to data from any cloud application or database through standard database access. With CData Connect, supported data sources are configured to look and behave like a standard MySQL database.

When you sign up to use CData Connect, you are given a private virtual database server instance. (e.g. To your applications, your instance of CData Connect 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.


Read/Write/Update Cloud Data

SQL-based data access to cloud data, just like any SQL/MySQL database

Connections can be made through the web UI or through standard database tools like MySQL workbench. CData Connect acts like a data gateway, translating SQL and securely proxying API requests.

Robust SQL Support

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

  • Wire-Compliant with MySQL and SQL Server

    CData Connect 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 CData Connect 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

    CData Connect 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 CData Connect 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 operations from within BI, ETL & reporting platforms.

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

MySQL & SQL connectivity are the most widely supported interfaces for connecting applications with data. CData Connect enables direct connectivity from any application that supports 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!

Popular CData Connect Integrations

Frequently Asked Questions

Common questions about CData Connect

 What types of applications can connect with CData Connect?

CData Connect 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 Connect 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.

CData Connect 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 some cases, the CData Drivers may 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. CData Connect 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 CData Connect to connect to any of the supported 100+ Data Sources.

Also, CData Connect 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 CData Connect is updated automatically with support for the latest API changes.

 What about data storage?

CData Connect behaves like a proxy, translating SQL/MySQL queries into API calls, and returning that data to the requesting application. CData Connect 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, CData Connect 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?

CData Connect supports enterprise-class secure communications from end-to-end. All wire protocol connections between your applications and CData Connect 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, CData Connect 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 with. 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 CData Connect to replicate data to a destination like Microsoft Common Data Service.

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

Absolutely. CData Connect 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 Connect?

Yes - CData Connect 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