Technology Blog Posts by Members
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Google BigQuery and SAP SLT integration

rishikeshj
Discoverer
‎2024 Jul 30 9:36 PM
0 Kudos
3,261

This blog narrates the procedure of Google BigQuery & SAP SLT integration. The Source system is SAP ECC & target is Google BigQuery while tables get replicated using SAP SLT.

System Environment
SLT 2.0 SP 18
DMIS 2011 SP 18
NW 7.5 SP 18
Cloud Provider – GCP
BigQuery Connector Version - 2.5

Architecture:
Below diagram shows the architecture of two projects, one having Data Analytics & second one has standalone SAP SLT installed. Since the SAP SLT is installed on Google Cloud, BigQuery API endpoint connects directly to BigQuery Connector, without requiring a Cloud VPN connection or Cloud Interconnect.

rishikeshj_0-1721476298207.png

Installation:
BigQuery connector is installed as a Business Add-In (BadI) captured in a Transport Request within an SAP LT Replication Server instance.

Enable the required Google cloud APIs on SAP SLT VMs
Login to https://console.cloud.google.com/ & enable ‘The Big Query API’ & ‘The IAM Service Account Credentials API’ APIs on the SLT VMs where BigQuery connector will be installed. Also, allow full access to cloud APIs.

rishikeshj_1-1721476346353.png
rishikeshj_2-1721476506062.png

Install the GCLOUD CLI on SLT VMs.
Use SIDADM to install the CLI.

rishikeshj_7-1721476536283.png

rishikeshj_8-1721476536284.png

Establish Trust between SAP SLT & Google BigQuery
Now that the GCLOUD CLI is installed, the next step is to Import certificates into SSL Client (standard) in strust. Download GTS Root R1 and GTS CA 1C3 & import under SSL client SSL Client (Standard) in Strust from Google Trust Services repository for handshake between SAP SLT system & Google BigQuery

rishikeshj_9-1721476648421.png

Install BigQuery SAP connector
Copy the Cofile & data file under /usr/sap/trans respective directories. Import the TR in your SLT system using STMS_IMPORT T-Code. To confirm installation of the connector, check the BAdI implementation in se80 ->/GOOG/EI_IUUC_REPL_RUNTIME_BQ

rishikeshj_10-1721477048872.png

Also, validate table IUUC_REPL_APPL if below entries are present using se16.
/GOOG/SLT_BQ & ZGOOG_SLT_BQ.
rishikeshj_11-1721477048873.png

Configure Replication
Specify access settings in SM30 -> /GOOG/CLIENT_KEY
rishikeshj_12-1721477148502.png
Once you are done configuring BigQuery Connector for SAP and testing your connection to Google Cloud, Google recommends token caching to be enabled

Configure RFC Destinations
RFC destinations are used to connect to BigQuery and IAM APIs by the BigQuery Connector for SAP.
Change the RFC name to customized RFC Name.
Under Logon & Security tab, Set SSL to Active & use DEFAULT SSL Client (Standard) Certificate.
Select HTTP 1.1 under special options.

rishikeshj_13-1721477565232.png

rishikeshj_14-1721477565238.png
A response containing 404 Not Found is acceptable and expected because the endpoint specified in the RFC destination corresponds to a Google Cloud service and not a specific resource hosted by the service.

In the table /GOOG/SERVIC_MAP, create entries as shown.
rishikeshj_0-1721477937963.png

Create an SAP LT Replication Server replication configuration.
Go to LTRC in SLT system & Click Create.
rishikeshj_1-1721478094194.png

Select RFC connection or DB connection based on your architecture.
rishikeshj_2-1721478094195.png

Select SLT SDK
rishikeshj_3-1721478094196.png

Value for below application will be picked from table IUUC_REPL_APPL
rishikeshj_4-1721478094198.png

Click Next, review your configuration & click Create. This concludes the SLT & Source system configuration.
To proceed with Target side configuration, create a mass transfer configuration for BigQuery. Use the custom T-Code /GOOG/SLT_SETTINGS & maintain settings as shown.
rishikeshj_5-1721478094200.png

Table level settings can be modified as shown below. More details
rishikeshj_6-1721478094205.png

This concludes the overall configuration of SAP SLT & Google BigQuery Setup. Hope this blog helps you to configure BigQuery as a target using SLT in your Landscape.

Reference: https://cloud.google.com/solutions/sap/docs/bq-connector/latest/planning
https://cloud.google.com/solutions/sap/docs/bq-connector/latest/install-config-on-gc#download-instal...