CData provides custom plugins and drivers to connect popular Client Tools to your data sources in CData Connect. For Client Tools that do not have these custom plugins or drivers, you can connect to your data through the endpoints outlined below.

REST API

CData Connect provides a full-featured REST API that allows any REST-compatible application or client tool capable of creating HTTP requests to query data, perform batch operations, and execute stored procedures across all data sources configured in your account. The top API is based on a JSON-formatted API.

OData

OData is the CData Connect Open Data Protocol. Through the CData Connect virtual datasets feature, you can customize the data you surface to Client Tools and create a single endpoint for any client tool that supports OData connections.

Refer to the OData overview page for more information about configuring and using the OData protocol.

Virtual SQL Server

CData’s Virtual SQL Server implements the Tabular Data Stream (TDS) protocol. It emulates a standard SQL server and allows you to query your data like any other SQL source. Virtual SQL server endpoints are available by using virtual datasets in CData Connect. The default Virtual SQL server allows access to all tables, but you can connect to a workspace if you want to restrict access to a specific number of data assets.