01 October 2018
We recommend you to take a look at the Import or Replication packages.
Replication package can create target tables; in case of Import package, you should have target tables created beforehand.
Import package allows loading data from CSV files, cloud application objects or relational database tables to another cloud application or relational database. Skyvia Import supports all DML operations (including UPSERT), and thus can be used for performing massive data updates. When importing data from cloud sources, Skyvia allows creating packages that import not all the cloud data from the source object but only the records, created or modified since the package creation or since the previous package execution.
Please refer to:
Replication package is used to create a copy of cloud application data in a relational database and keep it up-to-date. With the Incremental Updates check box, after the initial replication, only the data that was changed in the cloud CRM is sent to the database: deleted rows are deleted from the database table, new records are inserted and the changed records are modified.
Refer to: https://skyvia.com/resources/docs/index.html?replication.htm