Skip to main content

Create and manage the SAP Business Data Cloud (BDC) connector

important

The use of the SAP BDC Connector to export data from SAP BDC into the Databricks platform is an approved functionality permitted by SAP.

This page explains how to set up an SAP Business Data Cloud (BDC) connection on Databricks for Delta Sharing. This connection is necessary for sharing with and receiving shares from an SAP BDC account.

Requirements​

  • You must be be a workspace admin.
  • You must have the CREATE PROVIDER and CREATE RECIPIENT privileges.

Create an SAP BDC connection on Databricks​

You must create an SAP BDC connection before granting data access to, or receiving data from, an SAP BDC account. The user who creates the SAP BDC connection becomes its owner. Upon creation, two objects are automatically created and corresponds to the SAP BDC account:

  • Provider object
  • Recipient object

To create a connection, you must first send a Databricks connection identifier to an SAP BDC admin. The SAP BDC admin then uses the connection identifier to generate a connection link on SAP BDC. With the connection link, you finish creating the SAP BDC connection on Databricks.

Step 1: Obtain a connection identifier for an SAP BDC admin​

  1. From the Databricks sidebar, click Data Ingestion.
  2. Select the SAP Business Data Cloud tile.
  3. Click Connection Identifier.
  4. Share the partner identifier information with your SAP BDC admin.
  5. Ask your SAP BDC admin to set up a Databricks connection on SAP BDC using the provided identifier information. See the SAP BDC documentation.

Step 2: Create an SAP BDC connection​

  1. After your SAP BDC admin sends you the Databricks connection for your identifier, click Connect to SAP BDC.
  2. In Connection link from SAP BDC, copy the invitation link sent from your SAP BDC admin.
  3. Click Connect.
  4. After the connection is established, the SAP BDC account is automatically added as a share provider and recipient. You can access shares granted by an SAP BDC admin on Databricks and Delta share Databricks assets to SAP BDC.
  5. Click View provider to see all data products received from the SAP BDC account. Or click View recipient to see all data assets you have shared with the SAP BDC account.

Update connection owner​

You must be the connection owner or a metastore admin to update the owner of a connection.

To change the owner of a connection, do the following:

  1. From the Databricks sidebar, click Data Ingestion.
  2. Select the SAP Business Data Cloud tile.
  3. Find the connection you want to update and click Kebab menu icon..
  4. Select Edit owner.

Delete a connection​

After the connection is deleted, the Databricks workspace loses access to all data products shared by the SAP BDC admin and the SAP BDC recipient loses access to shares.

You must be the owner of the connection.

Step 1: Clean up shared assets​

Unmount any shares received from SAP BDC from catalogs. The owner of the catalog must do this. See Unmount a share.

If mounted catalogs still exist, you cannot delete the connection.

Step 2: Delete the SAP BDC connection​

After unmounting all shared assets, do the following to delete an SAP BDC connection:

  1. From the Databricks sidebar, click Data Ingestion.
  2. Select the SAP Business Data Cloud tile.
  3. Find the connection you want to update and click Kebab menu icon..
  4. Select Delete connection.

Limitations​

  • There is a limit of five connections per metastore.
  • You can only share data with and receive data from an SAP BDC recipient in the same cloud.
  • You cannot share tables with history. Any features that require a table's history is not supported.

Next steps​

Last updated on