Author: Grzegorz Goli
Microsoft SAP BI integration
MS SQL Server BI tools can be integrated with SAP Netweaver BI with Integration Services (SSIS) and Reporting Services (SSRS).
General requirements both for SQL Server Integration Services and Reporting Services:
Access SAP BW data with Reporting Services (SSRS)
First, XML for Analysis (XMLA) needs to be installed on the SAP BI server and running. The SAP BI XMLA Connector makes it possible to connect to SAP BI from such data sources as Microsoft Analysis Services, Hyperion, MicroStrategy, MIS, and BW 3.x. This connector is fully compliant with the J2EE Connector Architecture (JCA) and may be deployed into SAP's J2EE Server.
Please refer to the following document for further details on SAP XMLA:
The video listed below shows a demo on how to connect from Reporting Services to SAP BW and how to design reports based on SAP data:
SAP SSRS video - a video that provides an example of how to integrate Microsoft SQL Server Reporting Services and SAP BW (SAP BI / SAP Netweaver).
Access SAP BW data with SQL Server Integration Services (SSIS)
The SAP BI connector enables data extraction from and to SAP NetWeaver BI in both Full and Delta modes via standard interfaces, within the Microsoft SQL Server Integration Services environment. The SAP datasets supported by the connector include SAP BI InfoProviders like InfoCubes, Data Store Objects (DSO), InfoObjects and InfoPackages.
Keep in mind that microsoft Connector 1.0 for SAP BI can only be used with SQL Server 2008 Integration Services. However, you can load data from or extract data to SQL Server 2008, SQL Server 2005, or SQL Server 2000 databases. Microsoft Connector 1.0 for SAP BI does not support SAP BW 3.5 and earlier versions.
Microsoft BI and SAP Netweaver integration resources
Useful links with information on Microsoft SQL Server BI and SAP Netweaver (SAP BW / SAP BI Business Intelligence) integration: