sftp

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)

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

https://wiki.sdn.sap.com/wiki/display/BOBJ/custom_transfer+transport+method

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


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

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

Disable overwrite confirmations that conflict with the previous

option confirm off

Connect using a password

open user:password@url

Change remote directory

cd abc

Force binary mode transfer

option transfer binary
synchronize local abc

Disconnect

close

Exit WinSCP

Exit

I hope this will help-


n78882 :us: (BOB member since 2010-09-17)

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


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