sap hana free tutorial

SAP HANA Free Tutorial

Introduction to SAP HANA SAP HANA is innovative in memory data platform for business applications and exploiting maximum out of multi core processors. It is ideal platform for advanced performing, statistical analytics and efficiently handling transaction workloads. Data can be aggregated from any applications and unified information modelling and design environment such that data models are virtual and can be persisted in data repository.

ETL Based Replication Overview Extraction – Transformation – Load (ETL) based Data replication uses SAP BODS to load the relevant business data from the source system, SAP ERP, and replicate it to the target, SAP HANA database.

This method enables you to read the required business data on the level of the application layer.

You deploy this method by defaming data flows in Data Services and Scheduling the replication jobs.

Log Based Replication Overview This replication method is only recommended for customers that have been invited to use this technology during the RTC of the SAP HANA product delivery.

If you are not part of this RTC group, SAP recommends using Trigger – Based Data Replication using SAP IT ( Landscape Transformation) Replication server because of the rich feature set offered by this replication technology.

Database Overview The SAP HANA database is a hybrid in-memory database combines row-based, column based, and object-based database technology.

It is optimized to exploit the partial processing capabilities of modem multi-core / CPU architectures. With this architecture SAP applications can benefit from current bar down technologies.

The SAP HANA database is the heart of SAP’s in-memory technology offering, helping customers to improve their operational efficiency, agility and flexibility.

SAP HANA Modeling SAP HANA Pre-requisites Add HANA DB to HANA Studio HANA DB Creation HANA Schema (System / Custom schema) Data Provisioning (ETL / Log / Trigger ) CDC / Transaction loading configuration using replication agent server / (Resume/suspended loading) Normal loading / mass import Copy DATA from SAP schema to custom schema Loading data via information composer View the data from content (SYS-REP)

SAP HANA Views SAP HANA Attribute Views We can create this view on master tables Here we can take one or more tables Be case of multiple tables we need to join them with cardinalities Will get selected tables in data foundation tab We need to use output pave to create structure of view In output pave we have two folders 1) Attributes (fields form TABLES in BATN FOUNDATION) 2) Calculated attributes (to customized objects to perform calculator on attributes which are available in output pave by using functions, operation provided by SAP)

Data Loading in SAP HANA Steps for data upload 1) Upload data a) we can upload data file directly b) we can copy the specific data in a file (clipboard) 2) Data Cleaning (Optional) To merge similar data 3) Classifying data Identifying the measures 4) Publishing & Finish To apply data into HANA DB

And Also Issues Interview Questions How to’s For More SAP HANA Free Tutorials Please Visit: http://bit.ly/1zHNPLV