Export Package

Export package is a specific kind of a package, which loads data from cloud applications and relational databases to CSV files.

Creating an Export Package

To create an export package, click +NEW in the top menu and select Export in the Integration column. When the package details page opens, perform the following steps:

  1. Specify a source connection you export data from and a target connection you load data to;
  2. Create export tasks for the package;
  3. Optionally schedule the package for automatic execution.

Source and Target Connection

Source Connection

Under Source, in the Connection list, select a source connection you want to use from the drop-down list or create a new one if you have not created it yet. You can use the Type to filter box to quickly find the necessary source connection. In order for you to create a new connection, click +New connection in the drop-down list (learn how).

Source Connection

Target Connection

There are two scenarios of data export to target:

  1. By default, data are exported to CSV file(s) downloaded manually.

    Target Type 1

  2. If you want to save CSV file(s) to a file storage service or FTP, click CSV to storage service in the target type. After this, click Select target and select a target connection or create a new one if you have not created it yet. In order to create a new connection, click +New connection in the drop-down list.

    After this, select the Folder where to place the result file(s).

    Target Type 2

Additional Options

If necessary, specify the Code Page of the exported file with data.

Code Page parameter

Additionally, you may click the More options link and specify CSV Options shown below.

CSV Options

You also can clear the Append timestamp to the file name check box if you want the name of the result CSV files to consist only of the exported object or table name. Note that if you specify a custom target CSV file name in an export task, it will not be followed by the timestamp even if this check box is selected for the package. This check box is applied only for export tasks with the default file name.

Creating Export Tasks

To create an export task, click the Add new link and configure a new export task as described in the How to Create Export Task topic.

How to Download Exported Files

After you create a package, the following three tabs are displayed in the middle of the toolbar of the details page: Model, Monitor and Log.

Model tab shows source and target connections, tasks/schedule/parameters of the package, etc.

Monitor tab shows 5 most recent package runs and whether the package is currently running.

Log tab shows runs for the selected period.

When you export data to a CSV file, you can download the result file manually in the following way:

  1. Сlick the Monitor tab of the package details page.
  2. In the open tab, click the package run you want to download the results of.

    Run History

  3. After you do it, the History Details window will open with detailed information.

    Run History

  4. Under Result, click the number of records to download the result CSV file.

Files are available for download for 7 days since the package run.

Note if you have more than 5 package runs, you cannot see all of them on the Monitor tab. Instead you should go to the Log tab, which shows all package runs for any selected period.

To download the result file, perform the following steps:

  1. Click the Log tab of the package details page.
  2. Select Last 7 Days.
  3. Click the package run you want to download the results of.
  4. After you do it, the History Details window will open with detailed information.
  5. Under Result, click the number of records to download the result CSV file.