Skip to Content
0
Former Member
Oct 18, 2010 at 09:06 AM

Connectivity between SQL Serevr 2008 and SAP BW using Microsoft Connector

167 Views

Hi

While connecting SAP BW to SSIS 2008 (SQL Server Integration Services). I created RFC connection on SAP BW server.

The Connection Test is failed on SAP BW ssystem. Then put a random string in Program Id, (Say ABC) at both the side

(in SAP BW and SSIS ). Though the RFC Connection test is failed, I am able to pull the data.

Can anyone explain entire architecture of this connectivity.

How the process is able to pull the data, though the RFC test failed on SAP BW server.

What is the role of RFC connection in overall connectivity.

Is registered Program Id should be used while creating RFC connection.

Thanks

Edited by: ssissap on Oct 18, 2010 11:07 AM