SAP HANA Smart Data Access: Modeling Recommendations
Showing posts with label smart-data-access. Show all posts
Showing posts with label smart-data-access. Show all posts
Tuesday, 7 June 2016
Tuesday, 31 May 2016
Modelling Learning Double Action or two things I just learned about modelling in SAP HANA SPS 11
The scenario in mind here was a SAP BW on HANA system reading data from a Suite on HANA system and using the SAP HANA live content installed there.
The Open ODS feature of SAP BW on HANA was to be used here as it allows reading from tables and views exposed via SDA in the local SAP HANA instance.
Now this idea sounds splendid.
Instead of having to manually build an extractor or an data export database view (both of which can be extensive development efforts), why not simply reuse the ready made content of SAP HANA live for this?
As usual the proof of the pudding is in the eating and as soon as it was tried out a severe shortcoming was identified:
The Open ODS feature of SAP BW on HANA was to be used here as it allows reading from tables and views exposed via SDA in the local SAP HANA instance.
Now this idea sounds splendid.
Instead of having to manually build an extractor or an data export database view (both of which can be extensive development efforts), why not simply reuse the ready made content of SAP HANA live for this?
As usual the proof of the pudding is in the eating and as soon as it was tried out a severe shortcoming was identified:
Tuesday, 10 March 2015
The power of Smart Data Access (SDA) with SAP HANA SP08
Introduction
Smart Data Access (SDA) was first introduced with SAP HANA SP06 and it enables enterprise to dynamically access and report across heterogeneous sources like SAP HANA, Sybase IQ, Sybase ASE, Hadoop, SQL Server, Teradata, Oracle and SQL Server.
Please refer to the links below, for more details
SAP Unveils SAP HANA Service Pack 6 (SP6) for Big Data and Spatial Processing
Modelling capabilities on these remote virtual (SDA) tables were introduced with HANA SP07, however this was limited to SQL based calculation views. Graphical calculation views can also be created using the SDA tables, however in this scenario the Aggregation (read. GROUP BY) was not pushed down to the remote database.
https://drive.google.com/open?id=0B2gB-XPbh9E7bk5va1JnVlNOdEE
SDA Features Enhancements with HANA SP08 (Rev 82)
Finally SAP HANA SP08 (rev 82) introduced the capability of Aggregation (GROUP BY) push down to the remote database in down in graphical calculations. That’s truly opens the possibility of building models on top of SDA virtual tables and hence building analytic solution.
Smart Data Access (SDA) was first introduced with SAP HANA SP06 and it enables enterprise to dynamically access and report across heterogeneous sources like SAP HANA, Sybase IQ, Sybase ASE, Hadoop, SQL Server, Teradata, Oracle and SQL Server.
Please refer to the links below, for more details
SAP Unveils SAP HANA Service Pack 6 (SP6) for Big Data and Spatial Processing
Modelling capabilities on these remote virtual (SDA) tables were introduced with HANA SP07, however this was limited to SQL based calculation views. Graphical calculation views can also be created using the SDA tables, however in this scenario the Aggregation (read. GROUP BY) was not pushed down to the remote database.
https://drive.google.com/open?id=0B2gB-XPbh9E7bk5va1JnVlNOdEE
SDA Features Enhancements with HANA SP08 (Rev 82)
Finally SAP HANA SP08 (rev 82) introduced the capability of Aggregation (GROUP BY) push down to the remote database in down in graphical calculations. That’s truly opens the possibility of building models on top of SDA virtual tables and hence building analytic solution.
Subscribe to:
Posts (Atom)