OneZero

SQL BI & SAP BI (connectivity etc)

Folling the TeraData posting I got a lot of...

"So, you can connect to Teradata, but what about SAP?"

Directly from Reporting Services

Summary: This paper discusses the integration of SAP NetWeaver BI ® with Microsoft ® SQL Server ® 2008 Reporting Services (SSRS). The paper provides an overview of using the Reporting Services SAP Netweaver BI data provider and related query designer, to build high quality reports against SAP NetWeaver BI sources. For Reporting Services users who are new to working with SAP NetWeaver BI, this paper will help you connect and build datasets. For users already familiar with SAP NetWeaver, the paper will show how some of that system’s notable features can be leveraged in Reporting Services reports. It also presents some tips and tricks that can help you make the most of the integration between the two products.

http://msdn.microsoft.com/en-us/library/cc974473.aspx

(note: Support Package 20 for SAP BW 3.5 required)

EPR-Link @  http://www.erp-link.com/html/partner/partner-ms-relationship.asp 

Usable SAP Information Objects
SAP R/3 Query Objects
SAP R/3 Report Objects
SAP R/3 BAPIs/RFCs
SAP R/3 Table Views
BW ODS Queries
BW InfoCubes
BW Cube Queries

Staging

Microsoft-SAP Technical Guidance @ http://www.microsoft.com/isv/sap/technology/interop/bi.aspx

also have a look at using the .Net SAP Adaptor (call from SSIS, map and import...) relevant for the R/3 (non BI) installs

Published Monday, December 22, 2008 3:21 PM by Paul Hand's Blog

Comments

No Comments
Anonymous comments are disabled

© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Microsoft
Page view tracker