Hi All,
I am trying to Fetch a text file from the remote machine using ODI 12c odiftpget in a package and it is not able to connect to the remote machine.
For making sure that i am providing the right credentials and details i used WinSCP and Putty installed on the same machine where ODI 12c is installed and both are connecting successfully. Only ODI is not connecting.
below is my code for ODI ftpget:
OdiFtpGet "-HOST=100.12.23.25" "-USER=abcd" "-PASSWORD=xyz" "-REMOTE_DIR=/opt/ftp1" "-REMOTE_FILE=test1.txt" "-LOCAL_DIR=C:/temp" "-PASSIVE_MODE=YES" "-TIMEOUT=50"
Error:
org.apache.commons.vfs2.FileSystemException: Could not connect to FTP server on "100.12.23.25".
I did one more thing created a File Data Server with the given credentials and shockingly i am able to test connection successfully.
So i though may be odiftp is not working so i have written JYTHON code do to the same task.which is also failing .
import snpsftp
ftp = snpsftp.SnpsFTP('100.12.23.25', 'abcd', 'xyz')
try:
ftp.setmode('ASCII')
ftp.mget('/opt/ftp1', '*.txt', 'c:/temp')
finally:
ftp.close()
Error:
socket.error: (62, 'Connection refused')
Questions:
1) I would like to know do we need to setup something like drivers in ODI before connecting to any FTP server.
2) Is it related to FTP server rights and permissions.if it is then why Winscp and PuttY is connecting successfully.
Please answer guys
Thanks
Regards