Skyvia Overview

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, cloud data backup, data management with SQL, CSV import/export, creating OData services, etc. It is a completely online solution and does not require any locally 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.

Products

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.

  • Data Flow packages allow complex integration of more than two data sources. This kind of packages allows designing a data flow from one data source into multiple ones with complex multistage transformations in-between.

  • Control Flow packages allow creating logics and running data flows or other integrations. This kind of packages allows running data flows or other integrations in a specific order or depending on the specific conditions, performing pre- and post-integration actions and even setting up some automatic error processing logic within your integration.

Backup

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.

Query

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.

Connect

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.

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.

How to Use This Documentation

We highly recommend you to read the Concepts topic, which introduces main Skyvia terms and concepts that you will see in the documentation and in Skyvia’s interface. Then you may get acquainted with User Interface Basics or switch directly to sections of the products/features that you are interested in:

Skyvia products are mostly independent of each other, and you can read only documentation about the product that you need to use. However, they all can use the same connections to the data sources that you create on Skyvia. So you can read the Connections section about Skyvia’s connection functionality in general and find the information on connecting specific data sources that you are interested in in the Connectors section.