Managing Integration Packages

Managing Integration Packages

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.

 

ExpandedToggleIcon        Managing Packages

 

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 Run 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.

 

Cloning a Package

To clone a package, select the check box in the first column of its row and then click the clone 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 Edit 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 the its Package Details page and click the Edit button, or click Actions and then Edit.

note Note

To learn how to schedule a package to be executed automatically, see Scheduling Packages.

 

Deleting a Package

To delete a package, select the check box in the first column of its row and then click the Remove button. Then click OK to confirm package deletion. You can select and delete multiple packages at once on the Integration Packages page.

note Important Note

Please note that deleting a package cannot be reversed! If you delete a package, its run history, mapping, log files, etc. will be deleted completely.

Alternatively, you can clone a package from its Package Details page by clicking Actions, and then clicking Delete.

 

ExpandedToggleIcon        Integration Packages Page

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.

packages-page

To quickly find a package, you can use the search box above the package list, or use sorting and filtering of the package list.

 

Package Information

The Integration Packages page displays the following information about all your packages:

Column name

Description

Type

Type of the package - Import, Export, Replication, or Synchronization.

Name

Name of the package.

Source

The type of the source connection.

Target

The type of the target connection.

State

The result of the last package run.

New - the package was never run.
Succeeded - the package successfully loaded data to target objects.
Failed - the package failed to execute.
Queued - the package is queued for running.
Running - the package is being executed.
Canceled - package execution has started but was canceled.
Canceling - canceling of the package execution is in progress.

Run

Displays how long ago the package was run the last time.

Modified

Displays how long ago the package was modified the last time.

 

Sorting and Filtering Integration 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.

note Note

Filter settings are preserved between session. If you can't find the packages you want to see, first disable all the filters if there are ones enabled and check if the Search box is empty. If a filter by the column is enabled, the color of the filter icon is changed in this column to light-blue.

 

ExpandedToggleIcon        Integration Package Details Page

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.

package-details-page

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.

preview-connection-settings

The view details link leads to the Connection Details page for this connection.