(Glue 2402) BigQuery Prerequisites

High-level summary of necessary steps (more details in (SM-Latest) GCP (Google Cloud Platform) ):

SAP BASIS/Infrastructure tasks:

SAP Basis team:

1. Java Connector: (SM-Latest) Java Connector Setup

   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 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 the JSON file to /sapmnt/<SID>/global/security/dvd_conn, more details can be found in (SM-2402) GCS & BigQuery Storage Setup | 3.1 JSON key.

Networking team:

1. Enabling outbound communication from the SAP system to GCP

GCP team:

1. GCP prerequisites: (SM-2402) GCS & BigQuery Storage Setup | 2. GCP prerequisites:

   1. Select a project or create a new one.

   2. Service account - needed for access to GCP from the SAP system, using the generated key in JSON format.

   3. Creation of Storage bucket.

   4. Creation of BigQuery dataset.