Skip to main content
Solved

connecting to a sftp server

K
Forum|alt.badge.img

I am trying to use either the FTP caller or the HTTP caller to post/send a file to a sftp site. I have tried multiple settings and no luck. In FileZilla I can go into site manager and choose SFTP-SSH file transfer protocol and put in all information and it works. It calls the address https:// instead of sftp:// but works and connects. My goal is to automate this so I do not have to manually connect and upload the files to the SFTP site. Any help on the settings I need to use would be greatfull:

In FTP caller I have used set the URL to sftp and ftp. it stays red when I try to use https. Is their somewhere that i can declare it a sftp so it will be https?

In httpcaller it will accept https but fails out. I use http authentication but will not connect still. I am not sure what else i need to do to get it to connect.

My goal is to have FME send the files to this sftp so I do not have to manually do it.

Best answer by roland.martin

This may not be directly relevant, but I had some problems with SFTP a couple of months ago, and Safe looked into this for me (C113386). The problem I was having was caused by FME refusing to connect via our company proxy, and so failing to open a connection.

As a workaround, I installed WinSCP. You can call it from FME using its scripting. Use an AttributeCreator to build an attribute containing something like the following:

open {FTP_CONNECTION_NAME}
cd "{REMOTE_DIRECTORY}"
lcd "{LOCAL_DIRECTORY}"
get "{FILE_NAME}"
exit

... replacing the curly brackets as appropriate.

Then use an AttributeFileWriter to write that as a file onto your C drive.

Then use a Decelerator with a couple of seconds of delay to prevent the next call from running before the file has finished writing.

Finally, use a SystemCaller, with a command such as:

"C:\Program Files (x86)\WinSCP\WinSCP.exe" /script="C:\script.txt"

Hope this helps!

View original
Did this help you find an answer to your question?

3 replies

brianatsafe
Safer
Forum|alt.badge.img+11

Hi @kouri1986,

SFTP support was added for the FTPCaller in FME 2016.0. Do check and see if perhaps you are on a slightly older release. Could you tell us more about the use of https:// instead of sftp://? Do you have any information as to why you need to access the service using https?

Another idea here is using a shutdown script to call a program to upload the data. You can see a sample of this type of workflow using WinSCP here: https://knowledge.safe.com/articles/788/transfer-w...

Regards,

Brian Pont

 

K
Forum|alt.badge.img
  • kouri1986
  • Author
  • June 21, 2016
brianatsafe wrote:

Hi @kouri1986,

SFTP support was added for the FTPCaller in FME 2016.0. Do check and see if perhaps you are on a slightly older release. Could you tell us more about the use of https:// instead of sftp://? Do you have any information as to why you need to access the service using https?

Another idea here is using a shutdown script to call a program to upload the data. You can see a sample of this type of workflow using WinSCP here: https://knowledge.safe.com/articles/788/transfer-w...

Regards,

Brian Pont

 

I am not sure, when I use FILEZILLA to connect to the SFPT it puts the URL as HTTPS://. so not sure why. I am currently using FME 2016.1.01 64bit edition.

roland.martin
Forum|alt.badge.img+9

This may not be directly relevant, but I had some problems with SFTP a couple of months ago, and Safe looked into this for me (C113386). The problem I was having was caused by FME refusing to connect via our company proxy, and so failing to open a connection.

As a workaround, I installed WinSCP. You can call it from FME using its scripting. Use an AttributeCreator to build an attribute containing something like the following:

open {FTP_CONNECTION_NAME}
cd "{REMOTE_DIRECTORY}"
lcd "{LOCAL_DIRECTORY}"
get "{FILE_NAME}"
exit

... replacing the curly brackets as appropriate.

Then use an AttributeFileWriter to write that as a file onto your C drive.

Then use a Decelerator with a couple of seconds of delay to prevent the next call from running before the file has finished writing.

Finally, use a SystemCaller, with a command such as:

"C:\Program Files (x86)\WinSCP\WinSCP.exe" /script="C:\script.txt"

Hope this helps!

Reply


Helpful Members This Week

Community Stats

31,264
Posts
118,558
Replies
38,856
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.