SAP Business ByDesign

SAP Business ByDesign is a cloud enterprise resource planning software for small and medium-sized organizations.

Features

Feature Name	Supported	Notes
Capture deletes		All tables
History mode
Custom data
Data blocking		Column level
Column hashing
Re-sync		Connector level
API configurable		API configuration
Priority-first sync
Fivetran data models
Private networking
Authorization via API

Setup guide

Follow our step-by-step SAP Business ByDesign setup guide to connect SAP Business ByDesign with your destination using Fivetran connectors.

Schema information

This schema applies to all SAP Business ByDesign connectors. It is not a complete Entity Relationship Diagram. Some of the entities that are delivered by the Fivetran connector are omitted for brevity.

To zoom, open the ERD in a new window.

Updating data

Fivetran uses one of the following strategies to update the tables that you included in your sync:

Incremental

We perform incremental syncs for the tables that meet all the following conditions:

The table endpoint supports the SelectionByLastChangeDateTime FindByElement or SelectionBySystemAdministrativeDataLastChangeDateTime operation
The table returns the record's UUID in response
The table can be configured for the Event Notification view

Expand for the full list of incremental tables

Table Name
Account
Appointment Activity
Bank Statement
Campaign
Customer Invoice
Direct Debit Mandate
Email Activity
Employee
Goods and Service Acknowledgement
Journal Entry
Labor
Phone Call Activity
Product Design Version
Product Requirement Specification
Production Bill of Materials
Production lot
Purchase Order
Purchase Request
Purchasing Contract
Sales Order
Sales Quote
Service Request
Supplier Invoice
Supplier
Task Activity
Trade Receivables Payables Account
Vehicle

Re-import

Tables without the SelectionByLastChangeDateTime support or the Event Notification view must be re-imported in full to update. To maintain the speed of the overall updates, the frequency with which we update these re-import tables is based on how fast we can ingest them from SAP ByDesign. This speed is entirely dependent on SAP ByDesign performance and number of records present.

Table Import Duration	Import Frequency
3 seconds or less	Every sync
Between 3 seconds and 5 minutes	Twice a day
More than 5 minutes	Once a week

Expand for the full list of re-import tables

Table Name
Account Open Amount
Bank Details of Employee
Business Document Message Monitoring Information
Business Partner Hierarchy
Business Partner
Business Role
Company Financials Process Control
Company Payment File Register Outgoing File
Contact
Customer Contract
Document Output Request Information
Entitlement Products
Equipment
Exchange Rate
Jobs
Kit Item List
Lead
Lease Contract
Marketing Consent
Material
Object ID Mapping
Opportunity
Organisational Center
Outbound Delivery
Price list
Product Category
Production Bill of Operation
Production Model
Production Order
Projects
Read Access Log
Registered Product
Return To Supplier
Sales Product Catalogue
Service Agent
Service Confirmation
Service Product Valuation Data
Service Product
Shopping Cart
Site Logistics Task
Target Group
Time Account Balance
Working Time Model

Capturing deletes

Based on the sync strategy, Fivetran uses one of the following strategies to capture deletes of the tables:

Incremental

To capture deletes for incremental tables, we use the Event Notification feature that sends an alert to our webhook in case of a delete.

Re-import

To capture deletes for re-import tables, we mark records that we don't receive in the current sync as deleted.

NOTE: We hard delete records in the child tables regardless of whether the parent table is re-imported or incrementally synced.