SAP HANA studio

After activating the sslenforce parameter in the hanadatabase, our attempts to connect to the hana database via hana studio were unsuccessful due to an “only secured connections are allowed” error. Here is one of the methods we employed... Read More »

I am grateful to share a concept as my first blog. A concept where data inconsistency was fixed within a AMDP Class. So, I have gathered information and shared this Blog which would be helpful to resolve this issue with a single shot and precise... Read More »

Context – Here we will see one quite useful in-built Hana function $rowid$ and it usages. $rowid$ – Returns the internal row ID value for each row of the table. Whenever any new row is inserted in a Hana table new unique numeric ID is... Read More »

last updated: 2023-03-11 Introduction There is huge knowledge available about SAP HANA reclaim / shrink / defragmentation topic, but the knowledge is very fragmented (Help Portal, Blog post, SAP KBA, SAP Note, other). In order to simply and make... Read More »

This Blog explain the restore steps of using backint from Dell EMC netwoker software Expample: Source machine name: s4hhdb1 Source Bakup pool: S4HPRD Source tenant DB: SH1 Target machine name: testdbr2 Backup media server name: emcbackup137 Target... Read More »

last updated: 2023-03-17 Introduction There is huge knowledge available about SAP HANA partitioning, but the knowledge is very fragmented (Help Portal, Blog post, SAP KBA, SAP Note, other). In order to simply and make content consumption easier I... Read More »

With the new evolving modern methodologies around many SAP applications and database technology, i am trying to contribute with some idea that can be helpful or spark a new idea for others. The thought is … What if we can create HANA docker... Read More »

Hello SAP Community Members, My Name is Zeshan Shafaqat Expert in SAP BI/BW and SAP Analytics Cloud. I found many peoples that having trouble that how can we install Eclipse and HANA Tools on their PC. In this Blog, I show you screenshots of how can... Read More »

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... Read More »

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... Read More »