Skip to Content

Data can be accessed from SAP HANA by below 2 ways –

  • Federation access via SAP HANA SDA (Smart Data Access)
  • Physical Persistence

In one of recent client requirement, it was needed to put framework on when to opt for data federation approach & when to go for persistence approach.

I am putting below simplified point of view on this based on 5 key parameters –


With above framework, it becomes clear that Data federation access via SDA is recommended when –

  • On Demand and Ad-hoc Analysis of Data from Remote Sources
  • Less Data Volume is needed for data analysis
  • Data Transformation complexity needed for analysis is less
  • Cold or old data is needed for analysis
  • Data needed for analysis from remote sources is not trusted, structured and harmonized
To report this post you need to login first.


You must be Logged on to comment or reply to a post.

Leave a Reply