Technology
Technology
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.