Data integration and ETL
Moving data between systems is the least glamorous part of analytics and the part that breaks most often. These posts cover the tools that do it, from ETL platforms and connectors to orchestration and governance, alongside hands-on pieces on the specific jobs people get stuck on: combining tables in Excel, or giving an AI agent a pipeline it can drive.
18 posts · page 1 of 2
- 7 min
A CLI Your Agent Can Drive
Command line tools are written for people: aligned columns, color, a prompt before anything destructive, an error in a sentence. Every one of those is a hazard for a program. mammoth-cli was built for both readers: deterministic output, no prompts off a terminal, stable error codes, and a mutation class on every command.
Jasper Flour · 15 August 2026 - 4 min
Write the Logic Once
The same threshold is hardcoded in nine pipelines. Somebody changes it in seven. Parameters and snippets exist so that the value and the logic live in one place, and every pipeline that uses them tells you when it has not caught up yet.
Jasper Flour · 14 August 2026 - 4 min
Who Can See What
Most permission systems fail in the same direction: everyone becomes an admin because the alternative is being blocked at four in the afternoon. A model people can actually reason about is one where the interesting question, who can change this, has a short answer.
Jasper Flour · 14 August 2026 - 6 min
Files That Are Not Tables
Most data does not arrive as a clean rectangle. It arrives as a PDF invoice, a spreadsheet with a title row and three tables on one tab, or a scan of something printed. Converting one is easy. Converting the same thing every month, the same way, is the actual problem.
Jasper Flour · 14 August 2026 - 4 min
Data Has to Go Somewhere
Getting data in is the part everyone plans for. Getting it back out, into the warehouse or the storage account or the BI tool or the system that triggers something, is where integration projects quietly stall.
Jasper Flour · 14 August 2026 - 4 min
A Refresh That Tells You When It Breaks
Automation that fails loudly is annoying. Automation that fails silently is dangerous, because the report still renders and the number is still wrong. The interesting part of a scheduled refresh is not the happy path. It is what happens the week the source changes shape.
Jasper Flour · 14 August 2026 - 7 min
Manual vs Automated Data Workflows
Data workflow automation is revolutionizing how businesses handle their information. Gone are the days of tedious manual data processing and time-consuming spreadsheet manipulation. Companies are now turning to automated solutions to streamline their data pipelines, boost efficiency, and make better decisions. But what exactly is data workflow automation, and how does it compare to traditional
Jasper Flour · 27 July 2026 - 13 min
Data Pipeline Software: 8 Tools You Should Know (in 2026)
Eight data pipeline tools sorted by who can run them, plus the orchestration engines engineers reach for and the app-to-app automation tools that get confused with pipelines.
Jasper Flour · 13 April 2026 - 18 min
The 12 Best Data Preparation Tools (in 2026)
The 12 best data preparation tools compared for teams that do not want to write code or wait on engineers, plus the code-first wrangling libraries and the warehouse-side transformation tools they get compared with.
Gaurav Dudhoria · 16 March 2026 - 8 min
Data Harmonization Tools: 7 Best in 2026 (Compared)
The best data harmonization tools, compared by capability, ease of use, and who they're built for. Includes free and enterprise options.
Jasper Flour · 16 March 2026 - 12 min
How to Connect Snowflake to Excel: 4 Best Methods
Step-by-step instructions to connect Snowflake to Excel using ODBC, the Excelerator Add-In, Power Query, or Mammoth Analytics. Covers Windows and Mac.
Jasper Flour · 5 March 2026 - 11 min
QuickBooks Consolidation Software: Multi-Entity Guide
Consolidate multiple QuickBooks companies automatically. Learn how finance teams save 20-40 hours per close and eliminate intercompany errors. Real examples.
Jasper Flour · 3 November 2025
Connect your sources directly.
Tested connectors for the common sources, plus anything with a REST API, cleaning and combining on the way in.
- 14-day Pro trial
- No credit card
- Viewers always free