Storage Management is a middleware software. It is used by various Datavard 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
Datavard Storage Management (SM) is a gateway between SAP and External Storagesexternal storage.
In most cases, the case of standard databases supported by SAP, the secondary DB connection , defined in SAP , is used to access External Storage.An alternative way is when SAP is accessing External Storage via intermediate SM module in specific cases when accessing special Big Data technologiesexternal storage.
For Big Data and Cloud-based storage, Datavard is using an intermediate SM module to communicate with the external storage.
| Drawio | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Communication diagram
Communication with the target platform is established through the Datavard Java connector using either the standard SAP HTTP service via RestAPI calls or the Datavard 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 Datavard Java connector via JDBC/SDK connection
| Drawio | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Communication flow (internal only)
SM translates ABAP commands into a DB-specific language.
| Drawio | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.