SAP HANA Cockpit Installation.

In this blog, we would like to explain HANA Installation and how to monitor the HANA Landscape systems using HANA Cockpit.

In older HANA 1.0 SP12 by default cockpit was installed along with HANA Server but the newer version after HANA 2.0 SP01 higher SP level, we must install COCKPIT on a separate server to manage and monitor the HANA Landscape systems.

HANA COCKPIT can be installed on a separate server, or we can install within the HANA server.

SAP recommended to install the HANA COCKPIT a separate server for production environment.

Hana Table Migration using Export & Import

Requirement –

One of most common requirement in Hana is to move user defined table from one Hana environment to another (Ex: Dev > QA > Prod). Here is one of the method i.e. Export & Import we can use.

Solution –

Will migrate the Hana Table from Source Hana Environment to Target Hana Environment.

Step 1 Export Table – First we have to export the table from source system.

Connect to source Hana system and create sample table and load data using below script or any other script.

What’s New in SAP HANA Cloud in September 2022

Summer is slowly coming to an end, at least for the colleagues located in the northern hemisphere.  And with the end of the summer, we are also approaching yet another end of a quarter. With this blogpost, I want to provide you with a summary of the exciting innovations that have been introduced to SAP HANA Cloud in Q3 2022.     

To get a detailed overview of individual functionalities and changes, including demos and a Q&A, don’t miss out and register now for our release webinar hosted by the SAP HANA Cloud product management team.

Jupyter Notebook and SAP HANA: Persisting DataFrames in SAP HANA

Introduction

Jupyter Notebook or R are often the tools of choice for data scientists. It makes using data operations, data exploration and sharing convenient. SAP HANA is the database of choice for the most important businesses around the globe. Connecting both worlds, Jupyter Notebook and SAP HANA provides an incredible potential which needs to be seized.

SAP HANA

Jürgen Müller already provided a great blogpost about SAP HANA. I want to shortly formulate what SAP HANA is also with my own words. SAP HANA is an in-memory database which provides a lot of benefits, especially for analytical use cases. It connects different aspects of databases within one database. Besides typical properties of relational databases, it also delivers properties of NoSQL databases, like column-based databases. Depending on use-case, it is possible to activate or deactivate specific properties so that you can get the best performance out of your system.

Python with SAP Databases

How can we leverage Python programming language in SAP infrastructure? – in multiple ways I must say.

In this blog we will try to understand how we can establish connection with the database/s and how can we execute some basic queries.

But why Python?

Python is easy to learn, flexible, supports connectivity for almost all databases and OS platforms, supports connectivity to SAP using rfc modules, strong community support and has a lot of potential in automation.

HANA SPS upgrade from HANA 2.0 Rev 37 to HANA 2.0 Rev 59 on the DR server when primary and secondary server setup as replication are present

HANA SPS upgrade from HANA 2.0 Rev 37 to HANA 2.0 Rev 59 on the DR server when primary and secondary server setup as replication are present

There are many environments and larger landscapes where we have cluster environment.But in this environment we have Primary DB replicated with the secondary DB where the primary system is up an running and replicated to the secondary DB/DR Server.

Note:

While performing the HANA SPS upgrade or HANA revision upgrade first the upgrade needs to be performed to the DR/secondary server before performing it on the primary server

Reason:The version present on the DR/secondary server should be higher or similar to that of the primary server.

SAP Analytics Cloud – TroubleShooting – Timeline Traces

There are tons of different ways how you can performance traces on SAC for troubleshooting. In this blog I will talk about one of the tracing methods called (TIMELINE TRACES) that can be very helpful when there are performance problems being observed in SAP Analytics cloud (SAC) regardless if the connection is with BW or S/4HANA etc.

Step 1:

Log on to your SAC Tenant.

Step 2:

Once you are logged on to the SAC tenant open CHROME developer tools in the same browser window where you have the Tenant open.

SAP HANA Capture and Replay Tool End-to-end Hands-On Tutorial

This tutorial will walk us through the end-to-end steps in SAP HANA capture and replay tool.

What can I do with SAP HANA capture and replay?

Capture and replay tool could capture the real workload from source SAP HANA system and replay the captured workload to a target SAP HANA system. Both source system and target system should be on premise system.

Python hana_ml: PAL Classification Training(UnifiedClassification)

I am writing this blog to show basic classification training procedures using python package hana_ml. Wtih class UnifiedClassification, you can use several classification algorithms. Besides, training result can be exported as HTML report easily.