Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Data Sync & ETL

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

  1. Schedule: Daily 06:30 (Berlin)
  2. Configure Run
  3. ERP: Fetch Open Sales Orders
  4. Normalize ERP Rows
  5. Batch Over Orders
  6. Upsert Order into Mart
  7. Credit Block or High Value?
  8. Slack: Alert Finance
  9. Log Blocked Order Event
  10. Continue Batch Loop
  11. Query Mart Totals
  12. Build Digest HTML
  13. Email Ops Digest
  14. Slack: Post Daily Digest

19 steps in total.

Similar automations