SAP BW Bridge – Integrating with On-Premises ECC / BW servers

[vagarwal1]

To begin with, first we need to add on-Premises server to SAP Cloud connector.

Login to SAP Cloud connector as Administrator.

Go to the path: Sub-account -> Cloud To On-Premise

Click on ‘+’ symbol to add new server.

In Add System Mapping, select Back-end Type as ‘ABAP System’

Select protocol as ‘RFC’.

Choose the option with / without load balancing, since mine is single instance server, I have chosen second option.

Enter the application name as FQDN “<host>.<domain>.com” and server instance no.,

Give a virtual name of the server, that will be used as reference in SAP BW Bridge.

Provide meaningful description.

Check the box ‘Check internal Host’ and click on finish.

Check the server status, it will show as reachable.

Download the resources for R/3 On-premises server from below snote:  3112568

Upload the resources for newly added server by clicking on up arrow.

In the Import Scenario, browse and select the zip file for ODP resources.

Once imported status will be ‘Green’ and function name will be like below.

Login to SAP BW Bridge with administrator privileges and select Administration - > ‘Communication Management’

In Communication Management select ‘Maintain communication Users’

Select ‘New’ communication user to be added.

Provide the Name and description of the user. For password either you can provide complex password or select random generated password with option of ‘Propose Password’. Click on create.

A new user ID will be created for the given user.

Return the Communication Management page and click on Communication Systems.

Select the ‘New’ option to create new communication server

Provide the reference name and system ID and click on create.

For the new system, under Technical Data under general, provide the server’s name and port no., as created in SAP Cloud connector.

Switch ON the cloud connector and provide the location ID.

For RFC settings, provide target host name as virtual host name in SAP cloud connector, for Client – 100 and Instance no# 00.

Add the user for Inbound communication

Select the user created as communication user and click OK.

Similarly for the outbound communication provide the user ID created in R/3 server.

Save the configuration.

Return to Communication Management and select “Communication Arrangements”.

Select new communication arrangement.

Select the Scenario as ‘SAP_COM_0692’ (SAP BW Bridge – ODP RFC Source system Integration) and give a name and click on ‘Create’.

Select the newly created Communication system.

Select the backend system ID as created in eclipse tool as source system.

Validate the Inbound and Outbound user and click on save.

Login to backend R/3 server and transaction code ‘SM59’ and create a new RFC connection.

Create the RFC connection of type ‘3 – ABAP ‘ as shown below.

RFC Destination : ‘Own SAP Cloud system’ name of BW bridge.

Target host: SAP Cloud connector FQDN (without https and port no#).

Instance no# 00

Under logon & Security enter the Inbound User ID & Password created for Communication user and save the settings.

Click on Test RFC connection and it will show connected.

We have successfully added backed R/3 server to SAP BW Bridge.