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)
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 (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-
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)
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)