Share via

SSIS with SAP Connectors

  • Article

SAP AG (Systeme, Anwendungen und Produkte in der Datenverarbeitung ("Systems, Applications And Products in Data Processing"), based in Walldorf-Germany, is the largest business application and Enterprise Resource Planning (ERP) solution software provider in terms of revenue.

SAP's products focus on ERP, which helped the company to establish itself in the market. Company's main product is MySAP ERP, which is the successor of its former flagship product: SAP R/3, in which R stood for Real-time data processing, and 3 for 3-tier architecture.

SSIS supports SAP products in various ways see the list below:

By Name Data Access API Supported SAP Versions 64 bit Metadata support FAQ
Microsoft  .NET Data Provider for mySAP™ Business Suite ADO.NET SAP R/3 versions 4.6C and higher yes Can execute RFCs/BAPIs and SELECT queries against SAP table http://msdn2.microsoft.com/en-us/library/ms141761.aspx
Theobald Software Xtract IS ADO.NET SAP R/3 Rel. 4.0B or higher; SAP BW 3.1 or higher Yes Yes - Tables - Queries - BAPIs - BW Cubes - Legacy ABAP reports http://www.xtract-is.com
ETI SAP BTO Native: ALE, IDOC, navigational SAP R/3 yes ETI is building support for SAP BW to SSAS.

SAP/Microsoft Access Strategies

The following sections are notes about current access methods for SAP.

To Access SAP BW from Reporting Services

You can access SAP BW with the adapter for BW.  This adapter lets you report on the BEx queries and the infocubes.

This is documented in the following resource links:

SAP BW -> OHS -> SQL

Another option if one has purchased an OHS license they can pull data out of SAP BW.  When purchased you can then manipulate the data using SSIS and put it in SQL to access the data directly.  The benefit of this is that SAP has built intelligence into the BW roll-ups that can be leverage as opposed to trying to go after the SAP relational schema which is quite difficult.

SAP -> SQL

This is described above using the connectors.  When accessing the data using this method an understanding of the relational schema is needed and can be a challenge.   **Note: **This article has been ported over from http://ssis.wik.is/ Note: If you were the owner of above article, please update it to the latest version or with other appropriate information.