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


AzureGoogleSnowflakeHadoopStandard DB

S3Azure BlobGoogle Cloud StorageSnowflake DBHDFSDB2/DB6
RedshiftADLS (Gen 1 & Gen2)BigQuery
HiveMaxDB

Databricks

ImpalaHANA





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.