Skip to Content
Author's profile photo Former Member

Step by Step for establishing RFC Connection between SAP-BW & Data Service

There are many descriptive documents, which talks about the RFC Connections between Data Services and BW, but I created this blog thinking that it will be much more helpful if the same is provided with appropriate screen shots.

I assume that before creating the RFC Connections, Data Services is installed and your BASIS has already imported SAP delivered Functions in the SAP BW Server. These functions are provided in the form of two transport files.

Following are the steps:

  • Installing Functions on the SAP Server
  • Creating RFC Connection in BO Data Services
  • Creating RFC Connection in BW
  • Install Authorizations

Overview with SAP Provided Diagram

SAP Provided.gif

This blog only will focus on the RFC Connection establishment between 2 servers.

Create RFC Connection in Data Services

1. Logon to Data Services Management Console

/wp-content/uploads/2013/07/clip_image002_246947.jpg

2. Go to SAP Connections – > RFC Server Interface

/wp-content/uploads/2013/07/clip_image002_246947.jpg

3. Click on RFC Service Interface

/wp-content/uploads/2013/07/11_246949.jpg

4. Select Tab RFC Server Interface Configuration

/wp-content/uploads/2013/07/12_246953.jpg

5. Select Add -> Provider necessary server parameters

    Note: In the parameters, the Program ID is the one which you need to provide. You

       can provide any name based on the naming convention your client prefers.

Ex: Program_ID: XX_YYYY

/wp-content/uploads/2013/07/13_246954.jpg

Click on Apply.

The program ID which you are going to define will be used in SAP BW Server ( or any other SAP Server).

6. Select Tab RFC Server Interface Status.

     Now you should be able to view the Server Interface name starts with the Program ID which you have provided.

    

    Select the check box for the Server Interface and click on Start. If all the parameters are appropriate then the server instance will start with a Green status.

/wp-content/uploads/2013/07/14_246955.jpg

With the above step you have created the RFC connection in Data Services. Now remember the Program_ID.  

In the next two steps I will talk about the RFC Connection in SAP BW. 

7. Now logon into the SAP BW.

    Use Transaction SM59 to create the RFC Connection.

/wp-content/uploads/2013/07/15_247581.jpg

Expand TCP/IP Connection, then Select Create.

/wp-content/uploads/2013/07/16_247582.jpg

The Program ID is the one which you have already created in DS Management Console.

Then once you click the Connection Test button you should see the message Connection Successful.

At this point your RFC Connection configuration is ready in both the systems ( DS & BW) and both the systems are ready for data transfer.

Assigned tags

      30 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ina Felsheim
      Ina Felsheim

      Excellent summary. We get questions about this all of the time.

      Author's profile photo Former Member
      Former Member

      Great explanation and tons of thanks for sharing

      Author's profile photo Former Member
      Former Member

      Excellent explanation and Thank You very much for sharing.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you for the feedback.

      Regards

      Shankar

      Author's profile photo Amarendra Prakash Mukharjee
      Amarendra Prakash Mukharjee

      Excellent Blog.

      Author's profile photo Former Member
      Former Member

      Dear Shankar,

      Good Summary.. and thanks for detail explanation... 🙂

      Keep it up.. 🙂

      Regards

      Kiran N

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you, Kiran.

      Author's profile photo Former Member
      Former Member

      Nice  way to explain..very impressive.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you for the feedback, Mayank.

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice information shared by you......

      🙂

      ~SM

      Author's profile photo Former Member
      Former Member

      Well explained Shankar... Great work!!!

      Ravi K.

      Author's profile photo Sabat S
      Sabat S

      Good explanation...

      Author's profile photo Former Member
      Former Member

      Very nice and help full...Shankar...

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you, Yugandhar.

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Very nice 🙂

      Regrads,

      Sm

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Satendra.

      Author's profile photo Former Member
      Former Member

      Can same rfc program id can be use for the different servers simultaneously ??

      Author's profile photo Derek Zhang
      Derek Zhang

      Hi Shankar,

      can we establishing RFC connection to a Cluster BW server? how can configure?

      Thanks,

      Derek

      Author's profile photo Nagabhushanam Gorantla
      Nagabhushanam Gorantla

      Good one Shankar.

      Regards

      Nagabhushanam

      Author's profile photo Former Member
      Former Member

      good explanation

      Author's profile photo Former Member
      Former Member

      Does it require a separate authorization to BW system? I am not able to click on NEW in TCP/IP connection.

      Author's profile photo Former Member
      Former Member

      Yes, Basis admins will create the RFC connection..

      Author's profile photo Former Member
      Former Member

      Thank you for the info.. shankar garu. worth a lot!!

      Author's profile photo k laxman
      k laxman

      thank u for ur info

      Author's profile photo Former Member
      Former Member

      how would you then go about defining a real time job that SAP can call?

      Author's profile photo Former Member
      Former Member

      What are the mentioned SAP delivered functions? Where are the 2 transport files we need to import them?

      Author's profile photo Former Member
      Former Member

      How do we load balance the RFC connection in BODS 4.0 to multiple messages server in BW/BI 7.3?

      Author's profile photo Former Member
      Former Member

      Hello Hari,

      Were you able to successfully do this setup ?

      i.e. RFC connection in BODS to multiple message server in BW/BI 7.3

      Regards,
      Krupali

      Author's profile photo Former Member
      Former Member

      Hi,

      Just to add, Program ID can be created either at BODS or SAP end, we just need to ensure same name is used across both environment.

      Thanks

      Shashi

      Author's profile photo Srinivas Popuri
      Srinivas Popuri

      If got multiple servers with different sapgwxx -> sapgw01 and sapgw02.  How to configure connection?

       

      SP