Overview
Skyvia is a versatile no-code cloud data integration platform for ETL, ELT, Reverse ETL, data migration, one-way and bi-directional data sync, workflow automation, real-time connectivity, and other data-related tasks.
Skyvia supports 190+ data sources, including cloud applications, databases, data warehouses, and file storage services. A vast connector library enables seamless integration among them. Skyvia no-coding wizard-based tools are easy to use by IT professionals and business users with no technical skills.
How it Works
Skyvia connects to the data sources via their APIs. When Skyvia connects to cloud apps or databases, it reads their metadata and data and represents them as tables and relations between them.
You can connect Skyvia to any of the supported data sources and use the same connections in different Skyvia products.
Products
Skyvia offers several products tailored for different data-related needs: Data Integration, Automation, Backup, Query, and Connect. Each product has distinct pricing plans, allowing users to pay only for what they use.
Data Integration
The Data Integration product automates ETL, ELT, and Reverse ETL processes between various cloud applications and databases.
In Skyvia, “integration” refers to a collection of tasks or operations grouped together to automate data-related processes. Each integration can be scheduled to run automatically, helping users automate repetitive tasks without manual intervention.
Skyvia offers various types of integrations for different data integration scenarios.
Import
Import provides one-way data loading from a data source to a cloud app or database, applying data transformations using mapping capabilities. Data sources can include another cloud app, database, or a CSV file on a local computer or in a file storage. Use Import to integrate data sources of different structures.
Export
Export enables data extraction from a database or cloud app to a CSV file on a local computer or file storage. Advanced export features allow exporting the original or transformed source data.
Replication
Replication copies cloud data to a database or cloud data warehouse and automatically keeps it up to date. It creates tables in the database or data warehouse from cloud app objects, using available transformation options.
Synchronization
Synchronization enables two-way data transfer between data sources with different structures by using mapping capabilities. It copies data between both sources and maps the original records to their counterparts in the other source.
Data Flow
Data Flow enables the implementation of advanced integration scenarios involving more than two data sources. It helps you perform complex, multistage transformations, such as getting data from one data source, enriching it with data from another one, and finally loading it into the third one.
Control Flow
Control Flow enables running data flows or other integrations in a specific order or depending on the particular conditions, performing pre- and post-integration actions and setting up error processing logic within a single integration.
Automation
Automation helps optimize business workflows by connecting apps and services and automating repetitive tasks. With Automation, you can create complex workflows to handle various conditions and data operations efficiently.
Use Triggers, Actions, and Conditional components to build the automation flow with a multi-step conditional logic and error processing and run your automation manually based on schedule or event.
Automation is especially useful for streamlining recurring processes. For example, you might automatically add a task when a new support ticket is received, create a new order after a sale, or schedule cross-platform data transfers.
Backup
Skyvia Backupis a robust backup and restore tool for cloud application data. It enables performing manual and automatic backups. After you back up your data, you can access it in the web browser or export it to CSV. The Restore feature helps you to restore the data source objects, separate records, or even fields.
Also, you can use your backed-up data as a data source for other integrations.
Query
Skyvia Query is a cloud SQL client that enables executing SQL statements against cloud applications and relational databases. It supports SELECT and DML Statements. Visual Query Builder helps build queries without SQL knowledge. You can export query results to a CSV or PDF file.
To save your queries in one place and access them at any time, use the Query Gallery. Query Gallery is a collection of predefined queries for common use cases.
Skyvia Query supports querying data directly in Google Sheets, using Skyvia Query Google Sheets Add-on, and in MS Excel using Skyvia Query Excel Add-in.
Connect
Skyvia Connect is a connectivity-as-a-service solution that helps to publish any data as OData endpoints. It makes your cloud and on-premises data available for various OData consumer applications, such as BI tools, office suites, Salesforce Connect, etc., with no coding.
Skyvia connects to data sources via their custom interfaces and provides unified web API for their data. Skyvia supports OData endpoints and SQL endpoints. You can configure endpoints in convenient GUI editors without coding.
Skyvia logs all the requests to created endpoints and provides detailed information on activities against them.
How to Use This Documentation
This documentation is designed to help you get acquainted with Skyvia and find the needed information quickly.
Start with the Concepts and User Interface Basics topics to familiarize yourself with the basic terms and UI elements and controls. Look for your apps in the Connectors section, which helps you establish a connection to your application or database and provides additional advanced Connector-related information. Do not hesitate to use the search bar to look for any Skyvia-related information.
Below is the list of sections dedicated to the separate Skyvia products.
See the latest Skyvia updates and news in the Recent Releases section.