SAP Business ByDesign Setup Guide Private Preview

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

Prerequisiteslink

To connect SAP Business ByDesign to Fivetran, you need:

• A SAP Business ByDesign account
• Admin privileges

Setup instructionslink

Create new communication systemlink

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 unchecked
   • Host Name: ‘externalsystem’
   • System Access Type: Select Internet
6. Click Actions and select Set to Active.
7. Click Save and Close.

Create communication scenariolink

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. Check 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 arrangementlink

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.

Finish Fivetran configurationlink

1. In the connector 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 Contentlink

description Connector Overview

account_tree Schema Information

settings API Connector Configuration

home Documentation Home