What is HANA Smart Data Access (SDA) ?
SAP HANA smart data access enables remote data to be accessed. It enables remote data to be accessed as if they are local tables in SAP HANA, without copying the data into SAP HANA.
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.
Steps:
- Install ODBC driver for the remote source DB. Lot of drivers given out of box.
- Create Remote Source with a user which has all the required privileges in the remote source to access table/view data.
- Create virtual table in target HANA DB.