(Glue-2502) Redshift Prerequisites

(Glue-2502) Redshift Prerequisites

High-level summary of necessary steps (more details in https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/2229601380):

SAP Basis/Infrastructure tasks:

Basis team:

  1. Java Connector: https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/2229602754

    1. Creation of SNP_JAVA_CONN RFC:

      1. Connection type: TCP/IP Connection.

      2. Activation type: Registered Server Program.

      3. Fill in the Program ID (e.g.): SNP_JAVA_CONNECTOR.

    2. Creation of Technical SAP user for ABAP >JCO RFC Communication:

      1. In the transport, you are provided with a template role with name /DVD/JCORFC (if you will use this role, do not forget to generate the profile in transaction PFCG).

      2. Create System user, with role /DVD/JCORFC.

    3. Granting access for external program SNP_JAVA_CONN to SAP gateway:

      1. Check SMGW > GoTo > Expert Functions > External Security > Maintenance of ACL files whether external programs are allowed (=* or ProgramID).

  2. SAP system (Operating system level):

    1. Uploading Redshift JDBC driver to /sapmnt/<SID>/global/security/dvd_conn/redshift, more details can be found in (SM-2402) S3/Redshift Storage Setup | Redshift prerequisites.

Networking team:

  1. Enabling outbound communication from the SAP system to AWS:

Port

Address

Port

Address

443

s3.<region>.amazonaws.com

5439

<NameOfEndpoint>.<redshift>.redshift.amazonaws.com

AWS team:

  1. S3 storage https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/4510351548/SM-2402+S3+Redshift+Storage+Setup#S3-Prerequisites:

    1. Creation of technical user in S3 (assigning appropriate policy is necessary) - more details can be found in https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/4510351548/SM-2402+S3+Redshift+Storage+Setup#S3-Prerequisites under section S3 Policy.

  2. Redshift (SM-2402) S3/Redshift Storage Setup | Redshift prerequisites:

    1. Redshift requires working S3 storage.

    2. Creation of Redshift schema and database user.