Real pipelines, built on the DataLug canvas
Review popular use cases from different industries. Each shows the connectors involved, the nodes on the canvas and how branching sends every record to the right place. Describe any of them to Milo to get a draft.
- Source
- Filter and branch
- Transform
- Checkpoint
- Target
- Notify
Supplier order reconciliation
A retailer picks up supplier files each night, matches them to open orders, and sends the exceptions to whoever fixes them.
ASK MILO
“Every night, match supplier CSVs on SFTP to our orders and flag anything that doesn’t match.”
Closed-won deals to warehouse and finance
A B2B software company loads won opportunities into Snowflake every night. Finance hears about a large deal the moment it lands.
ASK MILO
“Sync closed-won opportunities to Snowflake nightly and tell finance about deals over $50k.”
Route inbound leads by region
An agency routes each new marketing contact to the sales CRM covering its region. Anything that does not match is flagged for review.
ASK MILO
“Send new HubSpot contacts to Pipedrive for North America and Zoho for EMEA.”
Escalate urgent tickets to engineering
A support team opens an engineering issue for urgent tickets and pages on-call. Every ticket still lands in the warehouse.
ASK MILO
“When a Zendesk ticket is urgent, open a Jira issue and post to #on-call.”
Replicate the ERP for reporting
A manufacturer copies changed work orders from Oracle into PostgreSQL incrementally, and quarantines the rows that fail validation.
ASK MILO
“Copy new and changed Oracle work orders into Postgres every hour and email us about bad rows.”
Proof-of-delivery file intake
A logistics operator reads delivery files as drivers upload them, loads the good ones and archives the originals. Dispatch hears about the failures.
ASK MILO
“Load proof-of-delivery files from S3 into SQL Server, archive them, and alert dispatch if one fails.”
Month-end ledger consolidation
An accounting team combines branch ledgers into one close summary, and sends anything outside tolerance to the controller.
ASK MILO
“Total the branch ledgers in SharePoint into a summary sheet and email the controller about variances over 2%.”
One clean donor database
A nonprofit turns event sign-up sheets into donor records. New people are inserted, known ones updated, bad data flagged.
ASK MILO
“Add new event sign-ups to our donor database and update people we already have.”
Lease renewal follow-ups
A property manager reads lease end dates out of stored documents and starts renewal follow-ups 60 days ahead.
ASK MILO
“Find leases in Dropbox ending within 60 days and create a renewal task in Freshsales.”
Moderation reports to the right queue
An online community pulls open reports from its platform API, opens tracked cases for the serious ones, and keeps moderators informed.
ASK MILO
“Every 15 minutes, send high-severity reports to Jira and post all new reports to our mods channel.”
Salesforce as the source of truth for support and marketing
A SaaS operations team keeps Salesforce as the source of truth. When an account changes there, customers are updated in Zendesk and prospects in HubSpot.
ASK MILO
“When a Salesforce account changes, update customers in Zendesk and prospects in HubSpot.”
Reverse ETL to Salesforce, and archival back to Snowflake
An enterprise data team runs two workflows against one warehouse. Account scores modelled in Snowflake go into Salesforce every hour, and closed cases older than two years move out of Salesforce into Snowflake each month.
ASK MILO
“Update Salesforce accounts hourly with health scores from Snowflake, and archive cases closed over two years ago to Snowflake monthly.”
Build the pipeline you have in mind
Describe it to Milo in the free trial, or tell us which system you need connected.