Instant APIs from any Database

Diagram of API Server data flow

Create APIs from existing enterprise data. Hook up any SQL or NoSQL database and the API Server instantly generates flexible, comprehensive, and fully documented APIs.


What is CData API Server?

Watch this video to learn what API Server can do for your data:

Build a REST API from your data with a few clicks

Database Icon

APIs from Any Source

Supports popular databases like SQL Server, MySQL, DB2, Mongo, Cassandra, Flat Files, etc.

Open Data Access Icon

Open Data Access

Expose entry-points for popular formats like OData, REST, JSON, SOAP, CSV/TSV, etc

API Management Icon

API Management

Includes critical API management features like monitoring, logging, rate limiting, etc.

Publish Icon

Publish To Any Platform

Publish APIs to any platform - on Intranets, public-facing servers, or in the Cloud!

Unleash the integration potential of your data.

The API Server is the fastest way to expose your data as a professional API. Whether your organization wants to leverage APIs as a growth catalyst to build an extensive third-party ecosystem, or your focus is building solutions for corporate IT, the API Server is for you.

  • Create fully-documented, discoverable APIs based-on OpenAPI.
  • Fine-grained control over security, user access, and API management features.
  • Enterprise-class security with strong SSL encryption, user management, and access control.
  • Extensible data access through JDBC & ADO.NET

Connect with Any Database

The API Server offers integration with popular relational and NoSQL DBs


API Enablement & Microservices for Database Access

Organizations are adopting APIs & Microservices for database access, to allow for greater performance, dependability, and scalability. Learn how enterprises achieve connectivity by establishing commonality between new and legacy systems and more.


Connect Apps, BI tools, & Other Systems

Instant Access from Power BI, Salesforce Lightning Connect, SharePoint, & more!

The API Server is a lightweight Web application that allows users to create and expose data APIs from data, without the need for custom development. Through simple point-and-click configuration, user can create and configure access from popular clients like Microsoft Power BI, Salesforce Lightning Connect, SharePoint External Lists, Excel, PowerPivot, and more.

Use CData API Server to:

  • Integrate with popular applications like Power BI, Salesforce Lightning Connect, Microsoft SharePoint.
  • Automate integration processes like mass imports / exports / updates, data cleansing & de-duplication.
  • Cache data locally and offload queries to reduce load and increase performance.
  • Expose internal resources securely across the firewall via embedded SSH Reverse Tunneling.

Professional APIs in Minutes

Whether your focus is on facilitating internal operations, partner integrations, or public data access, APIs are the key to increasing business agility and unlocking the true innovation potential of your data. The API Server is the tool you need to publish enterprise-ready REST APIs in minutes - no custom development required.

Configuration is simple:

  1. Connect to your Database / Data Source.
  2. Define security (authentication and permissions).
  3. Publish your API: Locally, or in the Cloud.

Connectivity Features

  • Connect through Standard Drivers. CData provides Drivers that make it simple to connect directly with the API Server from virtually anywhere.
  • Connect Through OData. The OData protocol is widely supported by developer tools and there are dozens of client libraries available for working with OData from .NET, Java, PHP, Objective-C, etc.
  • Connect Through JSON. Interact with data directly through JSON APIs. Web developers can interact through JSON and JSONp entry-points with zero client-side requirements beyond standard JavaScript.
  • Connect Through Other Modern Web APIs. Unmatched power and flexibility in integrating with other systems and applications. Many interfaces are accessible through simple standards-based protocols like SOAP, REST, HTML, ATOM, JSON, XLS, CSV, and More!
  • Secure Data Access. The API Server offers powerful security and access management capabilities including integrated transaction monitoring, management, and data access controls. All communications channels are secured by strong SSL security.
  • Highly Extensible Design. The API Server exposes dozens of services that are easily accessible through simple standards-based interfaces like SOAP, REST, HTML, RSS, ATOM, JSON, XLS, and CSV.
  • Bi-Directional Access to Live Data. The API Server offers full Create, Read, Update, Delete (CRUD) support for integrating with live back-end data.
  • Expose Data in Salesforce Lightning Connect enables the Salesforce CRM platform to connect to OData services and expose that data in Salesforce. The API Server is the simplest way to connect your back office systems with the Salesforce cloud platform.
  • Connect From SharePoint. SharePoint external lists can be configured to access data through OData services. With the API Server you can make and data source easily accessible from SharePoint and SharePoint Online.
  • Connect From Microsoft Power BI & Excel. Users can connect Microsoft Power BI directly to OData Sources. Specify the URL of the OData service created by the API Server, and the application will load data. The returned data can be processed and visualized by anyone - no developer required.
  • Integrated Data Caching Capabilities. Smart caching capabilities provide unmatched performance, enabling a highly responsive data access layer for client applications.
  • Entirely Self-Contained. No Additional Components Required. Run as a standalone Web Application, embedded within Microsoft IIS, or from any Java compatible Web Server for secure management from anywhere.
  • On-Premise, Or In The Cloud. Designed to perform equally well hosted on premise (Windows, Unix / Linux, Mac OS), or in the Cloud (Azure, Amazon, Google). Expose and connect-to data regardless of network topology, hardware, or software requirements.