Skip to Content
Author's profile photo prabhith prabhakaran

BW-BODS Integration – Part 1

Hi All,

These days, BODS is playing a very important role in the SAP system landscape.

Many customers use BODS to pull data from Non-SAP systems to SAP BW.

These documents are primarily intended for BW consultants who would like to know more about the Integration, Modelling and Transport mechanism related to BODS.

In this part 1 document, we will go through how to integrate BW and BODS using RFC connection.(This topic has been explained many a times in SDN. For making 2nd and 3rd part more meaningful, I have included the integration as Part 1.

Part 2 will help you to understand how modelling is done in BODS with BW as the data target (http://scn.sap.com/docs/DOC-52550)

Part 3 will help you to understand the transport mechanism in BODS(http://scn.sap.com/docs/DOC-52808)

Environment:

BODS – Version is 14.0.3.273(Also BO and BODS are installed in the same server)

/wp-content/uploads/2013/11/1_328227.png

BW – BW7.3 (where BODS is now available in the source systems list in BW)

/wp-content/uploads/2013/11/2_328229.png

BODS/BO server is running on Windows platform and the BW OS is HP-UX and database is Oracle.

Step 1:

Login to RSA1 Source systems and create a new connection under BO Dataservices.

Please note that for all BW versions prior to 7.3, you will not see BODS as a source system.

In such case, you will have to depend on ‘External System’ source system type for creating the connection.

/wp-content/uploads/2013/11/1_328227.png

Right click on BODS and press create

/wp-content/uploads/2013/11/2_328229.png

Give the required credentials

/wp-content/uploads/2013/11/3_323548.png

Give the Logical system name(in this case – BODSPB1) and Source system name(description and in this case it is Logical system for SAP BODSPB1) .Type and release is not mandatory.

Give a Program id (in this case it is SAPBODSPB1) . This is a very important step.

/wp-content/uploads/2013/11/4_323552.png

Important point to be noted here is that when you give details for external source system in RSA1,better dont give the gateway host and gateway service in case if you are not 100% sure about it(in simple words, keeps them blank)

See discussion here –> http://scn.sap.com/thread/3247518

The system itself will manipulate it(default gateway value) with the program id, provided you give the same(case sensitive) in both the ends(BW and BODS)

/wp-content/uploads/2013/11/5_323553.png

Save and go back and give the required credentials..

Give credentials like BODS Repository, Job Server, Back ground BW user, Password and so on.

/wp-content/uploads/2013/11/7_323554.png

The same can be seen in SM59 also under TCP/IP connections.

/wp-content/uploads/2013/11/6_323555.png

Now BO Dataservices will have a connection names BODSPB1 under it.

/wp-content/uploads/2013/11/8_323556.png

Now log into BODS Management console and give the corresponding BW server details.

The required BW credentials can be obtained in the context menu of the BW server in the SAP Logon pad.

/wp-content/uploads/2013/11/3_323548.png

RFC Program id is the same one SAPBODSPB1(case sensitive) which we had given in BW side.

/wp-content/uploads/2013/11/9_323588.png

The user used here is of type Service User.

/wp-content/uploads/2013/11/42_328232.png

For RFC to work as expected, the status should be in STARTED state.

/wp-content/uploads/2013/11/10_323589.png

Check the RFC connection in SM59 by using Test Connection option.

The connection test should be successful.

/wp-content/uploads/2013/11/11_323590.png

There can be lot of issues which might come in between during the configuration,and it depends on the  landscape in which you work:

Anyways, please find some points which you can check if you encounter any issues in between.These were  some of the solutions that were given by experts when we were facing some challenges in integrating BW with BODS.

1) There can be a problem in the gateway; you need to contact your basis team for this issue.The gateway for BW might not have been opened to connect the BODS server, for checking this we need to ping the command telnet <hostname of BO server> 3300 in the BW server. If it’s not listening, then gateway is the culprit.

2) Change the gateway to its port number.Find the port number in the services file (windows\ststem32\drivers\etc\) of a machine with the sap GUI installed.There is a chance that your BODS server doesn’t have the sapGUI installed and doesn’t have the services file and thus can’t translate the gateway name to a port number. Installing the sapGUI may also fix an issue setting up the RFC but not being able to see it in the list of available RFC connections in the BODS console.

3) Check the SAP system number. The gateway service should SAPGWXX where XX is ur SAP system number.

Hope this was useful. 😉

Regards,

Prabhith

