Skip to Content

BODS : Datastore options for SAP R/3 - need clarity for use

Hi All.

Another request to understand the datastore optiono n BOXI 3.1 BODS existing installation.

We are trying to pull a new table from SAP R/3 into BODS and we find that ABAP program is not getting generated as expected. And terminates. When we tested a simple workflow.

While creating a new datastore for SAP R/3 Source :

When we look at the datastore we find the following options for R3 Source ;

ABAP Execution option :

Execute preloaded

Generate and execute

Under data transfer method we find ;

Shared directory

Direct download


Custom transfer

Then we have working directory on sap server

local directory

generated ABAP Directory

Am testing a simple workflow of pulling data from SAP R/3 in a dev machine.

But am not understanding.

which option of ABAP Execution, and data transfer , path would work in co-ordination.

Because when i say direct download and say generate and execute it throws error.

Can anyone help me with combinations of the options to choose for a R/3 source. And the implications thereof.

I had created a folder under local bods server D:\Bodi. And given the path for data transfer.

But the files are not getting generated for whatsoever reasons.

Any advise on this would be helpful.

Also found a bit unusual, that there was no button to test the connection to be correct or not, a TEST connection button is not there. Which i felt, could be included.

Note : on the existing production system, we have chosen execute preloaded; shared directory on sap server. and shared that folder path for the user and given full rights. But while we try to do the same on the dev machine a test before transporting on production, a simple workflow does not work.

would like to know what settings on sap server, really affect the data store options on the BODS



Edited by: Indumathy Narayanan on Jul 19, 2011 4:14 PM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2011 at 03:38 PM

    Indeed, BODS <> SAP connectivity can be tricky.

    For a development environment, I suggest you select the option "Generate and execute" for your "ABAP Execution Option." What this means is that DS will create, on the fly, small-ish ABAP programs. These ABAP programs will be written, in plain text, to a local directory on the DS job server, in the folder specified in "Generated ABAP Directory". You can see them in there after an attempted job execution, assuming the job involves the creation of an ABAP program. The ABAP program name is specified in the properties of an ABAP data flow, under Options > ABAP Program Name. If you can't, perhaps the DS job server process doesn't have full rights to that folder - ? After being generated on-the-fly, they'll be transferred to SAP to execute. The SAP user you use to connect to SAP must have sufficient rights to upload-and-execute these ABAP programs, and that's a fairly substantial set of rights. What's required is documented in the BODS supplement for SAP. Often, to get things running, your friendly local Basis admin will grant SAP_ALL to the DS user, to see what rights are being invoked.

    Once all that jazz is working, you need to get the data back. There are a number of ways to do this. The method of data transfer is specified in "Data transfer method," where, ignoring "Custom transfer," you have three choices:

    1) Direct Download: easiest and slowest. This method tells SAP to attempt to stick data in the client-side folder specified in "Local directory." Try this first.

    2) Shared folder: This is recommended when you have SAP being hosted on a Windows box. Basically: you set "Working directory on SAP Server" and "Data Services path to the shared directory" to point to the same folder. SAP uses the "Working directory on SAP Server" to find this folder, and DS uses the other setting. So, for instance, if you were going to use the Shared folder method, you could set "Working directory on SAP Server" to "E:\BODS_Transfer", and, assuming E:\BODS_Transfer was shared-out as "BODS_Transfer", you could set "Data Services path to the shared directory" to\BODS_Transfer . Then, you'd need to setup all the relevant security, as both SAP and DS need rights to read and write files in this folder.

    3) FTP (this is the method I usually use): SAP writes the "transport files" you're after (i.e., the data) in the folder specified in "Working directory on SAP Server". Then, you need to establish ftp connectivity to that folder from the DS job server's perspective, which you do by entering the ftp host name and the path to that folder in "FTP host name" and "FTP relative path to the SAP working directory". In my opinion, the "relative" business is a little confusing, and I just typically enter the full ftp path, beginning the path w/ a forward slash, like "/usr/sap/tmp/BOBJ" or something like that. You also need to obtain a separate username and password for the ftp connectivity. Note that this name and password has NOTHING to do with the SAP username and password; you're just setting-up DS to act as an ftp client. I strongly encourage you to test ftp connectivity by using a regular ftp client from the DS job server and attempt to connect to your ftp host using the username and password you were given, and attempting to fetch some sample test file. If you can't do this, manually, then DS won't be able to do it, either.

    Best wishes,

    Jeff Prenevost

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Jeff.

      Thanks for the details. Really appreciate the info given to me. I understand that the whole process of Pulling data is easily done as a 2 step process. Yday had a discussion with a admin guy and we intend to do the following.

      On dev :

      create 2 connections ;

      conn1: generate and execute / direct download option; give local directory of BODS dev server.

      Generate the ABAP prog and .dat file.

      Send the ABAP prog to SAP team ( i dont have access to their servers) to create the prog and make it available.

      When the program is now available on SAP SYSTEM for use.

      Test it again with : Conn2: execute pre-loaded / shared directory.

      User on data store connection has full rights on the shared folder on the sap server. where the dat file is created.

      Test it now and check whether it works.

      Then move the program on SAP R/3 production.

      And check the same on BODS Production - using Execute preloaded option / with shared directory.

      all the jobs already are running on the shared directory as execute preloaded - connection.

      So the new job will also run that way.

      But we find a problem on dev machine :

      When we say generate and execute it is giving some crazy delimiters error.

      I dont know why. The same error does not happen on production.

      The same ABAP program is getting generated on prodn server without errors.

      This dev machine actually i re-constructed a month ago, since one fine day morning, the dev server machine had some Major OS problems and we got a brand new machine, and i restored the back-up of jobs after installing the entire BODS set-up on this new machine. While i thought everything was ok, i dont know what is differnt that is causing the problem on the dev machine.

      Upon search got to a link on SDN. Am not understand what is being said here :

      if you could also help me on this.

      Thanks again.



      Edited by: Indumathy Narayanan on Jul 21, 2011 10:08 AM

      Edited by: Indumathy Narayanan on Jul 21, 2011 11:32 AM

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.