Optimizing HANA Cloud: A Practical Exploration of Replication, Latency, and Availability Zones

Introduction

In general crafting my blog posts, I usually avoid lengthy theoretical discussions. I find more value in exploring real-world scenarios, practical applications, and best practices. However, for this particular post, I'll make an exception. I'd like to start by briefly delving into some theoretical concepts you may already be acquainted with

—Replica, Latency, and Availability Zones in Cloud Databases. Allow me to provide a concise overview, accompanied by practical insights and optimization strategies. Together, we'll lay the groundwork for a resilient and high-performing system in HANA Cloud

Implement a More Efficient GIS-ERP Integration Following a Few Simple Steps

Deploy faster, more efficiently using in-built SAP HANA platform capabilities

After spending seven years at SAP developing patterns for a more efficient way to integrate GIS and ERP systems, I’ve returned to Locana to get directly involved in implementations that use in-built HANA platform capabilities to accomplish that objective. Below, I’ve listed steps that eliminate technical debt and complexity found in typical integration patterns.

IT leaders, GIS managers, and others can use the HANA platform to simplify integrations, enhance performance, and access advanced analytical capabilities by taking these steps. Combining ArcGIS Enterprise and S/4HANA ERP on the HANA platform makes this possible.

Migrate your SAP HANA Services for BTP (on Cloud Foundry) to SAP HANA Cloud using Self-Service Migration Tool

1. Benefits of migration to SAP HANA Cloud

SAP HANA Cloud is a cloud-native database-as-a-service (DBaaS) for modern applications and analytics across all enterprise data. SAP HANA Cloud provides exciting new innovations and features that were not offered by SAP HANA Service on Cloud Foundry (CF) such as pay-per-usage billing, multi-tier storage, including a petabyte scale built-in data lake allowing you to scale computing and storage resources separately and elastically. SAP HANA Cloud also offers automated near-zero downtime upgrades, HA/DR (up to 99.99% SLA), and availability in a large variety of regions via four different cloud service providers, including Microsoft Azure, Google Cloud Platform (GCP), Amazon Web Services (AWS) and Alibaba Cloud. Last but not least, you can also achieve Total Cost Ownership (TCO) benefits, as it is cheaper to run comparable workloads on SAP HANA Cloud versus HANA Services on CF. You can always use Capacity Unit Estimator to anticipate the cost benefits you will have depending on your SAP HANA Cloud configuration. 

Keep-Data-Clean: Practical approaches to keep your core (S/4 HANA) system clean

“Every company will become a technology company, and every company will become a data

company” – Steve Brown ‘The Innovation Ultimatum’

In SAP world, almost every company intended to use S/4HANA as their digital core.

But to run any sort of business, many companies also need various other SAP and non-SAP

systems/SaaS solutions. (On top of S/4 HANA). Like:

– PIM to manage all categories of products,

– WebShop to handle direct customer orders,

– EWM (advanced) to manage a warehouse,

– CRM to manage customer relations,

– PSP (payment service provider) for digital payments,

– SAP Ariba for spend management,

– Success factors for human capital management,

Etc… just to give some names, there could be many possibilities.

SAP AppGyver – Handling Image: Data Writing

Now, here is an article on SAP AppGyver.

Today I would like to explain how to handle image data. Images can be found at …..There are pros and cons to storing it in HANA Cloud’s BLOB type column.

Assumption

In this article, I will explain how to create an application that takes a photo and stores it in a BLOB type column in HANA Cloud.

Move data FAST from an SAP HANA Cloud database to a HANA Data Lake

If you’ve ever been stuck wondering how you can move data from your SAP HANA Cloud database to your SAP HANA Data Lake with minimal effort, this is for you. In fact, it might be the fastest way to move your data depending on your data lake’s configuration. Plus, it’s simple enough that a single Python function can do all the work for you!

This blog will outline how you can leverage remote servers in the data lake to make a connection to your HANA database and pull the data from HANA to data lake. I also experiment with different data lake configurations to see what parameters affect the speed of this data transfer the most, that way you know how to scale your data lake instance to achieve the best performance.

Testing virtual table replica feature of SAP HANA Cloud

Introduction

SAP HANA Cloud can virtually integrate data to be positioned as a "gateway for enterprise data" within the enterprise. Specifically, it is possible to virtually integrate various data sources via a virtual table created on HANA Cloud (data federation).

However, in actual operation, there may be cases where you want to retain data in SAP HANA Cloud due to network speed and performance / load on the source system side.

Transferring data from On-Premise SAP HANA to SAP HANA Cloud using SDI

Overview

In this blog, I will transfer data from On-Premise SAP HANA to SAP HANA Cloud using SDI (Smart Data Integration).

SAP HANA Cloud includes SDI which is an ETL tool, this means that you can easily integrate various kinds of source systems into SAP HANA Cloud without installing ETL application. Moreover, you can develop ETL jobs as same as developing tables and views, this makes it easy and quick to develop ETL jobs.