It would be helpful if FME Server 2017 had an SFTP Watcher. Currently the regular FTP Watcher does not support SFTP. I am aware that the Notification Service supports SFTP subscriptions but currently in 2017.0.1.1 there is no corresponding SFTP publication option.
As a possible workaround for now, you could run a workspace on a schedule polling your FTP drive via sftp. The FTPCaller transformer supports sftp. If you specify the correct protocol and the path of the folder you want to watch in the URL field (e.g sftp://<yourFTPServer>/<folderToWatch>/) and select "Download to an Attribute" as Transfer Type you will get a file list of this folder stored as text in the attribute you choose. To compare this to a previous result you could create a SQLite DB file and store the initial contents of the folder in there and whenever your schedule runs the FTPCaller you could query the SQLite and compare it to the result from the FTPCaller. Whenever there is a new file you now would add the new file as an entry to your SQLite, download the new file and trigger whatever action you planned for the new file, e. g. triggering a topic with the FMEServerNotifier that triggers another workspace to process the data.
The main downside of this is that this scheduled workspace will need an engine available at all time to run regularly on a schedule. On FME Cloud additional FME Server engines won't cost you extra, so it would be at least a reasonable workaround there.
+3- Contributor
Would like to see this event trigger for automations. Now on FME Flow 2023 and no SFTP-trigger
+15- Safer
The following idea has been merged into this idea:
All the votes have been transferred into this idea.
All the votes have been transferred into this idea.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.