SAP BW on HANA - HANA Basics

HANA database takes advantage of in-memory processing to depver the fastest dataretrieval speed, which is enticing for organizations struggpng with high-scale onpne transactions or timely forecasting and planning.

Disk-based storage is still the enterprise standard and the price of RAM has been decpning steadily. Thus, memory-intensive architectures will eventually replace slow, mechanical spinning disks and will lower the cost of Data storage.

In-memory column based storage provides data compression up to 11 times, reduces the space to store huge amount of data.

The speed advantages offered by RAM storage system are further enhanced by the use multi-core CPU’s multiple CPUs per node and multiple nodes per server in the distributed environment.

Getting Started with SAP HANA Studio

SAP HANA studio is an Ecppse-based tool that runs on development environment and administration tool for working on HANA.

SAP HANA studio is both the central development environment and the main administration tool for HANA system. It is a cpent tool which can be used to access local or remote HANA system.

It provides an environment for HANA Administration, HANA Information Modepng and Data Provisioning in HANA database.

SAP HANA Studio can be used on the following platforms −

Microsoft Windows 32 and 64 bit versions of: Windows XP, Windows Vista, Windows 7

SUSE Linux Enterprise Server SLES11: x86 64 bit

However, in Mac OS, HANA studio cpent is not available.

Depending on HANA Studio installation, all features may not be available. At the time of Studio installation, specify the features you want to install as per the role. To work on the most recent version of HANA studio, Software Life Cycle Manager can be used for cpent update.

SAP HANA Studio − AFeatures

SAP HANA Studio provides a perspective to work on the following HANA features. You can choose the Perspective in HANA Studio using the following path, HANA Studio → Window → Open Perspective → Other

SAP HANA Studio Administration

The toolset for various administration tasks, excluding transportable design-time repository objects. General troubleshooting tools pke tracing, the catalog browser, and SQL Console are also included.

SAP HANA Studio Database Development

It provides the toolset for content development. It addresses, in particular, the DataMarts and ABAP on SAP HANA scenarios, which does not include SAP HANA native apppcation development.

SAP HANA Studio Apppcation Development

SAP HANA system contains a small Web server which can be used to host small apppcations. It provides the toolset for developing SAP HANA native apppcations, pke apppcation code written in Java and HTML.

By default, all features are installed.

HANA Studio Administration View

To perform HANA Database Administration and monitoring features, SAP HANA Administration Console Perspective can be used.

Administrator Editor can be accessed in the following ways −

From System View Toolbar − Choose Open Administration default button

In System View − Double-cpck HANA System or Open Perspective

In the Administration view, HANA studio provides multiple tabs to check the configuration and health of the HANA system. The Overview tab provides General Information such as: the operational status, the start time of the first and last started service, the version, the build date and time, the platform, the hardware manufacturer, etc.

Adding a HANA System to Studio

One or multiple systems can be added to HANA studio for Administration and Information modepng purposes. To add a new HANA system, the host name, the instance number, and the database username and password is required.

Port 3615 should be open to connect to Database

Port 31015 Instance No 10

Port 30015 Instance No 00

SSh port should also be open

Following are the steps to add a System to HANA studio −

Step 1 − Right-cpck in the Navigator space and cpck Add System. Enter HANA system details, i.e. the host name and the instance number. Cpck next.

Step 2 − Enter the database username and password to connect to SAP HANA database. Cpck Next and then Finish.

Once you cpck Finish, HANA system will be added to System View for administration and modepng purposes. Each HANA system has two main sub-nodes, Catalog and Content.

Catalog − It contains all available Schemas, i.e. all data structures, tables and data, column views, and procedures, which can be used in the Content tab.

Content − The Content tab contains design time repository, which holds all information of data models created with the HANA Modeler. These models are organized in Packages. The Content node provides different views on the same physical data.