SAP B1 → Power BI / Tableau Incremental Feed
Read-only, scheduled incremental extract from SAP Business One for BI tools. Pulls documents changed since the last high-water mark using an OData UpdateDate filter, filters out cancelled/void rows, normalizes multi-currency totals, and pushes a clean dataset to the BI push endpoint — never writing back to B1.
Steps in this flow
- Schedule: Incremental Refresh
- Read Last UpdateDate Watermark
- SL Login (read login, 401→relogin)
- SL: GET /Invoices (incremental, no cancelled)
- Normalize Multi-Currency + Shape
- Push Dataset → BI Endpoint
- Persist New Watermark (after successful load)
- Log Rows Pushed