(Glue-2311) BigQuery Prerequisites

Owned by SNP
Nov 24, 2023
1 min read

High-level summary of necessary steps (more details in (SM-2305) GCS & BigQuery Storage Setup):

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-2305) GCS & BigQuery Storage Setup | 3.1 JSON key .

Networking team:

  1. Enabling outbound communication from the SAP system to GCP

Port

Address

Port

Address

443

accounts.google.com

443

*.googleapis.com

GCP team:

  1. GCP prerequisites: (SM-2305) GCS & BigQuery Storage Setup:

    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.