With Skyvia you can:
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!
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 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!.
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.
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.
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.
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.