Storage Management is a middleware software. Various products use it 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 | Relational DB | BLOB | |
---|---|---|---|---|---|---|
S3 | Azure Blob | Google Cloud Storage | Snowflake DB | HDFS | DB2/DB6 | MaxDB |
Redshift | ADLS (Gen1 & Gen2) | BigQuery | Hive | MaxDB | MSSQL | |
Databricks | Impala | HANA | Oracle | |||
AzureSQL | MSSQL | SAP ASE | ||||
Oracle | ||||||
SybaseIQ | ||||||
SAP 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 uses 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 via JDBC/SDK.
The data transfer process is following a standard pattern of a phased approach:
Data is fetched into the 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