We are planing to purchase paid version for our client. Our requirement is like sync the database table with salesforce object. My question is suppose they hava added record in table then how the record will be created in salesforce?? In table they dont have ID of saleforce object then how the specific record is updated during sync??
Could you please provide more details so that we can assure them that it is possible using Skyvia??
Skyvia synchronization operation is used to synchronize data between cloud applications and relational databases in both directions.
When synchronization is performed for the first time, it does not check whether the records in sources are identical and simply copies data from one side to another and vice versa, and "maps" the original records to their copies in another source. For this, Skyvia builds the id map when inserting data, and remembers it, and when performing next synchronization, Skyvia knows how the records correspond to each other. You don't need to add custom external ID fields to cloud application objects or use textual IDs in your database.
When performing synchronization repeatedly, Skyvia synchronizes only data that was changed since the previous synchronization. It uses the fields storing information about when a record was created and modified in cloud applications and creates special tracking tables and triggers in relational databases for data modification tracking.
Please also note, the main requirement for synchronizing database data is that the primary key columns of the database tables must be autogenerated.