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

To report this post you need to login first.

23 Comments

You must be Logged on to comment or reply to a post.

  1. 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

    (0) 
    1. JΓΌrgen Noe

      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

      (0) 
  2. Mohamed Anas

    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?

    (0) 
      1. Mohamed Anas

        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

        (0) 

Leave a Reply