Supported APIs
Skyvia Connect supports the open standard OData protocol and custom web SQL API for the endpoints.

SQL Endpoints
Create SQL endpoints that offer API for remote SQL command execution over the web. This web API allows sending SQL commands and their parameters over HTTP, obtaining the returned data in JSON format, querying the data source information and metadata.

You can either create your own clients for our easy-to-consume SQL API, or download our client libraries with widely used interfaces - ADO.NET provider and ODBC driver for Skyvia Connect.

OData Endpoints
Create OData endpoints, either simply by selecting source tables to publish, or by advanced configuration of entities and their relations on the diagram. Customize OData entity and property naming, entity keys, and associations between them if needed.

Skyvia Connect endpoints offer both read and write data access. Support for various OData query features and all OData versions ensures high compatibility with various OData consumer applications.

Connectivity

• Wide Connector Choice
  • Connect to different data sources, including various cloud applications, databases, and cloud data warehouses.
• Uniform Access to Cloud Data
  • Work with data of different cloud applications with different API in a uniform way via the same APIs.
• Easy Access to On-Premise Data
  • Connect to local data sources without re-configuring firewall, port-forwarding and other network settings via secure Agent application.

Additional Security Layer
Skyvia Connect offers an additional security layer for endpoints via basic HTTP authentication and restricting access by IP addresses. You can create user accounts with passwords for them, and you don't need to provide your data source credentials when publishing data.

Detailed Logging
All the endpoint requests are logged on Skyvia, so you can easily analyze query execution performance, error messages, traffic spent, etc. You can view log for a period you need, easily narrow down the period, filter requests by status or view details of each separate request.