Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BODS / SAP : what set-ups are required for communicating with each other ?

Hi.

There is a new SAP system

And there is a new BODS installation.

Both on independent server machines but on the same lan network.

On the test system of BODS. We tried to see how the communication happens with SAP.

While we try some test jobs by trying to pull a simple table on SAP R/3

In Dataflow, we used simple SAPR/3 ABAP flow. And put it into target database thro query transformation.

In the datastore,

We used the Generate and Execute option,

with a path on the local directory of BODS server for creating the ABAP program and the dat file.

However,

We are always getting error on batch job schedule.

Although the user is having rights on the R/3 table

And can login into SAP R/3 system and check the table.

Still we get an error saying Databstore unabel to connect to R/3 system. Check for user login etc.

For anyone whose login we use. We get the error.

However, if i directly generate the code on the ABAP flow (without running the job),

make the program available on R/3 system.

and then run the job as execute preloaded

this works fine without any error.

and we are able to see the data in the target table.

Now both the systems are new.

And am not aware of the initial set-ups which are required for communication between SAP / BODS.

Are WE missing something on the SAP side setups - for generate and execute option to be used?

Is there anything specific to be done for ease of the communication between SAP server and BODS server in this regard.

Can anyone share some inputs on this.

Actually for any user with full admin rights too, on the sap side, if we use the user login for R/3 connectivity for this particular "generate and execute" option, it errors out after nearly 10 minutes. Then the error says, login info not correct.

So basically, the communication channel by itself between SAP R/3 and BODS seems to be locked somewhere.

If anyone with SAP admin expertise - can help or advise on this.

Many thanks

Indu

Edited by: Indumathy Narayanan on Sep 13, 2011 9:20 PM

Not what you were looking for? View more on this topic or Ask a question