Storage Management Release 2211

Storage Management is a middleware software. It is used by various products for a seamless connection to secondary databases or storages.

This document describes individual storages, their parameters, minimal requirements, and setup procedures.

Supported Technologies

AWS	Azure	Google	Snowflake	Hadoop	Standard DB
S3	Azure Blob	Google Cloud Storage	Snowflake DB	HDFS	DB2/DB6
Redshift	ADLS (Gen 1 & Gen2)	BigQuery		Hive	MaxDB
	Databricks			Impala	HANA
					MSSQL
					Oracle
					SybaseIQ
					Sybase ASE

Technical overview

Storage Management (SM) is a gateway between SAP and external storage.

In the case of standard databases supported by SAP, the secondary DB connection defined in SAP is used to access external storage.

For Big Data and Cloud-based storage, our company is using an intermediate SM module to communicate with the external storage.

Communication diagram

Communication with the target platform is established through the Java connector using either the standard SAP HTTP service via RestAPI calls or the Java connector through JDBC/SDK.

The data transfer process is following a standard pattern of a phased approach:

1. Data is fetched into a memory of the SAP application server

2. Data is transferred into target storage using file-based storage as a landing zone

3. (Optional) Commit final data set into SQL-based storage using Java connector via JDBC/SDK connection

Communication flow (internal only)

SM translates ABAP commands into a DB-specific language.

SAP system uses Storage management to access an external database. Storage management translates an SAP command to a DB-specific command, which the external database understands. Based on the configuration, the DB command is executed through Open SQL or Native SQL interface.