Skyvia is a powerful solution for cloud data integration (ETL) and backup. It is a completely online solution and does not require any local software installed except for a web browser.
In Skyvia you create integration packages that define the operations and then you run them or schedule for automatic execution. An integration package is a set of data ETL operations that can be stored for future use, executed, modified, or deleted. Please read Getting Started with Data Integration for more information.
Skyvia provides several kinds of packages for different integration scenarios. They are Import, Export, Replication, and Synchronization packages.
Import wizard allows you to define an operation of data import to a relational database or cloud application. CSV files and any of supported databases or cloud application can be used as a source of the data to import.
Skyvia import can be a perfect solution for data migration between different platforms. It supports complex import operations and does not limit you to a simple column-to-column mapping. Skyvia allows complex mapping with powerful expressions, and preserves source data relations when the source and target data structure differs.
Skyvia supports not just inserting new data, it supports all the DML operations and can be used for bulk data update operations.
Export packages allow you to export data from cloud applications and relational databases to CSV files. It supports powerful data filtering, including filters on the fields of related objects, and can be used for cloud data backup, integration with other platforms that support CSV format, etc.
Replication wizard allows you to configure cloud data replication to a relational database or a cloud data warehouse service. Skyvia creates the corresponding tables in the database automatically with optional foreign keys to completely reflect the cloud data relations. You can drop and recreate the database tables if replicating the same data multiple times or use the Incremental Updates feature.
When Skyvia uses Incremental Updates, it doesn't copy all the data each time when the package is executed. Instead it detects data that was changed in your cloud application since the last package execution, and then applies these changes to your database. The Incremental Updates feature allows you to reduce cloud application API calls number and thus the cost of replication operation.
Synchronization wizard allows you to configure a bi-directional data synchronization operation between cloud applications and relational databases. After you have defined and performed synchronization, Skyvia tracks data changes and synchronizes only the necessary changes when performing subsequent synchronizations. It can synchronize data with different structure and different ID system and allows complex mapping with powerful expressions. As well as other operations, synchronization can be scheduled for automatic execution.
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.
With Skyvia you can monitor all the backup and restore operations and data changes in time. Skyvia displays the total number of backed up records and number of changes since the previous backup for each backup operations and allows you to compare backups with each other and see the data changes between backups.
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. Skyvia allows previewing returned data in browser in a table or visualize this data as different kinds of charts. You can also export these charts or data returned in a table form to a local file.
Skyvia allows not just selecting data but also performing DML statements. Thus, you can use Skyvia as a tool for mass cloud data updates.
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 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.