High-level summary of necessary steps (more details in (SM-22112305) S3/Redshift Storage Setup):
SAP Basis/Infrastructure tasks:
...
Java Connector: (SM-Latest) Java Connector Setup
Creation of SNP_JAVA_CONN RFC:
Connection type: TCP/IP Connection.
Activation type: Registered Server Program.
Fill in the Program ID (e.g.): SNP_JAVA_CONNECTOR.
Creation of Technical SAP user for ABAP >JCO RFC Communication:
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).
Create System user, with role /DVD/JCORFC.
Granting access for external program SNP_JAVA_CONN to SAP gateway:
Check SMGW > GoTo > Expert Functions > External Security > Maintenance of ACL files whether external programs are allowed (=* or ProgramID).
SAP system (Operating system level):
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/4146331808/SM-2211+S3+Redshift+Storage+Setup#id-(SM-2211)S3%2FRedshiftStorageSetup-Redshiftprerequisites (SM-2305) S3/Redshift Storage Setup | Redshift prerequisites.
Networking team:
Enabling outbound communication from the SAP system to AWS:
Port | Address |
---|---|
443 | s3.<region>.amazonaws.com |
5439 | <NameOfEndpoint>.<redshift>.redshift.amazonaws.com |
AWS team:
S3 storage : https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/4146331808/SM-2211+S3+Redshift+Storage+Setup#id-(SM-2211)S3%2FRedshiftStorageSetup- (SM-2305) S3/Redshift Storage Setup | S3:
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/4146331808/SM-2211+S3+Redshift+Storage+Setup#id-(SM-2211)S3%2FRedshiftStorageSetup-S3prerequisites (SM-2305) S3/Redshift Storage Setup | S3 prerequisites under section S3 Policy.
Redshift : https://datavard.atlassian.net/wiki/spaces/DATAVARD/pages/4146331808/SM-2211+S3+Redshift+Storage+Setup#id-(SM-2211)S3%2FRedshiftStorageSetup- (SM-2305) S3/Redshift Storage Setup | Redshift:
Redshift requires working S3 storage.
Creation of Redshift schema and database user.
...