Book Image

SAP HANA Cookbook

Book Image

SAP HANA Cookbook

Overview of this book

SAP HANA is a real-time applications platform that provides a multi-purpose, in-memory appliance. Decision makers in the organization can gain instant insight into business operations. Thus all the data available can be analysed and you can react to the changing business conditions rapidly to make decisions. The real-time platform not only empowers business users and top management to make decisions but also provides the capability to make decisions in real-time.A practical and comprehensive guide that helps you understand the power of SAP HANA’s real-time and in-memory capabilities. It also provides step-by-step instructions to exploit all the possible features of the SAP HANA database, enabling users to harness the full potential of this technology and its features.You will gain an understanding of real-time replications, effective data loading from various sources, how to load data, and how to create re-usable objects such as models and reports.Use this practical guide to enable or transform your business landscape by implementing SAP HANA to meet your business requirements. The book shows you how to load data from different types of systems, create models in SAP HANA, and consume data for decision-making. The book covers various tools at different stages creating models using SAP HANA Studio, and consuming data using reporting tools such as SAP BusinessObjects, SAP Lumira, and so on . This book also explains the in-depth architecture of SAP HANA to help you understand SAP HANA as an appliance, that is, a combination of hardware and software.The book covers the best practices to leverage SAP HANA’s in-memory technology to transform data into insightful information. It also covers technology landscaping, solution architecture, connectivity, data loading, and setting up the environment for modeling purpose (including setup of SAP HANA Studio).If you have an intention to start your career as SAP HANA Modeler, this book is the perfect start.  
Table of Contents (16 chapters)
SAP HANA Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Understanding SAP HANA Studio


This recipe introduces you to why and where SAP HANA Studio is used. We will also look at how SAP HANA Studio has been developed and the technologies used behind its development.

How it works…

SAP HANA Studio runs on the Eclipse platform and is both the central development environment and the main administration tool for SAP HANA. SAP HANA Studio is used by administrators to administer activities, such as to start and stop services, monitor the system, configure system settings, and manage users and authorizations. SAP HANA Studio interacts with the servers of the SAP HANA database by using SQL. Developers use SAP HANA Studio for content creation such as information views and stored procedures. These development objects are stored in the SAP HANA repository. SAP HANA Studio is developed in the Java language and is based on the Eclipse platform.

SAP HANA Studio is the interface between the HANA database and the reporting layer or the HANA database and the presentation layer. It is the area where we design our models (for example, data models—3NF, 5NF, dimension models—based on star schema where we have facts, dimensions, and so on). SAP HANA Studio is a collection of applications for the SAP HANA appliance software. It enables developers, modelers, or technical users to work on development activities of the SAP HANA database. These activities include creating/managing user authorizations and building models, which can be creating new or editing existing models of data in the SAP HANA database. SAP HANA Studio is a client environment which can be used to access the SAP HANA database. The database can be located in the same environment or at a remote location.

There's more…

Platforms supported

SAP HANA Studio runs on the Eclipse platform Version 3.6. SAP HANA Studio can be used on the following platforms:

  • Microsoft Windows x32 and x64 versions of XP, Vista, and Windows 7

  • 64-bit versions of the Linux platform such as SUSE and Ubuntu

  • For Mac OS X, SAP HANA Studio (Version 1.00.60) is available for download

System requirements

Java JRE 1.6 or 1.7 must be installed to run SAP HANA Studio. The path variable parameters have to be set for JRE. The correct Java variant installation has to be selected accordingly, 32 bit or 64 bit.

Installation paths

An installation path has to be defined while installing, otherwise default values will be applied, as shown:

  • Microsoft Windows 32 bit (x86): C:\Program Files (x86)\sap\hdbstudio

  • Linux 64 bit (x86): /usr/sap/hdbstudio

  • Microsoft Windows 32 bit: C:\Program Files\sap\hdbstudio

  • Microsoft Windows 64 bit: C:\Program Files\sap\hdbstudio