OData REST API for Amazon Redshift
Restify Your Amazon Redshift Data via the Cloud
Restify Your Amazon Redshift Data via the Cloud
Need to expose Amazon Redshift database via REST API? Let Skyvia do it for you! Our cloud service allows you to almost instantly create Amazon Redshift database OData endpoint with and very little configuration required.
- Web API server for Amazon Redshift data in minutes with no coding - no need to create REST API for Amazon Redshift yourself.
- No need to care about hosting and maintenance.
- Connect your database to web and mobile applications, BI tools, Salesforce Connect, etc.
OData — More Than Just REST
Skyvia allows you to easily expose your Amazon Redshift data via OData — RESTful API for data access and manipulation. OData is a widely accepted open standard for data access over the Internet. It can be used for exposing any kind of data and is supported in a number of data-related applications and technologies.
OData Support by Skyvia Connect
- Support for all OData versions (OData 2.0, OData 4.0)
- Writable OData endpoints
- Support for ATOM and JSON format for returned data
OData Query Features Support
- Feature
- Number of records
- Querying specific fields
- Querying first records
- Paging
- Ordering data
- Querying joined tables
- Filtering data
- Aggregating data
- OData Keyword
- $count
- $select
- $top
- $top + $skip
- $orderby
- $expand
- $filter
- $apply=aggregate
Key Features
No Coding Required
Create a RESTful OData service for your Amazon Redshift database in minutes without a line of code! Expose your tables via drag-n-drop, include or exclude fields visually, and Skyvia Connect will take the rest.
Built-in Security Layer
You don’t need to give credentials to the exposed Amazon Redshift database. Instead define user names and passwords to your OData endpoint on the Skyvia side. If this is not enough, you can also limit access to the allowed IPs and IP ranges.
Detailed Logging
Skyvia logs all connections to your Connect OData services with user accounts and IP addresses, all their requests and queries. Whenever necessary you can monitor which users access your data and what they do with them.
How It Works
Connect
Create a connection to your Amazon Redshift.
Configure Endpoint
Select entities and fields to expose in convenient GUI. If necessary, create user accounts and specify IPs to allow access from.
Share the Link
Simply copy the result HTTPS link to your endpoint and share it with clients or paste to your OData consumer applications.
Share Amazon Redshift data easily