Skip to main content
Feedback

Boomi for SAP connection

Boomi for SAP connector securely links your SAP system with Data Integration. This connection lets you ingest complete data at a multi-table scale with Boomi for SAP views and Event Streams, ensuring fast, accurate, and duplicate-free data loads into any supported data warehouse or data lake.

Prerequisites

Boomi for SAP is a native integration that enables you to replicate and stream SAP data into Data Integration using table services and event-based Change Data Capture (CDC). For CDC flows, Boomi Event Streams acts as the message broker between the SAP producer and the BDI consumer, providing reliable, near–real-time event delivery. Both Boomi for SAP and Event Streams are required to use CDC connectivity.

  • An active Boomi for SAP account. For setup information, refer to Getting started with Boomi for SAP.
  • Create the Boomi for SAP table services and finalize them in Boomi for SAP before you connect the source.
  • A SAP/Boomi user with access to the views you are replicating.
  • An active Event Streams environment. For more information, refer to Environments.
  • An Event Streams topic configured to receive SAP events. For more information, refer to Topics.

For end-to-end setup instructions across all components, refer to Boomi for SAP: CDC flow set up guide.

Procedure

  1. Log in to the Data Integration Console.
  2. Go to Connections from the left-hand menu.
  3. Click + New Connection.
  4. In the search box, type Boomi for SAP, and select it. The Create Boomi for SAP Connection dialog appears.
  5. Enter a Connection Name.
  6. In Host and Port, enter the SAP system host and port.
  7. In Username and Password, enter the credentials for your SAP or Boomi account.
  8. In SAP Client, enter the client number.
  9. (Optional) If your server is on-premises, toggle SSH Tunnel to On and establish an SSH connection.
  10. Switch the Enable CDC Connectivity (Event Streams) toggle to On for CDC Flow.
    • In Environment Token, enter the token generated. For more information, refer to Environments.
    • In Event Streams Topic Name, enter the topic name created. For more information, refer to Event stream topic creation.
Best practice

Maintain a 1:1 relationship between an SAP event in Boomi for SAP and a table service. Reusing the same table service across multiple events causes duplicate CDC messages on the Event Streams topic and inflates message costs.

  1. Click Save and Test Connection. If the connection is successful, it is available for use within Data Integration.

Establishing an SSH connection

If your Boomi for SAP database is running on an on-premises server, use SSH tunneling to establish a secure connection.

Prerequisites

  • Configure your SSH tunnel server to accept connections from Data Integration IP addresses.
  • Ensure the SSH tunnel can connect to your Boomi for SAP database using the internal IP address.

Procedure

  1. Log in to the Data Integration console.
  2. Go to Connections from the left-hand menu.
  3. In the search box, type Boomi for SAP, and select it. The Create Boomi for SAP Connection dialog appears.
  4. In the connection dialog, switch the SSH Tunnel toggle to On. The SSH configuration fields appear.
  5. In the SSH Credentials section, configure the following details:
    • SSH Port: Enter the port number for the SSH connection. The default is 22.
    • SSH Hostname: Enter the internal hostname of the SSH tunnel server.
    • SSH Remote User Name: Enter the username used to authenticate the SSH connection.
  6. In the SSH Tunnel section, ensure to select Upload PEM and configure the following:
    • SSH Connection Key File (Pub/Pem): Drag and drop your private key file (.pem) into the designated area, or click Browse for a file to upload it.
    • SSH KEY File Password: (Optional) If your private key is password-protected, enter the password here.
  7. Click Save and click Test Connection. If the connection is successful, it is available for use within Data Integration.
On this Page