Replication package is a specific kind of a package, which loads data from cloud applications to a relational database.
To create a Replication package, perform the following actions:
|1.||Navigate to the Integration Packages page by clicking Integration in the menu on the left side of the page.|
|2.||Click the New button.|
|3.||Click Replication on the opened menu.|
|4.||Optionally click the Edit name button near the automatically generated package name (on this step it's "Replication Package") and specify the package name. If you omit this step, the package name will be generated later based on the names of the replicated cloud objects.|
|5.||Click Select in the Source header and then click the name of the source application to replicate data from.|
Select the Source Connection for the package. If haven't created the source connection yet, click the New button and create a new connection (learn how).
|6.||Click Select in the Target header and select the DBMS to replicate data to.|
|7.||Select the Target Connection|
|8.||Specify the necessary Options:|
Incremental Updates - if selected, it means that Skyvia will not copy all the data each time when the package is executed. Instead it will detect data that was changed in your cloud application since the last package execution, and then applies these changes to your database. It deletes records that were deleted in the cloud application since the last package execution, updates records that were updated, and inserts the newly inserted records. For some cloud applications, incremental updates are not supported for some objects.
Create Tables - if selected, Skyvia will try creating the database tables in the target replication database. If the Incremental Updates check box is selected, Skyvia will try creating the database tables only for the first package execution.
Drop Tables - if selected, Skyvia will try dropping the database tables in the target replication database before creating them. If the Incremental Updates check box is selected, Skyvia will try dropping the database tables only for the first package execution. This check box is enabled only if the Create Tables check box is selected.
Create Foreign Keys - if selected, Skyvia will create the foreign keys in the target replication database according to relations between the replicated objects in the source CRM. This check box is enabled only if the Create Tables check box is selected. Note that Skyvia does not create foreign keys for many-to-many relations.
|9.||Under the Select Objects header, select check boxes for objects to replicate to database. You can filter object names to quickly find the necessary objects by entering a part of object name to the box above the grid.|
|10.||Optionally click edit for selected objects and configure the corresponding replication tasks (see how).|
|11.||Click the Save button.|
In Skyvia, Replication packages have the following parameter.
The time since the last replication. When replication is executed, Skyvia sets this parameter to the current time, and the next package execution will load the changes made since the time, specified in this parameter. You can reset this parameter in order to reload all the data.