Storage Management Release 2211
- SNP
- Marian Vidra
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 | 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:
Data is fetched into a memory of the SAP application server
Data is transferred into target storage using file-based storage as a landing zone
(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.