Interoperability between the SAP Data Warehouse Approaches

SAP's Data Warehouse approaches are not isolated concepts. Instead, SAP puts a special focus on providing options to integrate them with each other. The interoperability of the application driven approaches of SAP BW/4HANA with SAP HANA data models is based both on external SAP HANA Views generated from InfoProviders and from integration options for SAP HANA artifacts in SAP BW/4HANA.

SAP Datasphere provides integration options and thus hybrid use cases as well:

1. Federated or replicated data consumption scenarios for SAP BW or SAP BW/4HANA using the following:
   1. SAP ABAP connection to InfoProviders, InfoObject Characteristics and Queries (released as InfoProviders) or ABAP Dictionary tables
   2. SAP HANA connection to database tables or SAP HANA Calculation Views (incl. external SAP HANA Views generated in SAP BW 7.5 on HANA or SAP BW/4HANA)
2. Federated so-called Business Semantics integration scenarios using SAP BW/4HANA Model Transfer connection provided by SAP BW/4HANA 2.0 SP07 onwards. This means SAP BW/4HANA provides business semantics of BW Queries and InfoProviders to be consumed in SAP Datasphere. This means, a BW Query is transferred as a number of native SAP Datasphere entities (KPI, analytic model) and the SAP BW/4HANA system only acts as a remote data source. The calculation and consumption is managed by the SAP HANA engines of SAP Datasphere.