SAP BW on HANA - HANA Basics

---

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

Disk-based storage is still the enterprise standard and the price of RAM has been declining 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 Eclipse-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 client tool which can be used to access local or remote HANA system.

It provides an environment for HANA Administration, HANA Information Modeling 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 client 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 client 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 like 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 application development.

SAP HANA Studio Application Development

SAP HANA system contains a small Web server which can be used to host small applications. It provides the toolset for developing SAP HANA native applications, like application 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-click 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 modeling 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-click in the Navigator space and click Add System. Enter HANA system details, i.e. the host name and the instance number. Click next.

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

Once you click Finish, HANA system will be added to System View for administration and modeling 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.