This guide shows you how to install version 2.8 (latest) of the BigQuery Connector for SAP in your SAP LT Replication Server.
This guide covers how to prepare BigQuery, SAP Landscape Transformation Replication Server (SAP LT Replication Server), and BigQuery Connector for SAP to replicate SAP data from SAP applications directly and securely to BigQuery in real time.
This guide is intended for SAP administrators, Google Cloud administrators, and other SAP and Google Cloud security and data professionals.
Prerequisites
Before you install BigQuery Connector for SAP, make sure that the following prerequisites have been satisfied:
- You have read the BigQuery Connector for SAP planning guide. The planning guide explains BigQuery Connector for SAP options, performance considerations, field mapping, and other information that you need for the optimal configuration of BigQuery Connector for SAP.
If you don't have a Google Cloud project already, create one:
Billing is enabled for your project. Learn how to confirm that billing is enabled for your project. A billing account is required for BigQuery streaming API, BigQuery, and to download BigQuery Connector for SAP.
Maintenance for the installed SAP software is current and the versions of all of the SAP software are compatible with each other, as documented in the SAP Product Availability Matrix.
The versions of the SAP software you are using are supported by the BigQuery Connector for SAP, as documented in Software requirements.
You have the correct SAP licenses that are required to replicate data to any target through the SAP LT Replication Server SDK. For more information about SAP licensing, see SAP Note 2707835.
SAP LT Replication Server is installed. For information about installing SAP LT Replication Server, see the SAP documentation.
The RFC or database connection between SAP LT Replication Server and the source system is configured. If necessary, test the RFC connections by using SAP transaction
SM59. Test database connections by using SAP transactionDBACOCKPIT.
Overview of the installation and configuration process
The following table shows procedures covered in this guide and the roles that typically perform them.
| Procedure | Role |
|---|---|
| If necessary, after validating all appropriate licenses from SAP, follow the SAP instructions to install an SAP Landscape Transformation Replication Server. | SAP administrator. |
| If necessary, install the user interface (UI) add-on for SAP NetWeaver. For more information, see SAP software version requirements. | SAP administrator. |
| If your SAP workload is not running on Google Cloud, then establish a network connection between your SAP system and Google Cloud. | Network administrator. |
| If your SAP workload is not running on Google Cloud, then enable private access to the Google Cloud APIs. | Google Cloud network administrator. |
| Download the BigQuery Connector for SAP installation package. | Google Cloud billing account holder. |
| Install BigQuery Connector for SAP. | SAP administrator. |
| Set up authentication. | Google Cloud security administrator. |
| Enable the required Google Cloud APIs. | Google Cloud administrator. |
| Create a BigQuery dataset. | Google Cloud administrator or data engineer. |
| Create SAP roles and permissions for BigQuery Connector for SAP. | SAP administrator. |
| Configure replication. | Data engineers or administrators. |
| Test replication. | Data engineers or administrators. |
| Validate replication. | Data engineers or administrators. |
Establish a network connection to Google Cloud
If your SAP workload is running on Google Cloud, then you can skip this step.
If your SAP workload is not running on Google Cloud, you or a network administrator needs to establish a secure, high-bandwidth, low-latency connection to Google Cloud.
You have the following two connection options:
- Cloud Interconnect (recommended)
- Cloud VPN
To set a connection up, follow the instructions provided by the Google Cloud connection service that you select.
Each connection service has different instructions for different scenarios, so review the service documentation and follow the instructions for your scenario.
Enable private access to the Google Cloud APIs
If your SAP workload is running on Google Cloud, then you can skip this step.
If your SAP workload is not running on Google Cloud, then after you establish a network connection to Google Cloud, you need to enable private access to the Google Cloud APIs.
To enable private API access, see Configuring Private Google Access for on-premises hosts.
Download the installation package
Download the latest BigQuery Connector for SAP installation package from BigQuery Connector for SAP download portal.
You need your Cloud Billing number to complete the download. For information about billing accounts, see Cloud Billing & payments profile.
The installation package includes transport files that you copy into the appropriate transport directory for SAP LT Replication Server.
Install BigQuery Connector for SAP
After you receive the installation package that contains the BigQuery Connector for SAP transport files, your SAP administrator can install BigQuery Connector for SAP by importing the transport files into SAP LT Replication Server.
The SAP transport for BigQuery Connector for SAP contains all of the objects
that are required for BigQuery Connector for SAP, including the /GOOG/
namespace, DDIC objects, the SLT SDK BADI implementation and classes,
report programs, and more.
Before importing the transport files into SAP LT Replication Server, verify that your SAP LT Replication Server is supported by BigQuery Connector for SAP, as documented in Software requirements.
In spite of using a supported version of SAP LT Replication Server, in some cases,
while importing the transport files, you might see the error message,
Requests do not match the component version of the target system. In such
cases, you need to re-import the transport files into
SAP LT Replication Server and while re-importing, on the
Import Transport Request screen, go to the Options tab, and then select
the Ignore Invalid Component Version checkbox.
The following procedure is a general procedure. Each SAP system is different, so work with your SAP administrator to determine any changes to the procedure that might be required for your SAP system:
Copy BigQuery Connector for SAP transport files into the following SAP LT Replication Server transport import directories:
/usr/sap/trans/cofiles/KXXXXXX.GM1/usr/sap/trans/data/RXXXXXX.GM1
In the preceding examples,
XXXXXXrepresents the numbered file name.In the SAP GUI, use transaction code
STMS_IMPORTorSTMSto import the files into the SAP system.Make sure all objects in
/GOOG/SLT_SDKpackage are active and consistent:- In the SAP interface, enter transaction code
SE80. - In the package selector, select
/GOOG/SLT_SDK. In the Object name field, right-click on the package
/GOOG/SLT_SDK, and then choose Check > Package Check > Objects of Package.A green check in the Result column indicates that all objects passed the package check.
- In the SAP interface, enter transaction code
Confirm that BigQuery Connector for SAP is ready to configure
To further confirm that the transport files have been
imported correctly and that BigQuery Connector for SAP is ready to
configure, confirm that BigQuery Connector for SAP Business Add-In (BAdI)
implementation is active and that BigQuery Connector for SAP
replication applications have entries in the IUUC_REPL_APPL table.
- Check the BAdI implementation:
- Use the transaction SE80 to navigate to and select the
/GOOG/EI_IUUC_REPL_RUNTIME_BQenhancement object folder. - Select Enh. Implementation Elements on the right side of the page.
- Under Runtime Behavior, confirm that Implementation is active is checked.
- Use the transaction SE80 to navigate to and select the
- Check the replication applications:
- Using the SAP Data Browser or transaction
SE16, display theIUUC_REPL_APPLtable. - Confirm that the following applications appear in the
IUUC_REPL_APPLtable:/GOOG/SLT_BQZGOOG_SLT_BQ, for use when the/GOOG/namespace isn't registered
- Using the SAP Data Browser or transaction
Troubleshoot
For information about diagnosing and resolving issues that you might encounter when you install the BigQuery Connector for SAP, see BigQuery Connector for SAP troubleshooting guide.
Get support
If you need help resolving problems with installing the BigQuery Connector for SAP, collect all available diagnostic information and contact Cloud Customer Care. For information about contacting Customer Care, see Getting support for SAP on Google Cloud.