Migrating to SAP HANA system

SAP HANA is a combination of HANA Database, Data Modeling, HANA Administration and Data Provisioning in one single suite. Following are key features of SAP HANA −

  • SAP HANA is a combination of software and hardware innovation to process a huge amount of real-time data.
  •  Based on multi-core architecture in the distributed system environment.
  •  Based on column type of data-storage in the database and hence facilitates data compression, and on the fly aggregation.

Storing Data in Columnar based table has following benefits −

  • Data Compression

  • Faster read and write access to tables as compared to conventional Row based storage

  • Flexibility & parallel processing

  • Perform Aggregations and Calculations at higher speed

  • Used extensively in Memory Computing Engine (IMCE) to process and analyze the massive amount of real-time data.
  • It reduces the cost of ownership, increases application performance, enables new applications to run on the real-time environment that were not possible before.
  • SAP HANA support different data replications- SAP LT replication, Direct Extract Connection or Data Services and data load can be done in real time trigger based approach.
  • SAP HANA can be used for BI reporting using different reporting tools like BusinessObjects, Tableau and also include MS Excel.

To know more about SAP HANA features, you can refer to our SAP HANA tutorial: