Search

Technology

Version 22.0.8486

Technology

CData Connect offers an unparalleled level of connectivity and flexibility. This page outlines the technology and features offered by CData Connect.

Broad Data Connectivity

CData Connect provides real-time data connectivity to over 250 data sources. Any data-centric application can use CData Connect to read and write data from a connected source, including tools for:

  • BI & Analytics applications
  • 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.

Key features include:

  • Works with all of the data applications you use - out of the box
  • Read, write, and update live data
  • Rich metadata discovery features
  • Support for on-premise to cloud, cloud to on-premise, and cloud to cloud connectivity.

Centralized Connectivity

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

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

Robust SQL Support

  • ANSI SQL-92 Support CData Connect’s query API allows you to easily query data across any data source using standard SQL queries.
  • String, Date, Numeric SQL Functions A library of over 50 included functions can manipulate column values into desired results. Popular examples include Regex, JSON, and XML processing functions.
  • Comprehensive Query Processing CData Connect leverages the same enterprise-class query engine as our drivers. This engine enhances the capabilities of data sources with additional client-side processing (when needed) to enable analytic summaries of data, such as 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 & reporting platforms.

Query Federation

CData Connect lets you write queries that combine data from different sources directly, on-demand.

In many ad-hoc scenarios, it is impractical to build pipelines to consolidate data. With query federation, you don’t need to involve IT. You can simply create queries across data sources from the reporting tool of your choice.