Create OData and SQL endpoints for your data in less than 5 minutes with no coding, in convenient wizards. Obtain ready-to-use endpoint URLs with no need to care about hosting, maintenance and administration. Get built-in security layer and advanced access logging with no effort.

Get Ready-to-use OData API in 5 Minutes

Build API Easier with Skyvia Connect

Building API Manually

Develop service ->Care about security->Find hosting ->Register domain->Obtain certificate->Deploy->Administer and Maintain

Using Skyvia Connect

Visual design via dragndrop->Get ready-to-use and deployed OData endpoints

That’s all. We have already taken care about everything else...

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.

SQL Web API as a Service

SQL Gateway for remote access to cloud and database data

SQL Access to Any Data over the Web

Get API for SQL execution over the web with Skyvia Connect SQL endpoints. Connect over HTTP and retrieve the returned data in JSON format. No coding, no need to care about hosting and maintenance.

SQL endpoints allow using SQL against both cloud and database data and remotely connecting to on-premises databases with little to no configuration.

How It Works

Connect

Create a connection to the data you want to publish

Configure Security

Create user accounts/limit access by IP

Publish

Set endpoint name and get ready-to-use endpoint URL

Powerful SQL API

SQL endpoints provide easy-to-consume API that allow:

SQL Command Execution

Execute SQL commands with parameters against the data source

Fetching Data

Fetch returned data in pages in the JSON format

Querying Metadata

Obtain detailed information about data source objects and fields

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 ensure high compatibility with various OData consumer applications.

Share your data via OData REST API

Connect data consumers to various data sources via the cloud

OData API Layer for Your Cloud or Database Data

Instantly get OData REST API layer for your data with Skyvia Connect OData endpoints. Make your cloud and on-premises data available for a wide variety of OData consumer applications with no coding.

How It Works

Connect

Create a connection to the data you want to publish

Model

Add tables to publish via drag-n-drop. Customize relations, hide fields you don’t want to publish.

Publish

Configure IP and access settings and publish your data easily and safely.

Monitor

Be aware about all the access events for your endpoint with our advanced interactive log.

Highly Configurable OData Endpoints

All Configuration is Done Visually

OData Associations Support

Skyvia Connect can automatically generate OData associations based on source data relations/foreign keys, and you can edit them or add custom associations, if needed.

Customizable Entity Keys

You can easily define your own entity key, instead of the generated one, or specify an entity key for entity, generated from a database view.

Customizable Naming

Skyvia allows renaming entities, entity sets, properties and navigation properties.

Partial data sharing

Publish only data you want to publish, and exclude source columns you want to hide.

OData Protocol Support

Skyvia allows you to easily expose your SQL Server data via OData — RESTful API for data access and manipulation. OData is a widely accepted open standard for data access over the Internet.

Support for all OData versions
Writable OData endpoints
Support for ATOM and JSON format for returned data

How It Works

Get web API endpoints for your data in less than 2 minutes

Create a connection to the data you want to publish
Configure endpoint and set up security settings
Set endpoint name and get ready-to-use endpoint URL

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.

Use Cases

Salesforce Connect

Link data from any data source to Salesforce via OData using Salesforce Connect, and work with them in Salesforce like with usual Salesforce objects.

Web/Mobile Apps

Make any data easily available for web and mobile applications. See our tutorial on how to build such apps, consuming data via OData.

Excel

Microsoft Excel supports OData protocol, so Skyvia Connect enables you to quickly and easily get data from any data source supported to an Excel worksheet.

Quick Navigation;