Show TOC

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

You can create scenarios where data, which is modeled in the BW system, is merged with data modeled in SAP HANA with SAP HANA tools.

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 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 virtual access methods and data replication methods. The following list shows the various options and provides links to further information.

Availability of SAP HANA Data in BW:

  • Virtual Access

    • Access using CompositeProvider

      In a CompositeProvider you can flexibly combine data from multiple InfoProviders and SAP HANA views by using unions and joins. The use of a CompositeProvider is particularly recommended in cases where the SAP HANA view displays a complete star schema.

      You can find information in the BW Modeling tools, under Start of the navigation path Help Next navigation step Help Contents Next navigation step SAP - BW Modeling Guide End of the navigation path.

    • Access using Open ODS View

      Open ODS views enable you to define BW data models for external data such as database tables and database views of any SAP schema. These data models allow simple, flexible integration without the need to create InfoObjects. The data sources can be used virtually in BW.

      Modeling of Open ODS views takes place at the field level, but can be complemented by InfoObjects and gradually extended, in order to have a higher level of integration. Open ODS views allow you to switch between virtualization and dedicated Data Warehouse persistences and thereby provide a flexible entry point into replication scenarios.

      We especially recommend Open ODS views in cases where the format of the external data is suitable for integration into a data flow; in other words, when an external data model displays a pure fact view or a pure dimension view. Prerequisite for integration into a BW data flow: the source model must be divided into facts, master data and texts. Based on these units that can be replicated, Open ODS views allow you to model reporting views on data.

      More information: Open ODS View

  • Replication

    • Replication from SAP HANA tables using 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 using the ODP Source System

      You can use the ODP data replication interface to replicate data from attribute and analysis 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

Availability of BW Data in SAP HANA:

  • Creating SAP HANA views from the BW system for BW InfoProviders

    When activating InfoCubes, DataStore objects, InfoObjects, queries as InfoProviders (query snapshots) and CompositeProviders in the BW system, you can generate SAP HANA views.

    More information: Generating SAP HANA Views from the BW System

  • Creating SAP HANA views in SAP HANA for BW InfoProviders

    You can create SAP HANA modeling views (analysis views or calculation view) from SAP HANA-optimized InfoCubes, 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.

  • Replication from BW Objects using 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