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
No comments:
Post a Comment