SAP Business ByDesign Setup Guide

Follow our setup guide to connect SAP Business ByDesign to Fivetran.

Prerequisites

To connect SAP Business ByDesign to Fivetran, you need a SAP Business ByDesign Admin account.

Setup instructions

Create new communication system

1. Log in to SAP Business ByDesign with an Admin account.
2. On the navigation menu, click Application and User Management.
3. In the Input and Output Management tab, select Communication Systems.
4. Click New.
5. In the New Communication System page, enter the following details:
   • ID: 'FIVETRAN'
   • SAP Business Suite: Leave the checkbox clear
   • Host Name: 'externalsystem'
   • System Access Type: Select Internet
6. Click Actions and select Set to Active.
7. Click Save and Close.

Create communication scenario

1. Go to the Input and Output Management tab and select Communication Scenarios.
2. Click New.
3. In the New Communication Scenario guided activity page, enter the Communication scenario name as 'FIVETRAN_DATA_LOADER'.
4. Click Add Operations.
5. In the pop-up window, sort the list based on service description.
6. Select the Add Operation checkbox for all the service descriptions names that start with 'Query'.
7. After adding all the operations, click Ok.
8. Click Save and Close.

Create communication arrangement

1. Go to the Input and Output Management tab and select Communication Arrangement.
2. Click New.
3. In the New Communication Arrangement guided activity page, select the 'FIVETRAN_DATA_LOADER' communication scenario you created in Step 2.
4. In the System Instance ID field, select FIVETRAN and then click Next.
5. Verify the technical details.
6. Select the following details:
   • Communication Method: Direct Communication
   • Application Protocol: Web Service
   • Authentication Method: User ID and Password
   • User ID:
     • Click Edit credentials and set a password. Make a note of the User ID and password. You will need them to configure Fivetran.
7. Click Next and review the data you have entered.
8. Click Finish.
9. Click Close.

Find registered URL

In the connection setup form, make a note of the automatically-generated Registered URL. You will need it to configure webhook event notifications.

Setup event notification

1. In your SAP Business ByDesign account, go to the Input and Output Management tab and select Event Notification.
2. Click New.
3. Enter the following details:
   • Name: FIVETRAN_WEBHOOK
   • Endpoint: Enter the URL you found in Step 4
   • Authentication Method: None
4. Click Add Row.
5. Click Business Object.
6. Add and select the following business objects:
   • AccountingEntry
   • ActivityTask
   • AppointmentActivity
   • Campaign
   • Customer
   • CustomerInvoice
   • CustomerQuote
   • DirectDebitMandate
   • EmailActivity
   • Employee
   • GoodsAndServiceAcknowledgement
   • HouseBankStatement
   • LabourResource
   • PhoneCallActivity
   • ProductDesign
   • ProductRequirementSpecification
   • ProductionLot
   • PurchaseOrder
   • PurchaseRequest
   • PurchasingContract
   • SalesOrder
   • ServiceRequest
   • Supplier
   • SupplierInvoice
   • TradeReceivablesPayablesAccount
   • VehicleResource
7. For all of the rows you added, select ROOT as the business object node and select the Deleted checkbox. For the CustomerInvoice business object, select CustomerInvoice as the business object node instead of ROOT.
8. Click Activate and then click Close.

Finish Fivetran configuration

1. In the connection setup form, enter the Destination schema name of your choice.
2. Enter the Username from Step 3.
3. Enter the Password you created in Step 3.
4. Enter your Instance URL. Use the following format https://my****.sapbydesign.com.
5. Click Save & Test. Fivetran will take it from here and sync your data from your SAP Business ByDesign account.

Related articles

description Connector Overview

account_tree Schema Information

assignment Release Notes

settings API Connection Configuration

home Documentation Home