Using Smart Data Access SDA in SAP HANA

Smart Data Access under Provisioning tab allows you to access and analyze the data stored in other database systems without replicating the data into HANA database. Data replication process is always time consuming and requires memory storage. Smart Data Access allows you to create virtual tables which are linked to remote system tables and data can be directly accessed in SAP HANA system with these virtual tables.

You can manipulate these virtual tables and run SQL statements- SELECT, INSERT and UPDATE and even Join is permissible between virtual and local tables. When a JOIN is applied on virtual tables, SAP HANA Optimizer sends the operation to remote data source and results are sent back to HANA system.

Smart Data Access was first introduced in SAP HANA SPS06 and it allowed only READ operation on the remote system tables. The remote system supported in SAP HANA SPS06 with Smart Data Access includes: Sybase ASE, Sybase IQ, Teradata and Apache Hadoop.

John SAP

Published on 05-Feb-2018 20:02:42

• Related Questions & Answers
• Using SAP HANA SPS06 vs SPS07 with Smart Data Access SDA
• Different ODBC connection types under SAP HANA Smart data access SDA
• Limitations of using SAP HANA Smart Data Access
• Connection used in SAP HANA Smart Data Access
• Connecting to MSSQL, MaxDB using SAP HANA Smart Data Access
• Remote system allowed in SAP HANA Smart Data Access
• Adapters supported under Smart Data Access in SAP HANA
• System Authorization to use SAP HANA Smart Data Access
• Updated features in SAP HANA SPS07 for Smart Data Access
• Content of property_orcl.ini file in SAP HANA Smart Data Access
• Object privilege required to use SAP HANA Smart Data Access
• Remote data sources supported under SAP HANA SPS06 SDA
• Remote data sources supported under SAP HANA SPS07 SDA
• Creating new Remote Source using SDA in SAP HANA
• SQL statement to add a table as Virtual table in SAP HANA Smart Data Access