You did not provide any information, so I am assuming you are trying to transfer data from SAP. Have you tried to connect from FTP command line? This may be a permission issue. The account used to open the FTP session must have authority to read files created by SAP. This article may be useful:
1. Yes i have tried connecting through CMD that was my issue initially but its resolved now so i am able to access it via the command line.
2. But through data services, i just need to access a file which is at FTP so i make a Flat File Datasource and in source i give FTP details now when i am trying to select the directory its not allowing me / taking me the to FTP location.
Thanks for your previous response Paul, I will look through the document and i hope the above two points would help to explain my problem better.
I'm assuming BODI server is on Windows server box. In that case, you need to move .xls file from ftp to windows shared directory which can be accessible by BODI windows service account. You need to mention Windows shared directory path in the data store. I came to know this while discussing with unix team but yet to try. Even I'm going through the same issues.
Note: I'm using SAP shared directory transport method.
Your response indicates that you are not trying to extract data from SAP. You are trying to read a file using FTP. Is this correct? If so, are you configuring the flat file format object for custom transfer? In the Technical Manuals, the section in DS Designer Guide, File formats, File transfers has details about this.
Thanks for the reply Paul.
I have checked in the Tutorial and the designer guide. There is nothing there which is not obvious thing which one knows.
They are not helpful at all in this scenario to me.
Yes i am trying to read a file using FTP.
Yes i am configuring the flat file format object for custom transfer.
Let me know if you have more inputs.
Hi Paul and Suresh,
Many Thanks for the reply.
Data Services is installed on WINDOWS machine and FTP is installed on LINUX machine in my system.
Now i am not able to access FTP from Data Services, is there anything that i need to do ? Some setting or adapter etc ?
Edited by: Dennis on Oct 21, 2010 11:29 AM
Edited by: Dennis on Oct 21, 2010 12:08 PM
The issue may be the manner in which you have implemented Custom Transfer. If you are able to manually open an FTP session and get the file then you know that the FTP account works.
Try this procedure:
1. In the DS Designer Guide, go to the chapter on File Transfers
2. At the end of the section on Custom transfer system variables for flat files, copy the script that is listed there
3. Paste the script into notepad and save it to your hard drive as myftp.bat
4. Use these custom transfer values:
Program executable: <path>\myftp.bat User name: FTPUSER Password: <password> Arguments: $AW_USER $AW_PASSWORD '<local_path>' 'TWS.xls' 'ftpd.rsc.dd.intra'
<path> is the path to the FTP executable on your Windows server
<local_path> is the path to where you want FTP to drop your file
ftpd.rsc.dd.intra is the remote FTP server that you specified earlier
In the job, Data Services will execute the this command string:
myftp.bat FTPUSER <password> 'local_path' 'TWS.xls' 'ftpd.rsc.dd.intra'
In the script, the arguments are assigned to variables in the order they appear, and the variables are used to generate an FTP command file. Finally, the FTP command string is executed.
Here is the code
echo off set USER=%1 set PASSWORD=%2 set LOCAL_DIR=%3 set FILE_NAME=%4 set LITERAL_HOST_NAME=%5 set INP_FILE=ftp.inp echo %USER%>%INP_FILE% echo %PASSWORD%>>%INP_FILE% echo lcd %LOCAL_DIR%>>%INP_FILE% echo get %FILE_NAME%>>%INP_FILE% echo bye>>%INP_FILE% ftp -s%INPT_FILE% %LITERAL_HOST_NAME%>ftp.out