Produced by Devart
All-In-One Web Service for
Cloud Data Integration, Backup and Management
Skyvia Platform
Integrate your data quickly and easily with no coding
In Skyvia, you create integration packages that define the operations and schedule them for automatic execution or run them manually.
Packages including:
Keep your data safe with automatic daily and anytime manual backups
Skyvia offers powerful backup and restore functionality for cloud application data.
It allows performing automatic daily backup and anytime manual backup. Backed-up data can be accessed whenever you need it. You can view backed-up data directly in the browser or export them to CSV files. Additionally, Skyvia allows the search of the whole backup history and finds necessary records whenever they are backed up.
Skyvia offers few-clicks-restore functionality. You can select what data to restore or what data changes to undo, and Skyvia restores them automatically without tinkering with CSV files or third-party tools. You can restore whole tables, separate records, or fields when necessary.
Query your data from web browser via visual query builder or SQL
Skyvia includes a cloud SQL client that allows executing SQL statements against relational databases and cloud applications. Powerful Query Builder allows building queries visually without the need to know SQL. The result data can be exported to a CSV or PDF file.
Frequently used queries can be saved for future use in the Query Gallery. Query gallery already contains a number of predefined queries for common use cases for each supported data source.
Skyvia allows not just selecting data but also performing DML statements. Thus, you can use Skyvia as a tool for mass cloud data updates.
It also allows querying data directly in Google Sheets, using the Skyvia Query Google Sheets Add-on.
Connect various data sources with different data-related applications
Skyvia offers a connectivity-as-a-service solution. It helps connecting data stored in various cloud applications and databases to data consumer applications, such as BI tools, office suites, etc. via the Internet. Skyvia connects to various data sources via their custom interfaces and provides unified web API for their data.
Skyvia allows creating OData endpoints, implementing the standard and widely accepted OData protocol, and SQL endpoints using custom API for SQL execution over the web.
You can configure endpoints in convenient GUI editors, without coding. Skyvia also provides additional security layer for endpoints. It allows defining user accounts for each endpoint so that you don’t need to use data source credentials to access data from this endpoint. Additionally, Skyvia allows limiting access to endpoints by IP addresses.
Skyvia logs all the requests to created OData endpoints and provides detailed information on who and when accessed which resources, and log of the request execution when applicable.
Skyvia Architecture
Skyvia is hosted in Microsoft Azure cloud, offering excellent security and scalability for large data volumes
Platform Connectivity
Skyvia supports a wide variety of data sources: cloud applications, databases and cloud data warehouses, and file storage services. It can connect both to cloud data sources and on-premises databases — directly or via Agent application.
With the exception of file storage services, which are supported only for CSV export/import, Skyvia treats all the data sources in a uniform way, and presents them as tables with data and relations between them.
You can connect Skyvia to any of the supported data sources and then use the same connections in different Skyvia products. You can create as many connections to as many data sources, as you need.
