Package is the basic concept in our Skyvia. A package is a unit of work that performs a set of data ETL operations. A package can be stored for future use, executed, scheduled for automatic execution, modified, or deleted. You can also clone an existing package.
Packages consist of tasks - units of data extracting, transforming and loading process. For example, import package task imports data from a single file or database table or view, replication package task replicates data from one application object to a database table.
A package can contain any number of tasks, but tasks cannot be created or performed outside of packages. All tasks in a package share the same source and target connections if such are used.
Skyvia supports the following data integration package types:
|•||Import Package - a package that loads data from CSV files, relational database tables, or cloud applications to another relational database or cloud application. It allows to quickly migrate data from one platform to another. Import packages support all kinds of data manipulation operations - insert, update, delete, and, for Salesforce, upsert.|
|•||Export Package - a package that exports data from one or more database tables or cloud application objects to CSV files. Export package allows you to include fields to export from main target object and its related objects. You can filter the data to export and create filter conditions as complex as you need.|
|•||Replication Package - a package for replicating cloud application data to a relational database and keeping the copy up-to-date automatically.. Replication package is used for creating a copy of your cloud application data in a relational database. Replication package creates the tables with the structure corresponding to the replicated cloud application objects automatically and copies cloud application data to them. For subsequent replication execution it can use Incremental updates|
|•||Synchronization Package - a package for bi-directional data synchronization between cloud applications and relational databases.|