CData Connect offers an unparalleled level of connectivity and flexibility. With CData Connect, you have a single point of access to all your data in real-time. This page outlines the technology and features offered by CData Connect.

Broad Data Connectivity

CData Connect is a cloud application that provides real-time data connectivity to your data sources. Any data-centric application can use CData Connect to read and write data from a connected source, including tools for the following categories:

  • Business intelligence (BI) and analytics applications
  • Extract, Transform, and Load (ETL) and data movement
  • Data warehousing
  • Data governance
  • Master data management
  • Data integration

Real-Time Data Access

CData Connect provides live, real-time data connectivity to enterprise SaaS, NoSQL, and Big Data sources through standard interfaces that are widely supported by every data-centric application.

CData Connect key features include the following:

  • Does not require software installation, driver configuration, or database use
  • Is compatible with a large selection of data applications
  • Enables you to read, write, and update live data
  • Contains rich metadata-discovery features
  • Provides support for on-premise-to-cloud, cloud-to-on-premise, and cloud-to-cloud connectivity

Centralized Connectivity

CData Connect brings all your data into a central point of integration in the cloud. This integration provides the following benefits:

  • All account credentials can be managed in one place. This capability eliminates the need for IT to distribute and maintain credentials to different users in your organization.
  • You have granular control over permissions. You can restrict permissions for specific users without having to create multiple accounts in each data source.
  • Client Tools only need one connection to CData Connect to access all your data sources.

Robust SQL Support

  • String, Date, Numeric SQL Functions
    A library of over 50 included functions can manipulate column values into the results that you want. Popular examples include Regex, JSON, and XML processing functions.
  • Comprehensive Query Processing
    CData Connect leverages the same enterprise-class query engine as CData Software’s drivers. This engine enhances the capabilities of data sources with additional client-side processing (when it is needed) to enable analytic summaries of data (for example, SUM, AVG, MAX, MIN, and more).
  • Enterprise-Class Secure Connectivity
    CData Connect includes standard enterprise-class security features, such as TLS/SSL data encryption for all client-server communications.
  • Metadata Discovery
    CData Connect supports metadata discovery for supported data sources. Data types are returned as standard database types, which facilitates data operations from within BI, ETL, and reporting platforms.