|
|
|
|
|
|
|
|
|
Publish your data via web API easily
Get ready-to-use API endpoints for any data source in minutes
API Server as a Service for Your Data
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 drag n drop->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.
How It Works
Get web API endpoints for your data in less than 2 minutes
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.
© Copyright 2000-2023 COGITO SOFTWARE CO.,LTD. All rights reserved
