Show TOC

Merging Data from BW and SAP HANA (Mixed Scenarios)Locate this document in the navigation structure

Use

When a BW system is running on SAP HANA database, the BW data is stored in a special schema known as the BW-managed schema. In other SAP HANA schemas, data can be stored in SAP HANA tables or modeling views. You can now make data available from any SAP HANA database schema of your choosing in BW. You can also make BW data (data from the BW-managed schema in the SAP HANA database) available in a different SAP HANA schema. You can use data replication methods and virtual access methods. The following list shows the various options and provides links to further information.

Availability of SAP HANA Data in BW:

  • Replication

    • Replication from SAP HANA Tables via DB Connect

      You can use DB Connect to replicate data from SAP HANA database tables in BW for further processing. The data from the relevant schema in the SAP HANA database (where the tables are located) is replicated to the BW schema of the SAP HANA database in the BW system. Replication is supported both for the SAP HANA database that the BW system is running on and for external SAP HANA databases. In both these cases, the SAP HANA database must be connected to the BW system as a DB Connect source system.

      For further information about using DB Connect for replication from database management systems, see Transferring Data with DB Connect

    • Replication from SAP HANA Modeling Views via the ODP Source System

      You can use the ODP data replication interface to replicate data from attribute and analytic views in an SAP HANA database in BW for further processing. Replication is supported for the SAP HANA database that the BW system is running on, and also for other SAP HANA databases that ABAP systems are running on. Important: The SAP HANA database (or the ABAP system running on the SAP HANA database) must be connected as an ODP source system to the BW system. You can also use the ODP source system to load master data directly from the SAP HANA modeling views into InfoProviders. Data persistence in the PSA is optional.

      More information: Transferring Data Using Operational Data Provisioning

  • Virtual Access

    • Accessing SAP HANA Data Models via TransientProviders

      You can publish SAP HANA models from schemas of the SAP HANA database that the BW system is running on as analytic indexes. The system takes an analytic index and generates a TransientProvider on it. You can merge the TransientProvider with other InfoProviders in a CompositeProvider. This function allows you to use the OLAP functions in the BW system to analyze the SAP HANA models. This is particularly suited for ad hoc scenarios.

      More information: Creating TransientProviders on SAP HANA Models

    • Accessing a SAP HANA Model (Including Virtual Master Data) via VirtualProviders

      You can create a VirtualProvider based on a SAP HANA model. You can merge the VirtualProvider in a CompositeProvider or MultiProvider with other InfoProviders. This function also allows you to use the OLAP functions in the BW system to analyze the SAP HANA models. It is suited for more stable and longer term scenarios however.

      More information: Creating VirtualProviders Based on an SAP HANA Model

Availability of BW Data in SAP HANA:

  • Replication from BW Objects via the Open Hub Destination

    Using an open hub destination, you can write data directly to a different SAP HANA database.

    More information: Database Tables as Destinations

  • Creating SAP HANA Views for BW InfoProviders

    You can create SAP HANA modeling views (analytic views or calculation view) from SAP HANA-optimized InfoCubes, SAP HANA-optimized DataStore objects and from queries as InfoProviders (query snapshot). You can use the views generated to make BW data available for analysis with BW tools, such as SAP BusinessObjects Explorer or the SAP BusinessObjects BI Suite.

    For more information, see the SAP Help Portal at Start of the navigation path http://help.sap.com/hana_appliance Next navigation step Development Information End of the navigation path in the SAP HANA, under Importing BW Objects.