Downloads

• generate_and_upload_using_WinSCP.zip

Introduction

Note: As of FME Server 2016, there is an SFTP Subscriber available.

After running a translation, you may want to upload your output to a secure server. SFTP (Secure File Transfer Protocol) is a protocol which can be used to transfer files securely to and from a remote computer. Popular uses of SFTP include:

• Emulating the FTP subscription on FME Server
• Encrypting an output dataset during remote file transfers
• Encrypting the password during remote file transfers

At this time, a built-in method has not been developed to perform this type of file transfer within FME . However, we can use a very simple python shutdown script and the WinSCP SFTP client to complete this process.

What you Need

• WinSCP installed on the same machine as FME Desktop or Server
• An SFTP server

Workflow

The example workspace "generate_and_upload_using_WinSCP.fmw" contains a simple workflow. It writes a text file to a user-specified directory and then the entire directory is uploaded to an SFTP server using WinSCP. To accomplish this, FME runs a shutdown Python script which invokes the WinSCP application and provides it with the information needed to complete the transfer.

Using the Workspace

You will need to edit the Python script by providing the proper credentials (username, password and host). As well, depending on the WinSCP installation and your specific operating system, you may need to edit the path to the WinSCP application.
Line to edit:

 #Command list - NOTE: Edit below to add correct WinSCP directory as well as the FTP username, password and host.  eg: admin:admin@ftp.example.com command = ["<strong>C:\\Program Files (x86)\\WinSCP\\winscp.com</strong>", "/command", "option confirm off", "open <strong>MYUSER:MYPASS@MYHOST</strong>", "put " + fmeoutdir, "close", "exit"]

Once the script has been edited, test the output and determine if it was uploaded to the SFTP server. The process should complete successfully with the output folder uploaded securely to your server.

You can now incorporate this workflow into your own personal projects.