Show TOC

SAP HANA Smart Data AccessLocate this document in the navigation structure

In BW, SAP HANA Smart Data Access is used as the source for Open ODS views and for query access to data in Sybase IQ as a near-line storage solution.

With SAP HANA Smart Data Access, data can be merged in heterogeneous EDW landscapes (data federation). SAP HANA Smart Data Access make it possible to access remote data, without having to replicate the data to the SAP HANA database beforehand. The following are supported as sources: Teradata database, SAP Sybase ASE, SAP Sybase IQ, Intel Distribution for Apache Hadoop, SAP HANA. SAP HANA handles the data like local tables on the database. Automatic data type conversion makes it possible to map data types from databases connected via SAP HANA Smart Data Access to SAP HANA data types.

The following are example of activities that you can perform using SAP HANA Smart Data Access:

  • Make other data warehouses transparent for the BW system's SAP HANA database.
  • Consolidate your data warehouse landscape.
  • Consume SAP HANA data mart scenarios from a connected database.

When using SAP HANA Smart Data Access for query access to data in Sybase IQ as a near-line storage solution and as a source for Open ODS views, it offers the following advantages:

  • SAP HANA Smart Data Access optimizes execution of queries by moving processing as far as possible to the database connected via SAP HANA Smart Data Access. The SQL queries then work in SAP HANA on virtual tables. The SAP HANA Query Processor optimizes the queries and executes the relevant part in the connected database, returns the result to SAP HANA and completes the operation. If you connect and define facts and master data from the source via associations in the Open ODS view, facts and master data are joined directly at database level at query runtime, together with operations on the navigation attributes.

  • For Open ODS views, using SAP HANA Smart Data Access makes it possible to use data sources that are not managed by the BW system. It is possible when doing this to expand modeling in the BW system without significant effort, from direct consumption of the data source via the virtual table to using a persistent BW data store for ETL purposes.

Prerequisites
To use SAP HANA Smart Data Access as the source type for Open ODS views or for query access to near-line storage data, the following prerequisites apply:
  • You have installed the ODBC drivers for the databases that you want to connect with SAP HANA Smart Data Access.

    More information: SAP Hinweis 1868702 Information published on SAP site

  • You have connected the databases SAP HANA Smart Data Access as remote sources.

    More information: SAP HANA Administration Guide

    Pay particulate attention here to which databases are supported in which versions for SAP HANA Smart Data Access.

  • Note that the SAP HANA system authorization CREATE REMOTE SOURCE is required to create a remote source. If the remote source is not created with the SAP<SID> user but with a different database user instead, then this database user must assign the corresponding object authorizations to the SAP<SID> user (CREATE VIRTUAL TABLE and DROP).

    More information: SAP HANA Security Guide

  • The remote data is accessed from the BW system with the database user that is used for the connection of the BW system to the SAP HANA database. When creating a remote source in SAP HANA, you specified a user for the connection to the source database. SAP HANA passes the SQL statements on to this user. Make sure that this user has sufficient authorizations in the relevant schemas and tables in the source database.

    More information: SAP HANA Security Guide

Related Information