FTP data transport

dataservices sap-erp-bw
1

Hi guys,

Just want to ask regarding the parameters of DataStore when creating a SAP BW source.

Our environment is as follows:

SAP BW - Linux OS
Data Services - Windows OS

Now, we decided to use FTP as data transport method. I would just like to ask what would be the part of the “Working directory on SAP server” in the DataStore parameters.

The “Working directory on SAP server” and “FTP relative path to the SAP working directory” should be the same based on the wiki. What would be the consequences of having different OS environments?

Thank you very much

R.A. :philippines: (BOB member since 2008-10-28)

2

The working directory is the path used inside the ABAP code. There we will open a file for writing in the working directory. So that would be a Linux pash in your case.

Once the file resides there, the jobserver will start an ftp client, connect to the linux server and send the change-directory command: cd ftp-relative-path.

So assuming your ftp server is configured to have as a root directory the root directory of the server, the path will be the same. But very often the ftp server uses a different directory as root, hence the path might be slightly different. Nevertheless it is a Linux path in your case as well.

Example:

Working directory: /sapmnt/trans/werner/files/
FTP server root directory points to /sapmnt/trans/

So when you open the ftp connection and type “cd /” you will find all files and directory inside the /sapmnt/trans OS directory.

Hence the relative path would be: /werner/files/

PS: Keep in mind, these parameters are required only in ABAP dataflows. If you use OpenHub, then all these settings can be set to anything. I know, why do you need to set them even in the datastore dialog then??

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

3

Thanks for the quick reply Werner.

I am sorry but please clear me on this. When using OpenHub we don’t need to setup this things??? Sorry because I haven’t tried OpenHub yet. BW team is still setting up the OpenHub connection.

EDIT

Is that the reason why there is the new RFC thing in 3.2 SP2/SP3? If we use OpenHub it will go through the RFC not through the conventional data transport methods???

Thank you very much.

R.A. :philippines: (BOB member since 2008-10-28)

4

precisely

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

5

Thanks Werner! I’m at ease now… Hehehe!

R.A. :philippines: (BOB member since 2008-10-28)