Introduction To SAP HANA

  • Syed Hussim
  • 08 June 2017
  • 1802
This overview is a basic introduction to SAP HANA for developers who want to start developing applications using HANA DB.

SAP HANA is an in-memory relational database management system (RDMS) developed and marketed by SAP. HANA stores large amounts of data in memory and uses hard disk to store backups of the data. This makes analyzing large volumes of data at real time more efficient. HANA is a combination of software and hardware working together to maximize performance. SAP has partnered with IT hardware vendors like IBM, Cisco and many others to sell the SAP HANA platform. Below is a few features HANA provides.

SAP HANA is a combination of software and hardware.
Multi core architecture in distributed system environment.
Row and column data-storage.
Memory Computing Engine (IMCE) to process large amounts of data at real time.
It is written in C++
HANA DB Articles
  • JSON_TABLE Function

    In this article, we'll take a look at how to use the ++JSON_TABLE++ function to represent JSON data stored in a regular column as a relational table.

    31 March 2023 - 2698 views
  • Connect To HANA DB Using Rust

    Learn how to connect and query a HANA database using Rust with the hdbconnect package.

    21 February 2023 - 2759 views
  • If Table Exists Function

    In this article, I explain how to create a function to determine if a table exists in SAP HANA.

    31 October 2019 - 8833 views
  • Connect To HANA DB Using NodeJs

    This article explains how to connect to a SAP HANA system using the Node HANA client library.

    28 October 2019 - 7128 views
  • Connect To HANA DB Using Python

    This article explains how to connect to a SAP HANA system using the Python hdbcli package.

    11 October 2018 - 7979 views
  • Adding Auto Numbers To Table Columns

    This article explains how to create an auto generated column using IDENTITY.

    14 March 2018 - 6254 views
  • Connecting To SAP HANA Using PHP ODBC

    This article describes how to install and configure PHP odbc to connect to a SAP HANA system on Ubuntu 16.

    01 December 2017 - 7641 views

SAP Business One

  • php-sapb1-v2 Library Documentation v2

    This library has been updated and includes bug fixes from V1.

    07 November 2024 - 169 views
  • Stock Transfer Part 2

    In the previous article I exaplined how to transfer stock between warehouses and bin enabled warehouses. In this article, I discuss how to transfer batch enabled items.

    07 August 2020 - 4428 views
  • Stock Transfer Part 1

    The SAP B1 Service Layer provides an API to move stock between warehouses. This article explains the construction of the JSON payload data that is posted to the StockTransfers API.

    12 December 2019 - 7013 views

HANA DB

  • JSON_TABLE Function

    In this article, we'll take a look at how to use the JSON_TABLE function to represent JSON data stored in a regular column as a relational table.

    31 March 2023 - 2698 views
  • Connect To HANA DB Using Rust

    Learn how to connect and query a HANA database using Rust with the hdbconnect package.

    21 February 2023 - 2759 views

Rust

  • Count File Types In Directory

    This article explains how to develop a program that provides statistics on the different file types in a directory.

    29 January 2023 - 2721 views
  • Port Scanner

    A simple port scanner command line program that uses only the standard library.

    05 January 2023 - 8182 views
  • Word Frequency Counter

    A simple world frequency counter command line program that uses only the standard library.

    02 January 2023 - 1092 views

Java

Node.js

  • A JavaScript Implementation Of The Logo Programming Language - Part 2

    Part 2 of A Javascript Implementation Of The Logo Programming Language. In the previous article I explained how to develop a simple lexer. In this part we develop a TokenCollection class to help traverse the array of tokens returned from the lexer.

    10 June 2020 - 2902 views
  • A JavaScript Implementation Of The Logo Programming Language - Part 1

    In this four part article, I explain how to develop the iconic Logo programming language in JavaScript. In this part, we discuss how to take a source input and convert it into a series of tokens.

    06 June 2020 - 5216 views
  • Generating Web API Keys

    If you're building a REST API, chances are you're going to need to generate secure random API keys. In this article, I explain how to use the Node.js crypto module to generate random secure API keys.

    29 May 2020 - 7914 views
  • Port Scanner

    A simple port scanner to scan a range of ports.

    31 January 2020 - 3663 views