Back to the Future with RelationalCube - ODBC Access to SAP Business Information Warehouse
SAP R/3 revolutionized ERP in the late 20th century and Business Information Warehouse (BW) looks to extend SAP's leading position in these early days of the 21st century. As SAP is a leading technology company, BW is furnished with modern APIs (OLE DB for OLAP and XML for Analysis) and the usual legacy API (RFC BAPI). What is curiously absent from this list is the industry standard ODBC API (or its cousin JDBC). This paper presents a SAP compliant method to retrieve data from SAP BW via ODBC / JDBC / SQL.