Version 25.3.9469

• Key Capabilities

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.

Note: 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.