Publish data products to SAP

Knowledge Catalog (formerly Dataplex Universal Catalog) lets you publish data products to SAP Business Data Cloud (BDC) by using BigLake Delta Sharing. Users in the SAP ecosystem can then discover and consume your Google Cloud data assets as read-only federated tables without moving or replicating data.

Overview

The integration between Knowledge Catalog and SAP BDC relies on an open-protocol approach using Delta Sharing. When you publish a data product to SAP, Knowledge Catalog facilitates the creation of a secure sharing link.

Key technical aspects of this integration include the following:

  • Federated access: Underlying data assets, such as Apache Iceberg REST catalog tables, are presented in SAP as read-only federated tables and queried in real-time from Google Cloud storage.
  • Delta Sharing: Knowledge Catalog acts as a Delta Sharing server, providing a standard interface for external clients like SAP to access BigLake and Iceberg tables.
  • No data movement: Your data stays in its original location in Google Cloud without replication, which helps lower latency and maintain a single source of truth. Only the metadata and secure access protocols are shared with the SAP environment.
  • Security: Authentication and authorization are handled using Workload Identity Federation, ensuring that only authorized SAP users can access the data based on the permissions granted in Google Cloud.

Before you begin

Before you publish a data product to SAP BDC, complete the following prerequisites:

Enable APIs

Enable the BigLake API on your Google Cloud project.

Enable the BigLake API

Delta Sharing and catalog requirements

Ensure that your environment meets the following requirements:

Requirement Details Reference
Delta Sharing catalog You must have a BigLake Delta Sharing catalog created and enrolled with your SAP BDC environment in the same project and region as your data product. See Set up cross-cloud connection for SAP Business Data Cloud.
Workload Identity Federation You must configure a Workload Identity Pool and Provider to trust the SAP BDC OIDC issuer. See Configure Workload Identity Federation.
Data product assets The data product must contain at least one supported data asset (such as an Apache Iceberg REST catalog table) and a maximum of 50 tables. All Iceberg tables in the data product must meet the following constraints:
  • Belong to the same Iceberg REST catalog
  • Have primary keys defined
  • Contain at least one row of data
See About data products.

Required roles

To get the permissions that you need to manage and publish a data product to SAP BDC, ask your administrator to grant you the following IAM roles on the Google Cloud project:

For more information about granting roles, see Manage access to projects, folders, and organizations.

You might also be able to get the required permissions through custom roles or other predefined roles.

Publish a data product to SAP BDC

Console

  1. In the Google Cloud console, go to the Knowledge Catalog Data products page.

    Go to Data products

  2. Click the name of the data product that you want to publish.

  3. On the data product details page, click Share, and then select Publish to SAP.

  4. In the Publish data product to SAP pane, specify the following:

    • Share name: Enter a unique name for the share to be created in SAP.
    • Delta catalog: Select the enrolled Delta Sharing catalog from the list.
    • Workload identity: Enter the full resource name of the Workload Identity Provider configured for SAP BDC. Use the following format:
    projects/PROJECT_NUMBER/locations/global/workloadIdentityPools/POOL_ID/providers/PROVIDER_ID
    

    Replace the following:

    • PROJECT_NUMBER: your Google Cloud project number
    • POOL_ID: the ID of your Workload Identity Pool
    • PROVIDER_ID: the ID of your Workload Identity Provider.
  5. Click Publish.

Knowledge Catalog initiates the publishing process using the BigLake API. Once successful, the data product is discoverable as federated tables within SAP BDC.

gcloud

See Publish data to SAP BDC.

What's next