To see the latest version of the document click here
  • User Manuals »
  • Denodo SFTP Exported Files Custom Handler - User Manual

Denodo SFTP Exported Files Custom Handler - User Manual

Introduction

The Denodo SFTP Exported Files Custom Handler is a Denodo Scheduler custom handler that copies by SFTP data from the job’s exporters. The exported files are copied to the SFTP server into the destination folder and if you choose the delete option, the files are deleted from VDP server afterwards.

 

Note: currently supported exporters are: CSV exporter, SQL exporter and Generic XML exporter (files created by other custom exporters are not tested).

How to Install

To install the sftp-exported-files handler, first download it from the Denodo Support Site.  Once uncompressed, connect to the Scheduler Server via the Scheduler Admin Tool.

After connecting, go to “Configurations → Plugins” to access the “Plugins Configuration” section.  

Then click “New Plugin”.  

Using that form, upload the file from the distribution named denodo-sftp-customhandler-{version}-jar-with-dependencies.jar and click “Accept”.  After the success page, you will see the new handler in the “Plugins” section.

How to Add the Handler to a Job

To add the sftp-exported-files handler to a job, first connect to the Scheduler Server via the Scheduler Admin Tool.   Then select the job that will use the handler (or add a ‘New Job’).

 

Navigate to the “Handler section” tab.  Click “Edit Job”. Then click “New Handler →

email-exported-files”.  


Fill in the input fields.  When done editing the job, click “Save”


SFTP-exported-files Handler input parameters

  • Host: SFTP host. It is a mandatory field.

  • Port: SFTP Port Number. SFTP usually uses port 22 but can be configured to run on nearly any port. It is a mandatory field.

  • Destination folder: Folder into which exported files will be copied at the SFTP server. It is a mandatory field.

  • User: SFTP user. It is a mandatory field.

  • Password: SFTP password. You can use Keyfile instead of the password.

  • Key File: Filepath of the private key.

  • Passphrase: Passphrase of the private key

  • Delete files: If you choose this option the exported files will be deleted from server VDP after being transferred.

Configuration

You can configure the handler using the user and the password to connect to the SFTP server. Or specifying the location of the private key file with the Key File parameter and its passphrase.

You have to configure also the folder where you want to copy the exported files with the Destination folder parameter. In addition, you have the possibility to eliminate the exported files generated by scheduler if you select the Delete files option. Note that, with this option checked, even if the connection with the SFTP server fails during transmission the generated files will be deleted.