
In SAP Implementation one of the most critical aspects is reporting. As SAP data is being integrated with many other Non SAP system’s to create reports in systems such as looker, this blog explores the option of how SAP can be Integrated to GBQ using GBQ Connector.
This blog explores the option of data transfer from SAP to GBQ using embedded SLT in S/4HANA.
As part of this blog, we will be setting up data transmission from SAP S/4HANA system hosted in GCP to GBQ using GBQ Connector and embedded SLT.
The official guide from Google for the setup is available over here. (https://cloud.google.com/solutions/sap/docs/bq-connector/latest/all-guides )
The infrastructure setup can be divided into three part, depending on where the SAP system is hosted. This use case considers S/4HANA Private cloud in Compute Engine virtual machine (VM) on Google Cloud.
Service Account Token Creator, BigQuery Data Editor , BigQuery Job User
As this use case considered SAP Rise system is hosted in GCP, we have 2 steps to perform in the customer’s GCP environment to allow
Data transfer.
As the guide covers detailed instructions to be performed, this blog will demonstrate highlights of the configuration in SAP. Feel free to ask any questions in the comment section of the blog for additional information.
Service Account Name : The Service Account associated with SAP Application Server VM is used
Scope: https://www.googleapis.com/auth/bigquery can be used if the permission were restricted in earlier step
Project ID : The project name created is target GCP which contains the GBQ dataset
Project Identifier: This is the project name from Target GCP
BQ Dataset: Name of the GBQ Dataset
After the above setup, test the replication using LTRC. All the other relevant configurations for SLT can be used in the above use case as well (LTRS) .
Resources
https://cloud.google.com/solutions/sap/docs/bq-connector/latest/install-config-on-gc#prereqs
https://help.sap.com/doc/04989b617c6f4ca8982fde703e7350f9/3.0.04/en-US/Performance%20Guide.pdf
2014562 - FAQ: SAP HANA LT Replication Server (SLT)
2940799 - Best practices for loading/replicating a table with a view – SLT
3016862 - DMIS Note Analyzers with separated scenarios for ABAP-based Migration and Replication Technology
Please keep an eye out upcoming blog about lessons learnt as well as optimization option we have implemented for above use case.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
20 | |
19 | |
9 | |
7 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 |