Transferring Data with an SAP HANA Source System

For BW systems running on the SAP HANA database, the SAP HANA source system provides central and unified access to sources that are provided using SAP HANA smart data integration or SAP HANA smart data access. It also allows access to tables over views on the local SAP HANA database.

The SAP HANA source system can therefore replace DB connect and UD connect.

  • DB connect can be replaced by the connection types Once logical system per DB schema and HANA Smart Data Access in their entirety with the new SAP HANA source system with the connection types Logical SAP HANA database schema and SAP HANA Smart Data Access.

  • With the connection type Source system = DB connection , DB connect and UD connect can be replaced, since the SAP HANA source system also allows access to SAP HANA smart data integration (SAP HANA SDI) and various delivered database adapters, thus supporting real-time replication. For new source system connections to external databases, we advise SAP BW customers to check the availability of a suitable SAP HANA adapter. For more information, see http://help.sap.com/hana_options_eim.

SAP HANA Smart Data Integration

With SAP HANA smart data integration, SAP BW provides a means of integrating external data into the SAP BW. Smart data integration allows data from various sources to be accessed in real time or transferred to the SAP BW.

Smart data integration enables real-time data procurement, faster data procurement, mass data transfer, and federation. The connection to the external sources takes place using data provisioning adapters. Smart data integration provides adapters for a range of sources and allows custom adapters to be developed using an SDK.

System requirements and prerequisites for SAP HANA smart data integration

  • The minimum requirement for SAP HANA is Support Package Stack (SPS) 10. Note, however, that a large number of adapters have been added with SAP HANA SPS 11. For more information, see the Product Availability Matrix for SAP HANA smart data integration.

  • The SAP HANA smart data integration option is imported to SAP HANA.

  • The required data provisioning agents are installed and the data provisioning adapters are configured.

  • The required remote sources have been created.

Use

You can access the data virtually using Open ODS views and CompositeProviders. Data transfer is supported in full mode for all sources, provided the source supports this (generic delta).

For many data provisioning adapters, real-time replication is supported with the SAP HANA source system.