Virtual table can be manipulated by SAP HANA just like an ordinary table, which means the operations, such as select, update, insert, delete, and so on, are all available for virtual table. Once you have configured Smart Data Access you can read as well as update the data using virtual tables in remote sources.

SAP HANA Smart Data Access (SDA) provides a real-time access to data located outside of the SAP HANA database, without having to replicate the data to SAP HANA (physical data movement is not supported), so it is a data federation tool.Īs part of the HANA core system, no additional licensing is required to use smart data access. That data can then be presented or analyzed in new ways through applications. It uses data abstraction to provide a unified view of data from different sources. Virtualization and federation are good workarounds for situations where data consolidation is cost prohibitive or would cause too many security and compliance issues.Ī federation strategy enables real-time access to current data, which is not the case for a data consolidation strategy.Įnterprise information integration (EII) is a technology that supports data federation. No moving or replication of data is needed since all data stays in the source systems. On the downside, there is usually a delay between the time at which updates occur in source systems and the time at which these updates appear in the target store.Ĭonsolidation also requires a physical target, so additional storage capacity is consumed.ĭata federation is a form of data virtualization where the data stored in a heterogeneous set of autonomous data stores is made accessible to data consumers as one integrated data store by using on-demand data integration. Basically, this is how data warehouse works. Important advantage is that data consolidation considers not only present information, but also historical data, since a changed business state does not result in updates to the data, but in additions of new data. During this process, on data is carried out enrichment, transformation, removal of redundancy and error cleansing.

First I will explain these methods and then we will see how it looks in HANA.ĭata consolidation refers to the collection and integration of data from multiple sources into a single destination. There are two methods for data integration in SAP HANA: data consolidation and data federation.

Sap hana odbc driver