(SM 2005) AWS (Amazon Web Services)

Owned by SNP
Last updated: Jun 02, 2020 by Marian Vidra

Amazon Web Services (AWS) is a cloud service from Amazon providing services in the form of building blocks, which can be used to create and deploy any type of application in the cloud.

These services or building blocks are designed to work with each other and result in applications that are sophisticated and highly scalable.

Each type of service can be categorized under a domain. Widely used domains are: Compute, Storage, Database, Migration, Network and Content Delivery, Security & Identity Compliance ...


From the Datavard perspective, Storage and Database domains are the relevant ones.

Datavard supports storage service S3 and database service Redshift.

Please refer to (SM 2005) S3/Redshift Storage Setup for more information.

Prerequisites

SAP requirements

  • SAP NetWeaver 7.01 SP-level 015
  • HTTP service enabled
  • SSFLIB Version 1.850.40 ; CommonCryptoLib (SAPCRYPTOLIB) Version 8.5.20 (+MT) 
  • Redshift JDBC driver

AWS requirements

S3 storage

  • Existing S3 bucket
  • Details needed for connection into AWS S3 Service including security pair ("access_key_id", "secret_key_id")

Redshift

  • Existing Redshift database
  • Redshift database user (DVD_USER)
  • Grant permissions to the Redshift database user (DVD_USER) to run a select command on the following Redshift system tables:
      • pg_catalog.SVV_TABLE_INFO for SAP data computation (table size: "grant select on pg_catalog.SVV_TABLE_INFO to DVD_USER;")
      • pg_catalog .PG_TABLE_DEF to check if a table exists (table exists: "grant select on pg_catalog.PG_TABLE_DEF to DVD_USER;" )