SAP HANA Reporting Client Connectivity
ODBO:OLE DB for OLAP ODBC:Open Database Connectivity JDBC:Java Database Connectivity BICS: BI Consumer Services.
Posts
SAP BW on HANA
SAP BW Performance These figures were reported by customers, which already have BW on HANA operating in their IT landscape. 1. Red Bull Red Bull started to run its SAP NetWeaver 7.3. Business Warehouse on HANA in 2011. The migration. Non-disruptive fast migration. Project completed in less than 2 weeks. Database size before migration: 1.5 TB; reduced by 80% after migration. The result: Boost in load performance. Simplified architecture: InfoCubes no longer required as an aggregation layer Data can be read directly out of the DataStore Object (DSO). Replication of data to InfoCubes and Business Warehouse Accelerator (BWA) Indexes no longer necessary. 2. Utilities industry representative This utilities customer also upgraded to and operated its SAP Netweaver 7.3. BW on the latest HANA database release. Data Load Performance For DSO activation of 5.2 million records, performance improved by factor 32x. Before: 21 hours 40 minutes - After: 40 minutes. Data load into