Data Sync & ETL
Sync ERP orders from SQL Server to Postgres and alert Finance on Slack
Daily at 06:30, pulls open sales orders from SQL Server into a Postgres data mart in batches and sends Finance alerts and a digest.
What it does
## ERP Order-to-Cash Sync (Order-to-Cash = O2C) Pulls open sales orders from a Microsoft SQL Server ERP (SAP B1 / Dynamics / custom schema), normalises them, upserts into a PostgreSQL data mart in batches, alerts Finance about credit-blocked or high-value orders, and mails/posts a daily digest. Runs: every day at 06:30 · Batch size: 100 orders Edit me first: the Configure Run node (thresholds, channels, e-mail).
The steps
- Schedule: Daily 06:30 (Berlin)
- Configure Run
- ERP: Fetch Open Sales Orders
- Normalize ERP Rows
- Batch Over Orders
- Upsert Order into Mart
- Credit Block or High Value?
- Slack: Alert Finance
- Log Blocked Order Event
- Continue Batch Loop
- Query Mart Totals
- Build Digest HTML
- Email Ops Digest
- Slack: Post Daily Digest
19 steps in total.
Similar automations
E-commerce & PaymentsRoute store webhook orders to supplier, shipping, CRM and ERP with stock checks24 stepsData Sync & ETLRun an SQL Query in Microsoft SQL Server3 stepsData Sync & ETLRun an SQL Query on Microsoft SQL Server2 stepsFinance, Invoices & AccountingReconcile bank payments to invoices and ERP using Postgres and Claude33 steps