- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- Related Articles
- 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
- Content of property_orcl.ini file in SAP HANA Smart Data Access
- Updated features in SAP HANA SPS07 for Smart Data Access
- Object privilege required to use SAP HANA Smart Data Access
- SQL statement to add a table as Virtual table in 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
