How to Perform Data Provisioning in SAP HANA Studio

  • by Rakesh Kalyankar, SAP NetWeaver BW- and HANA-certified consultant, SAP
  • April 15, 2012
Learn the steps behind using two methods for data provisioning in SAP HANA: SAP BusinessObjects Data Services and the SAP Landscape Transformation Replication Server. These steps serve as the foundation for the bigger task of deploying your first data model in SAP HANA.
Key Concept
Data provisioning involves selecting source metadata and importing its metadata and data into the SAP HANA system. There are three methods for data provisioning in SAP HANA: SAP BusinessObjects Data Services, SAP Landscape Transformation Replication Server, and Sybase Replication Server (the third method is not discussed in this article).

SAP HANA allows you to perform real-time analysis on data in SAP systems as well as non-SAP systems. SAP HANA uses in-memory technology that stores data in columnar form as opposed to the traditional row store databases. This type of format allows for faster data processing, better compression, and faster query response time on very large volumes of data.

When used as a database, SAP HANA replaces the traditional relational database management system (RDBMS) as the database back end for SAP applications, such as with the newly released SAP NetWeaver BW powered by SAP HANA. Used as an appliance, SAP HANA acts as a platform on which you can build various applications.

Components of SAP HANA

When you buy SAP HANA 1.3, you receive the following components:

  • The In-Memory Computing Engine (IMCE), which includes:

-          Calculation engine

-          Relational engines

-          SQL and MDX interfaces

-          Persistence layer

-          Disk storage

-          Other administrative modules, such as authorization manager, metadata manager, and replication server.

  • SAP HANA Studio, which facilitates modeling and administration. SAP HANA Studio is a client tool that connects to the IMCE.

Rakesh Kalyankar

Rakesh Kalyankar is an SAP NetWeaver BW- and HANA-certified lead and architect, working with SAP Global Delivery in Bangalore, India. He speaks regularly at events, such as SAP TechEd and BIIG. He is also an SAP trainer and writes frequently about SAP NetWeaver BW and SAP HANA topics. Prior to his starting his consulting work, he was part of the SAP NetWeaver BW research and development team at SAP Labs, and he has worked on the development life cycles of SAP NetWeaver BW releases, including versions 7.30 and 7.03.

If you have comments about this article or would like to submit an article idea, please contact the BI editor.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.