Monday, March 7, 2022

SAP HANA Smart Data Access (SDA)

Within an advent of SAP HANA there was a new technology introduced to enable bringing data from external sources to the SAP HANA. It is called SAP HANA Smart Data Access (SDA). The data stored in the external databases appear if they were local tables in SAP HANA. There is no need to transfer the data physically from those external sources to the HANA in order to use them.

It uses a concept of virtual tables which point (via mapping) to remote tables in different data sources. In the HANA an SQL statements can be executed to process those data. The HANA query processor process these SQL statements and execute part of them against target database returning results to the HANA.

There is a number of the external databases that are supported. Depending on their hardware platform it varies from: SAP’s DB portfolio (HANA DB, IQ, Adaptive Server Enterprise (ASE), Event Stream Processor, HANA Smart Data Streaming, MaxDB), MS SQL Server, Oracle, Apache Hadoop, Apache Spark, IBM Netezza, IBM DB, Teradata, etc. The SDA was introduced in version of SAP HANA 1.0 SPS06 (in 2013).


More information:

1868209 - SAP HANA Smart Data Access 1.0 Master Release Note

2352696 - SAP HANA Smart Data Access 2.0 Master Release Note

Online docu SAP HANA Smart Data Access

No comments: