This is the documentation on the new Skyvia interface, available at new.skyvia.com. The previous documentation on the old Skyvia interface at app.skyvia.com can be found here. Please note that the previous documentation version is no longer updated and may be partially outdated.
Skyvia is a universal SaaS (Software as a Service) data platform for a quick and easy solution of a wide set of data-related tasks with no coding: data integration, automating workflows, cloud data backup, building reports and dashboards, data management with SQL, CSV import/export, creating OData services, etc. It is a completely online solution and does not require any local installed software except for a web browser.
Skyvia provides several different, but integrated products for solving different data-related tasks. These are the following products: Data Integration, Backup, Query, and Connect. Each of the products has its own set of pricing plans and is priced separately. And if you use just one product, you don’t need to pay for other products.
Cloud Data Integration
The Data Integration product serves for automating ETL processes between various cloud applications and databases.
In Skyvia you create integration packages that define the operations and then you schedule them for automatic execution or run them manually. An integration package is a set of data ETL operations that can be stored for future use, can be executed, modified, or deleted.
Skyvia provides several kinds of packages for different integration scenarios:
Import packages allow loading data to a cloud app or database in one direction, using transformations via powerful mapping settings. Data can be loaded from another cloud app or database, or from a CSV file.
Export packages allow exporting data from a database or cloud app to a CSV file.
Replication packages allow creating a copy of cloud data in a database or cloud data warehouse and keeping it up-to-date automatically in just a few clicks.
Synchronization packages are for bi-directional synchronization of two data sources and can synchronize data with different structure and different ID system and allow complex mapping with powerful expressions.
Cloud Data Backup and Restore
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. You can view backed-up data directly in the browser or export them to CSV files. Additionally, Skyvia allows searching in the whole backup history and finds necessary records whenever they were backed up.
Skyvia offers few-clicks-restore functionality. You can simply select what data to restore or what data changes to undo, and Skyvia restores them automatically without the need to tinker with CSV files or third-party tools. You can restore whole tables, separate records, or even separate fields when necessary.
Cloud SQL Client with Visual Query Builder
Skyvia includes cloud SQL client that allows executing SQL statements against both 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 of the supported data sources.
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 Skyvia Query Google Sheets Add-on.
Cloud Connectivity Service
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 standard and widely accepted interface OData to the data in these data sources for data consumer applications.
Skyvia allows creating OData endpoints in convenient GUI editors and allows configuring 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.
Connections are one of the key Skyvia concepts. Skyvia works with data sources via connections to them. The connections are created and managed just like any other object on Skyvia.
Connections you create can be used in all Skyvia products and are not priced separately. You can create as many connections to any data sources as you need in Skyvia, and this won’t increase the price. You can also have multiple connections to the same data source if necessary.
When creating a connection, you either need to specify the necessary connection parameters or sign in to the data source and allow Skyvia access to its data, depending on the data source you want to connect to, and authentication method selected. You can read more about connections in Skyvia in the Connections section of this documentation.
In this documentation, we unite agents, connections, integration packages, backups, user queries, connect endpoints, etc. under term Skyvia objects. The page, showing all the objects in your default workspace, is the first page that you see on Skyvia after signing in.