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 | check | |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
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.