SAP Business ByDesign link
Updated October 23, 2023
SAP Business ByDesign is a cloud enterprise resource planning software for small and medium-sized organizations.
|Capture deletes||check||All tables|
|Data blocking||check||Column level|
|API configurable||check||API configuration|
|Fivetran data models||check||Get the models: source / transform|
Follow our step-by-step SAP Business ByDesign setup guide to connect SAP Business ByDesign with your destination using Fivetran connectors.
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.
Fivetran uses one of the following strategies to update the tables that you included in your sync:
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
|Direct Debit Mandate|
|Goods and Service Acknowledgement|
|Phone Call Activity|
|Product Design Version|
|Product Requirement Specification|
|Production Bill of Materials|
|Trade Receivables Payables Account|
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
|Account Open Amount|
|Bank Details of Employee|
|Business Document Message Monitoring Information|
|Business Partner Hierarchy|
|Company Financials Process Control|
|Company Payment File Register Outgoing File|
|Document Output Request Information|
|Kit Item List|
|Object ID Mapping|
|Production Bill of Operation|
|Read Access Log|
|Return To Supplier|
|Sales Product Catalogue|
|Service Product Valuation Data|
|Site Logistics Task|
|Time Account Balance|
|Working Time Model|
Based on the sync strategy, Fivetran uses one of the following strategies to capture deletes of the tables:
To capture deletes for incremental tables, we use the Event Notification feature that sends an alert to our webhook in case of a delete.
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.