cancel
Showing results for 
Search instead for 
Did you mean: 

FTP in Data Services

Former Member
0 Kudos

Dear gurus,

I am not able to extract data from FTP on dataservices.

I am giving my FTP xxx.xxx.xxx.xxx in the Host.

The UserID and the Password.

Now i am not able to access the file still.

Can you please guide me how to use FTP in Data Services.

Regards,

Den

Accepted Solutions (0)

Answers (2)

Answers (2)

Rishabh_Awasthi
Active Participant
0 Kudos

Please check for the  permissions on the file at FTP Location it should be rwx(777) .

Regards,

Rishabh

Former Member
0 Kudos

Any suggestions ??

paul_kessler
Active Participant
0 Kudos

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:

Link:http://wiki.sdn.sap.com/wiki/display/BOBJ/ftptransportmethod

Former Member
0 Kudos

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.

Awaiting reply.

regards,

Den

Former Member
0 Kudos

Here is what i am giving and still its not working::: Its not even able to access the file.

Host :: ftpd.rsc.dd.intra

User :: FTPUSER

Password :: Password

Directory ::

FILE:: /Data/in/TWS.xls

Kindly suggest if you have any answer.

Former Member
0 Kudos

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.

Thanks,

Suresh

Former Member
0 Kudos

Thanks Suresh. I am also checking but that doest really solve my problem.

Please let me know when you find your solution.

Regards N thanks again.

Den

paul_kessler
Active Participant
0 Kudos

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.

Paul

Former Member
0 Kudos

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.

regards,

Den

paul_kessler
Active Participant
0 Kudos

Is DS installed on Windows or Unix?

Former Member
0 Kudos

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 ?

Regards,

Den

Edited by: Dennis on Oct 21, 2010 11:29 AM

Edited by: Dennis on Oct 21, 2010 12:08 PM

paul_kessler
Active Participant
0 Kudos

Dennis,

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.

Former Member
0 Kudos

Thanks a lot Paul.

I am sorry to drag this as i couldnt still find the solution because i am unable to find that program in the designer guide.

If you can help me out furthur with the script or the program it will help.

Thanks,

Den

Former Member
0 Kudos

Any suggestion guys ??

Former Member
0 Kudos

Look in SAP Business Objects Data Services Designer Guide

.....FIle formats

..........FIle transfers

Read the section on custom transfer system variables for flat files. The script is at the end of this section.

Paul

Former Member
0 Kudos

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

Former Member
0 Kudos

Is this is an errors in last row?

1. -s where is colon?

and

2. INPT_FILE - INP_FILE like in 7 row.

Or i'm wrong?