sftp

system · January 11, 2012, 11:50am

How can we implement sftp in BODS?
Requirement1:To put xml files in SFTP location
Requirement2:To take csv files from SFTP location

Is this possible in BODS?

SuCheri (BOB member since 2011-11-18)

system · January 11, 2012, 12:15pm

Here is an example of getting the data. The example is actually for SAP data but for flat files it is the same thing.

For putting data somewhere via sftp you will use a script with the exec() function most likely.

Werner Daehn (BOB member since 2004-12-17)

system · October 15, 2012, 7:08pm

install winscp -

exec abc.cmd to call winscp.exe

abc.cmd -
@ECHO off
cd ABC\WinSCP\WinSCP
winscp.exe /script=C:\winscript.txt

winscript.txt-

Automatically answer all prompts negatively not to stall the script on errors

option batch on

option confirm off

open user:password@url

cd abc

option transfer binary
synchronize local abc

close

Exit

I hope this will help-

n78882 (BOB member since 2010-09-17)

system · October 15, 2012, 7:26pm

SCP is not sftp. But yes, everything can be called from the commandline as long as the application also supports a commandline.

Johannes Vink (BOB member since 2012-03-20)