Backup

Skyvia Backup allows you to back up data from supported cloud applications automatically on a schedule or anytime manually. Backed up data can be viewed, exported, or restored directly to a data source via web browser, from the Skyvia interface.

Base Terms

In Skyvia, a backup is a configuration, determining what and when to back up. It specifies the data source to back up data from, the set of data source objects to back up with additional settings such as a set of fields to back up and filter conditions, and backup schedule.

A backup “runs” on schedule or started manually, creating snapshots. A snapshot contains all the backed up data for the specified date and time, according to settings, specified in your backup.

Scheduled backup is available for paid subscriptions only. Users on free subscriptions can run backup manually.

Backing Up Data

With Skyvia, you can set up automatic backup that runs up to once per day. Whenever necessary, you can also back up data manually. Every time Skyvia performs a full backup, so each snapshot contains all the data, selected in the backup.

When you set up a backup, you can select what data to back up. You can select cloud objects to back up data from, exclude some of their fields from backup, if necessary, and even configure filters to back up only data, matching certain conditions.

Backed up data are stored in a secure Microsoft Azure cloud. They are stored securely, in an encrypted form. For more details, please read Backup Security.

Viewing and Exporting Data

Backed up data can be easily viewed and exported from web browser. After opening your backup, you can navigate its snapshots, open an object in any of the snapshots and view its data in the browser.

Whenever necessary, you can also export backed up data to a CSV file to store it locally. For more details, please read Working with Backed Up Data.

Restoring Data

You can restore data simply by opening a snapshot, selecting records or whole objects, and then clicking the Restore button. Skyvia then provides you a choice of operations you can do with the selected data — insert to data source, update the corresponding records in the data source to the values from the snapshots, or delete them from the data source (NOT from the snapshot). You can restore separate records, whole cloud objects, or all the data.

Skyvia Backup is able to restore records with their relations. You just need to select all the necessary related records and restore them together in one restore operation. For more details, please read Restoring Data.

Alternatively, you can switch to the Changed view and compare the current snapshot with the previous ones. The displayed changes can be simply selected and undone with the same Restore button. For more details, please read Comparing Snapshots and Viewing Data Differences.

Backup Limitations

Skyvia performs backup and restore operations via API, provided by data sources, and thus, is sometimes limited to the corresponding API functionality. If data source API doesn’t allow querying all the data from a specific object, Skyvia cannot back up data from such objects. If data source API doesn’t allow writing to a cloud object, Skyvia cannot restore data of such object. Some data source object don’t allow specific operations — either adding records or modifying them or deleting them. In such case Skyvia Backup also cannot perform the corresponding operation when restoring data. For more details, please read Backup Limitations and Troubleshooting.

Backup Connections

Skyvia Backup also allows using backed up data in other Skyvia products — Data Integration and Query. You can create connections to your backed up data and use them in Data Integration and Query. For example, you may use query to analyze your backed up data or export only some specific backed up records. Data integration can be used to integrate data with other data sources without adding additional load to the backed up source itself or to perform more custom restore operations.

Backup connections are read-only. You cannot modify data in your snapshots. They can be configured to point to a specific snapshot or always to the latest one.

Currently, backup connections cannot be used in the Connect product.