Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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


AzureGoogleSnowflakeHadoopStandard DB

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

Databricks

ImpalaHANA

Azure SQL




MSSQL

Azure Synapse




Oracle





SybaseIQ





Sybase ASE

Technical overview

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

...

Drawio
baseUrlhttps://datavard.atlassian.net/wiki
diagramNamesm_high_level.xml
contentId864126049
width432
zoom1
pageId699105498
diagramDisplayNamesm_high_level.xml
lbox1
contentVer3
height402
revision1


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.

...

Drawio
simple0
zoom0.9
inComment0
custContentId3598254147
pageId699105498
diagramDisplayNameDatavard Java Connector.drawio
lbox1
contentVer2
hiResPreview0
revision2
baseUrlhttps://datavard.atlassian.net/wiki
diagramNameDatavard Java Connector.drawio
pCenter0
aspect
width759
linksauto
tbstyletop
height440.99999999999994

Communication flow (internal only)

SM translates ABAP commands into a DB specific language.

Drawio
baseUrlhttps://datavard.atlassian.net/wiki
diagramNamesm_communication_flow_high_level.xml
contentId1035042828
width601
zoom1
pageId699105498
diagramDisplayNamesm_communication_flow_high_level.xml
lbox1
contentVer5
height361
revision5

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.