When you sign in to Skyvia or when you click Integration in the menu on the left, the Integration Packages page is opened. This page displays the list of all your integration packages and allows you to manage them - run them, edit, clone, delete, or start creating a new package.
You can view more detailed information for each package by clicking its name and opening its Package Details page. It displays the package schema and package run history.
Creating a New Package
To create a new package, click New and then select a kind of a package you want to create. You may also click Gallery to select a package template from the Predefined Integrations Gallery. After this the package editor page will open. Depending on the package kind selected, please read the following topics about the corresponding kinds:
Running a Package
To run a package, select the check box in the first column of its row and then click the button. You will be warned that package execution can take much time, click OK.
After this, package state will be changed first to Queued, and then - to Running. You don't need to wait for the package results, and may close the browser window with Skyvia, if you need. The package will continue running on Skyvia server.
Alternatively, you can run a package from its Package Details page by clicking Actions, and then clicking Run.
If you run a package and then changed your mind, you may cancel its execution. For this, you may either click the Cancel icon for this package on the Integration Packages page or open its details and click the Cancel button.
However, you should know certain aspects of canceling a package. Currently running tasks will run till the end, and load all the data. If some package tasks haven't run before canceling, they won't run. Thus, canceling a package run may take a long time, and if the package consists of only one task, canceling will take the same amount of time as finishing execution.
After canceling a package, data of some tasks can be successfully loaded, and for other tasks - no. In some cases you may need to manually clean up data before re-running the package in order to maintain the data integrity.
If a package is canceled, the records it loaded are not counted to the subscription counter.
Cloning a Package
To clone a package, select the check box in the first column of its row and then click the button. Then click OK to confirm package cloning.
Skyvia will create an exact copy of your package. It will add the " - COPY #" to the name of the cloned package for the new package, where "#" is a counter for generating unique names. The package will have exactly the same connections, tasks and mapping as the original package, but it will have empty Run History and all its parameters, if any, are reset.
After this you will be offered to switch to the Package Details page of the new package. Click OK to switch to its details or Cancel - to stay on the current page.
Alternatively, you can clone a package from its Package Details page by clicking Actions, and then clicking Clone.
Opening a Package for Editing
To open a package for editing, select the check box in the first column of its row and then click the button. The package editor page will open, where you can edit your package. On this page, you can make changes to your integration package - select its connections, configure its settings if the package has settings, add, delete, or edit package tasks, edit, disable, or enable package schedule, reset package parameters, if any.
Alternatively, to open a package for editing, you can switch to its Package Details page and click the Edit button, or click Actions and then Edit.
Deleting a Package
To delete a package, select the check box in the first column of its row and then click the button. Then click OK to confirm package deletion. You can select and delete multiple packages at once on the Integration Packages page.
Alternatively, you can clone a package from its Package Details page by clicking Actions, and then clicking Delete.
The Integration packages page displays a table, listing your integration packages, and allows you to manage your packages. It displays the most important information about your packages - their type, name, source and target, when they were last run or modified.
To quickly find a package, you can use the search box above the package list, or use sorting and filtering of the package list.
The Integration Packages page displays the following information about all your packages:
Package list can be sorted by any column. To sort packages just click the column to sort packages by. Click it again to change the sort order.
To quickly find a package, you can filter packages list. There are two ways you can filter packages. The first one is to filter packages by a part of their names. For this enter a part of a package name to the search box above the grid. Only the packages, containing the entered string in their names will be displayed.
The second way allows you to filter packages by their type, source or target type, or their state. To filter packages, click the filter icon in the corresponding column and select the corresponding values. Only packages having the selected values in the corresponding columns will be displayed. To disable filter, click the filter icon in the corresponding column again and clear selection (or select all values). In this way you can filter packages by several columns.
To get more detailed information about a package, click its name in the Name column on the Integration Packages page. This opens the Integration Package Details page, which displays package creation and latest modification time, package tasks, and package run history. On this page you can view package execution logs in the Run History pane and see the information on successfully loaded and failed rows.
The Integration Package Details page allows you to run the package, open it for editing, clone the package, delete the package, and clear the package run history by clicking Actions and then clicking the corresponding link in the menu.
You can also preview the connection settings on the Integration Package Details page. For this click the connection name in the package content.
The view details link leads to the Connection Details page for this connection.