Skip to main content
The API connector exposes tables, views, and stored procedures from a database as a web API. The API Connector reads the available tables, views, and stored procedures from the target database, then any subset of these can be exposed as API resources.

​
Key Capabilities

  • Exposes database tables, views, and stored procedures as RESTful web APIs
  • Automatic schema generation from database connections
  • Comprehensive API management with rate limiting and CORS support
  • Multiple authentication options and user management capabilities
  • Multiple output formats (JSON, XML, and CSV)
The following topics cover all aspects of the API connector:
  • Configure a Connector covers all of the configurable connector properties on each tab.
  • Establish a Connection explains how to connect to your data store.
  • Build Your First API explains how to use a wizard to generate schemas for reading and writing to your data store.
  • API Resources describes options related to managing resources.
  • API Actions describes example actions to extend the set of operations on resources and to execute unrelated actions on the server.
  • Query Your API covers how to expose your API resources to authorized users and IP addresses.
  • API Management covers discovery options, server responses, rate limiting and cross-origin resources sharing (CORS).
  • Authentication covers user management and authentication options.
  • Additional Output Formats describes how to use the other output formats supported by the API connector.
The API connector supports publishing custom APIs at a CData Arc endpoint. If you are looking for an API client to consume APIs, use the REST Connector instead.