Synchronization

Synchronize your Cloud and SQL Data Sources

No more manual data synchronizations, no more coding to integrate your on-premise
and cloud data.

With Skyvia you can:

Synchronize data between cloud apps and relational databases in both directions

Configure synchronization visually with no coding and a minimal amount of technical knowledge required

Synchronize data of varying formats and structures while maintaining the relationships

Schedule synchronization to perform automatically and keep your data in sync with
no effort

Common Data Synchronization Scenarios

Legacy Data Integration

When you need to integrate legacy applications using relational data with your new
cloud CRM system, Skyvia is a perfect solution for you! Tweak data synchronization
once and keep your relational and cloud data in sync!

Data Migration

You are moving from one platform to another and your data needs to go along for the ride!
For example: If your company is going from an in-house relational DB to a cloud based
platform, you’ll want to maintain mirror images of both data sets until the migration
is complete (and probably for sometime afterwards).

With Skyvia Synchronization functionalities, very little of your time, effort or concern will need to be spent on the mirroring process and your resource can concentrate on more relevant migration tasks.

Performing Massive Data Updates

Performing a massive update of your company cloud data is a complex process, and
requires careful planning and checks. With Skyvia you can load your cloud data to a
relational database and then use SQL to perform any update operations. Once complete
you can verify the updates are correct and Skyvia again to sync your database with
your cloud app!.

Key Synchronization Features

Powerful Mapping for Data of Differing Structures

Skyvia provides powerful mapping configuration capabilities. It supports data splitting
- mapping a single table to several related tables/objects and vice versa (one-to-many).
You are not limited to the simple column-to-column mapping. Skyvia allows using
powerful mathematical and string expressions when mapping data.

No Need to Customize Data Structure

Skyvia builds the id map when inserting data and remembers it. Then when performing the next synchronization, Skyvia knows how the records correspond to each other. You don't need to add custom external ID fields to cloud CRM objects or use textual IDs in your database.

Data Change Tracking

When performing synchronization repeatedly, Skyvia synchronizes only data that's been changed since the latest sync of the sources. It uses CreationTime and ModifiedTime fields in cloud CRMs and creates special tracking tables and triggers in relational databases for data modification tracking.

Automatic Synchronization

Skyvia offers powerful scheduling settings which allow you to specify any kind of schedule. For example, you may run your package every 10 minutes during a specified interval on Mondays and Tuesdays, or run your package every third Wednesday of the month.

Predefined Templates Gallery

Integrate your cloud application quickly and easily using our predefined templates gallery. You can use predefined mapping templates to map data between different cloud data sources instead of mapping them manually. Configure your cloud data synchronization with no efforts in few clicks!