Assigned Tags

      25 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Prabhith,

      Very nice and useful blog. Thanks for sharing with us.

      Waiting for the other 2 blogs.

      BR

      Aakash

      Author's profile photo prabhith prabhakaran
      prabhith prabhakaran
      Blog Post Author

      Thanks a lot, Aakash... 🙂

      Author's profile photo Former Member
      Former Member

      Hi,

      nice one.,.

      Waiting for the 2 other docs...

      Regards

      LK..

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Hi Prabhith,

      Really very good and nice blog.  Thanks for sharing.

      Regards,

      Krishna Chaitanya.

      Author's profile photo Former Member
      Former Member

      Hi Pratibha,

      Very informative blog..thnks for sharing...!!!

      It adds one topic extra in my till now BODS knowledge... 🙂 🙂

      Author's profile photo prabhith prabhakaran
      prabhith prabhakaran
      Blog Post Author

      Hi All,

      Thanks a lot. Glad to see your comments..

      Just started preparing the 2nd and 3rd Part. Might take some time to publish..

      BR

      Prabhith

      Author's profile photo Former Member
      Former Member

      Very Nicely document created.

      Regards,

      Sushant

      Author's profile photo Former Member
      Former Member

      Very informative blog .Waiting for the next 2

      Author's profile photo Former Member
      Former Member

      Hi,

      Good one , Prabhih..

      Regards,

      PK

      Author's profile photo Martin Grob
      Martin Grob

      Good to know thanks for sharing

      Author's profile photo Rishabh Singhania
      Rishabh Singhania

      nice doc.

      thanks for sharing.

      waiting for part 2and 3.

      Regards,

      Rishabh

      Author's profile photo Former Member
      Former Member

      Hi,

      Some new piece of information for me.

      Thanks Prabhith

      Regards'

      Amrith//

      Author's profile photo Venkateswaran (Venkat) Krishnamurthy
      Venkateswaran (Venkat) Krishnamurthy

      Useful document for me.

      I bookmarked it.

      Author's profile photo Harish Allachervu
      Harish Allachervu

      One more kudos blog after housekeeping activity in BW series.... 😆

      eagerly waiting for other 2!!!!

      Regards,

      Harish

      Author's profile photo Former Member
      Former Member

      Very informative. Thanks for sharing

      Author's profile photo Manna Das
      Manna Das

      Thanks for this wonderful explanation of BODS.

      Author's profile photo Kodanda Pani KV
      Kodanda Pani KV

      Its really wonderful document.

      Thanks,

      Phani.

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      I have been hearing about BODS for a while and after going through your document i got a bit of idea on how it works.Thanks for sharing this.


      Can  BODS be considered as replacement for UD connect or DB connect plz confirm ?


      Regards,

      AL

      Author's profile photo Former Member
      Former Member

      Hi Anshu,

      BODS is "premium" alternative to UDconnect or DB connect from my understanding.

      If you just want to connect to a db and load simply table contents into BW, BODS is too much overhead. But if you have to do some transformations, harmonizations, etc. on that table, then give BODS a try.

      Regards,

      Jürgen

      Author's profile photo Former Member
      Former Member

      Am just learning BODS..This documents is very helpful for me..Thanks for sharing it..

      Regards,

      Shaan..

      Author's profile photo Former Member
      Former Member

      I am not able to run the job from BW side by clicking on start inside info package and it take very long time without success

      But When I am running the job from Data Services it is completed successfuly

      Is this related to that when I am creating Source System I didn't select source data store name?

      Author's profile photo prabhith prabhakaran
      prabhith prabhakaran
      Blog Post Author

      Hi Mohamed Anas,

      Are you filling the 3rd party selections tab correctly(job name, repository, job server and all)

      BR

      Prabhith

      Author's profile photo Former Member
      Former Member

      I am filling 3 from 4 options (Repository,Job Name,Job Server) and I am leaving advanced empty

      When I am trying to rub the infopackage fr om BW It is running forever so I am turning to be red and remove the request then I am executing directly from the designer

      Author's profile photo Araki Vupico
      Araki Vupico

      Hi Mohamed Anas,

      I am also facing the same issue...

      did you get any solution for this.

      When I check the details of the process while info package is running and is in yellow state for longer time I am seeing a message saying "No IDOCS received from Source System".

      Could you please reply this with the solution you got.

       

      Best Regards,

      Anil K

       

      Author's profile photo Araki Vupico
      Araki Vupico

      Hi Prabhakaran,

      Very Nice and simple to understand blog.

      I am facing an issue…

      I am not able to run the job from BW side by clicking on start inside info package and it take very long time without success, But When I am running the job from Data Services it is completed successfully.

      When I check the details of the process while info package is running and is in yellow state for longer time I am seeing a message saying “No IDOCS received from Source System”.

      Could you please reply this with the solution you got.

       

      Best Regards,

      Araki