Skip to Content

Data Federation via SDA Vs Data Persistency in HANA – Viewpoint

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
You must be Logged on to comment or reply to a post.