1868209 - SAP HANA Smart Data Access: Central Note

Symptom

This is a SAP note with specific information about SAP HANA smart data access.

Other Terms

data federation, query federation, SAP HANA appliance, SAP HANA platform,

Reason and Prerequisites

You are using the SAP HANA platform as of SPS06. With SAP HANA SPS06 SAP HANA smart data access has been shipped for the first time.

Solution

1. What is SAP HANA smart data access?
SAP HANA smart data access enables remote data to be accessed via SQL queries as if they are local tables in HANA, without copying the data into SAP HANA. Not only does this capability provide operational and cost benefits, but most importantly it supports the development and deployment of the next generation of analytical applications which require the ability to access, synthesize and integrate data from multiple systems in real-time regardless of where the data is located or what systems are generating it.
Specifically, in SAP HANA, you can create virtual tables which point to remote tables in different data sources. Customers can then write SQL queries in SAP HANA, which could operate on virtual tables. The HANA query processor optimizes these queries, and executes the relevant part of the query in the target database, returns the results of the query to HANA, and completes the operation.

2. Where to find SAP HANA smart data access documentation?
For SAP HANA documentation, see SAP Help Portal:
http://help.sap.com/hana_platform

For SAP HANA smart data access docu, specifically see:

• What's New in the SAP HANA Appliance Software (Release Notes)
  http://help.sap.com/hana/Whats_New_SAP_HANA_Platform_Release_Notes_en.pdf ==> chapter Data Provisoning

• SAP HANA Master Guide
  http://help.sap.com/hana/SAP_HANA_Master_Guide_en.pdf
  ==> chapter SAP HANA Use Cases -> SAP HANA Data Provisoning -> SAP HANA Smart Data Access

• SAP HANA Security Guide
  http://help.sap.com/hana/SAP_HANA_Security_Guide_en.pdf
  ==> chapter Security for Other SAP HANA Platform Components -> SAP HANA Smart Data Access

• SAP HANA Administration Guide
  http://help.sap.com/hana/SAP_HANA_Administration_Guide_en.pdf
  ==> chapter HANA Data Provisoning

• SAP HANA SQL reference
  http://help.sap.com/hana/SAP_HANA_SQL_Reference_en.pdf
  ==> search for remote source
  

3. Supported remote sources by SAP HANA smart data access
as of SAP HANA SPS07:

• Oracle 12c, Microsoft SQL Server 2012, Teradata ver13,14, IBM DB2 LUW ver10.1
• Sybase IQ: version 15.4 ESD#3 and 16.0
• SAP Sybase Adaptive Service Enterprise: version 15.7 ESD#4
• SAP Sybase ESP 5.1 SP04
• Apache Hive 0.9.0. or higher and Simba HiveODBC driver
• SAP HANA (BW on HANA, Suite on HANA)
• SAP MII 15.0 (SAP Note 1984859)

as of SAP HANA SPS08:

• Netezza ver7

as of SAP HANA SPS09:

• MaxDB 7.9

as of SAP HANA SPS10:

• Spark SQL

For details on how to install the drivers for the remote sources supported by SAP HANA smart data access, sse SAP note 1868702 SAP HANA Smart Data Access: Remote Data Source Drivers.

4. Other supported remote sources by SAP HANA smart data access
SAP HANA smart data access can leverage additional adapters provided by SAP HANA smart data integration (SDI). Pre-Requisite: If required, customers need to licence the SAP HANA EIM option. The Data Provisioning Server in the HANA instance has to be enabled. All supported SAP HANA SDI adapters are listed under https://support.sap.com/content/dam/library/ssp/infopages/pam-essentials/pam-hana-sdi-1.0.pdf.
Further information about setup and installation of SAP HANA SDI adapters can be found in the SAP HANA EIM Administration Guide -> Data Provisioning Adapaters

5. Future support of new adapters to 3rd party remote sources by SAP HANA smart data access
All future and new adapters to 3rd party remote sources (non-SAP) will be provided by SAP HANA smart data integration. Please check regularly the PAM for SAP HANA smart data integration under https://support.sap.com/content/dam/library/ssp/infopages/pam-essentials/pam-hana-sdi-1.0.pdf. Customers have to fullfill the pre-requisites as described under "4. Other supported remote sources by SAP HANA smart data access".

6. Restrictions for SAP HANA smart data access

• Virtual tables are supported in calculation views only.

• Also, there are parameter settings which have been made available for SAP HANA smart data access in SAP HANA Studio, under Configuration->indexserver->smart_data_access. These parameters are for use  only by SAP Support, and not meant for end-user-access.

Header Data

Released On	17.12.2015 21:57:46
Release Status	Released for Customer
Component	HAN-DB SAP HANA Database
Priority	Recommendations / Additional Info
Category	Advance development