(Glue-2311) Redshift Prerequisites

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

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 https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/4265279637/SM-2305+S3+Redshift+Storage+Setup#Redshift-prerequisites.

Networking team:

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

AWS team:

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

   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/4265279637/SM-2305+S3+Redshift+Storage+Setup#S3-prerequisites under section S3 Policy.

2. Redshift https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/4265279637/SM-2305+S3+Redshift+Storage+Setup#Redshift:

   1. Redshift requires working S3 storage.

   2. Creation of Redshift schema and database user.