SAP Business ByDesign Destination for Reverse ETL Request
Which business application?
SAP Business ByDesign (SAP ByD).
What object in the destination?
Supplier invoices (Accounts Payable) —
created via SOAP API or a Custom OData Service exposed by our ByD tenant (my understanding is that SAP ByD has no standard pre-built OData API for this object. Line items included per
invoice, with batching support for large invoices (up to ~1300 line items in our
current volumes).
How will records be identified?
Records identified by a stable invoice
key (Coupa invoice ID / invoice_number + supplier_number) on the payload
model or a load timestamp.
Question: for a create-only object like this, how does
Activations guarantee exactly-once delivery across resyncs/backfills, and
does it surface per-record delivery success/failure back to the customer
(e.g. writeable to a Snowflake audit table)?
What sync behaviour?
Insert/create-only — no updates or deletes required for our use case.
Additional context:
We currently integrate with SAP ByD via a custom AWS
Lambda function calling SAP's SOAP/WSDL API
(ManageSupplierInvoiceIn). We're open
to either protocol Fivetran supports best:
- SOAP/WSDL — matches our current integration (ManageSupplierInvoiceIn)
- OData — SAP's standard API protocol across its current cloud portfolio
(S/4HANA Cloud, C4C, and ByD's own Custom OData Service framework, which
we would need to expose ourselves via Admin > OData Service Authoring).
Please sign in to leave a comment.
Comments
0 comments