Open HubBI Connector

SQL 2005 Integration Services

SAP R/3

SAP BW/Net-

Weaver

RFC ADO.Net

Microsoft .Net Provider for SAP NetWeaver Business Intelligence

SAP connector for Microsoft.NET

SQL 2008Data Mart

SQL 2008AnalysisServices

SQL 2008Reporting Services

Excel

Office SharePoint Server

XML/A

Microsoft Connector 1.0 for SAP BI

Overview:◦ Reporting Services as a client tool for SAP BW,

using Microsoft .Net Provider for SAP NetWeaverBusiness Intelligence

Issues addressed:◦ SAP BW reporting

◦ Uses SAP security (no additional layer)

Known issues:◦ Provides support for InfoCubes, QueryCubes and

Multiproviders only. ODS objects can be exposed through QueryCubes.

Issues addressed◦ Flexibility to incorporate non-SAP data sources◦ MOLAP technology - better performance and scalability

Known issues◦ SAP security applied only at time of export; need to

maintain security in Analysis Services◦ Customer needs to purchase SAP OHS license

Prerequisites◦ SAP NetWeaver SPS 14 (BI SP 16) is required. BI SP 17 or

higher is strongly recommended.