◆ NOISE IN → SIGNAL OUT◆ READALCHEMIST.COM◆ FREE / NO PAYWALL◆ NOISE IN → SIGNAL OUT◆ READALCHEMIST.COM◆ FREE / NO PAYWALL
THE DIGITAL ALCHEMIST
◆ OpinionInfraIMPACT 72

Salesforce Data Loader on Mac Is a Workaround. QueryFlow Is a Tool.

The CLI is Windows-only, Java is still required, and scheduling is still manual. Twenty years in, that is not a rough edge — it is a design decision. Mac-primary operators deserve better.

2026-06-056 MIN READ#Salesforce · #ETL · #macOS · #Data Engineering · #AI Tooling · #QueryFlow · #Automation

The Thesis

Salesforce Data Loader is free, proven, and handles bulk data at scale. On a Mac, it becomes a series of compromises: a Windows-only CLI, no native scheduler, and a mandatory Java Runtime Environment 17+ install that you must handle separately before the app will even launch. For the growing class of operators — engineers, technical founders, RevOps leads — running exclusively on Apple Silicon, this is not an oversight. Salesforce's own documentation states that command-line mode is available on Windows only. QueryFlow, a native macOS application, bundles SQL editing, Python notebooks, ETL scheduling, and Claude AI into a single binary. Before paying for it, the question is whether the gap is real enough to justify the cost, and whether QueryFlow can actually fill it.

What the Documentation Actually Says

Salesforce's developer documentation states that command-line mode is available on Windows only. That is not interpretation—it is the primary mechanism for automating or scheduling Data Loader jobs, and it exists on one platform.

The current Spring '26 release, built for API v66, requires Java Runtime 17 or later. Data Loader no longer bundles Java. If you don't already have a JRE, you must download and install Azul Zulu OpenJDK separately. A January 2025 YouTube tutorial confirms this multi-step process remains current for Mac users.

There is no native scheduling in the user interface. Automated jobs require the CLI—which is Windows only. Multiple independent practitioner sources confirm this, not just Salesforce's own documentation.

The strongest pushback: the Spring '26 release officially supports macOS 13.x Ventura, 14.x Sonoma, and 15.x Sequoia on both Intel x86-64 and ARM 64-bit architectures. Apple Silicon runs the tool. The JVM adds friction but is not a blocker. Technically savvy operators have documented workarounds—the CLI pairs with cron jobs to schedule tasks. This is friction, not a wall.

But "use cron to invoke a Java-based CLI that only exists on Windows" is not a workaround for Mac-primary teams. It is a Windows VM, a shell script calling a process designed for another OS, or operational debt you pretend does not exist. Engineers tolerate this. Lean technical teams should not have to.

The Landscape Around Data Loader

The alternatives each hit a ceiling.

The Data Import Wizard caps at 50,000 records per import, offers no scheduling or automation, and lacks advanced transformation.

Dataloader.io is entirely web-based, supports recurring tasks, and does automated lookup matching—but the free tier limits you to 10,000 records per month. Higher volume requires a paid plan. For daily syncs at scale, the free tier is a demo, not production.

Jitterbit discontinued its macOS version in May 2024. The last macOS release (10.72) was 32-bit, incompatible with Catalina and later. macOS users needed a Windows virtual machine to use it. That option is gone.

Data Loader itself scales beyond both: it can handle up to 5 million records per job using Bulk API, and significantly more with Bulk API 2.0. For large migrations, that ceiling matters, and no competitor has documented matching it.

What QueryFlow Actually Claims

QueryFlow positions itself as a native macOS application combining SQL editing, Python notebooks, Claude AI integration, and scheduled ETL—all in one tool—at $49.99 per month. Its Salesforce-specific features live on a companion landing page, while the primary homepage features Snowflake, Redshift, and PostgreSQL. That placement is telling: Salesforce is a use case for QueryFlow, not its center. The depth of its SOQL support, Bulk API handling, and Salesforce object coverage has not been independently benchmarked at scale.

The AI integration is genuinely differentiated. QueryFlow's Claude integration is schema-aware—the model sees live tables, columns, relationships, and actual query results without copy-paste. That is materially different from keeping a separate LLM chat window open next to DBeaver. Whether it holds up with hundreds of custom Salesforce objects at production complexity remains undocumented.

The scheduler also claims significance: pipelines running while the Mac sleeps, output routing to SFTP, S3, or local files, and one-click conversion of notebooks to scheduled jobs. The value proposition is real. Production proof points are not yet public.

Three Counter-Arguments Worth Taking Seriously

First, cost. Data Loader is free and included with every org license. QueryFlow at $49.99 per month requires real justification. For a solo admin doing quarterly cleanups, the math fails. For three engineers running daily ETL between Salesforce and a warehouse, it shifts.

Second, record volume. Data Loader handles operations up to 150 million records, supports INSERT, UPDATE, UPSERT, DELETE, and export, and offers CLI-based automation. QueryFlow's ceiling for Salesforce ETL is not documented. Anyone moving tens of millions of records should treat this as a deciding factor, not a minor gap.

Third, vendor maturity. QueryFlow is a single-product vendor with no public funding disclosure, customer count, or SLA documentation. Enterprise buyers with compliance or data residency requirements need answers on audit logging, support SLAs, and where Salesforce metadata lands when it flows through an embedded Claude API. Routing live schema and query results through an external LLM is a governance conversation, not just a feature.

The Real Trade-Off

Data Loader is the right tool for large-scale Salesforce data work on Windows. On Mac, it is capable but operationally expensive: a mandatory JRE install, no native scheduler, a CLI that does not exist for your platform. That expense is minor for an engineer setting it up once. It compounds for teams needing reliable pipelines that run without supervision.

QueryFlow does not beat Data Loader on volume, price, or proven enterprise depth. What it offers is the right stack in one place—native execution, AI-assisted field mapping, embedded scheduling—for a persona Salesforce has never prioritized: the Mac-primary technical operator building data pipelines, not managing data archaeology.

For occasional bulk loads or migrations above five million records, use Data Loader and accept the friction. For teams building recurring Salesforce ETL workflows on Mac—syncing to Snowflake, staging exports to S3, transforming data with Python before upsert—QueryFlow merits a serious trial. The $49.99 per month buys you out of the JVM tax, the Windows VM, and the cron script. Whether it delivers production reliability at scale is still a question only your own pilot can answer.

Sources
  1. Salesforce Data Loader | Salesforce Developers
  2. Data Loader Releases — forcedotcom/dataloader (GitHub)
  3. QueryFlow — Native macOS Data Tool
  4. QueryFlow — Salesforce Data Loader Mac Alternative
  5. Best Data Loaders for Salesforce in 2026 — dgt27
  6. 9 Best Salesforce Data Loader Tools: A 2026 Guide — Skyvia
  7. Salesforce Data Loaders: Tools, Tips & Best Practices [2026] — Skyvia
  8. Salesforce Data Loader: Full Guide from Setup to Automation — Xappex
  9. How to Setup Salesforce Data Loader — Hightouch
  10. dataloader.io
  11. A Graphical SOQL Query Builder for Flow, plus an Execute SOQL Action – UnofficialSF
  12. Salesforce SOQL | Workato docs
  13. Salesforce - Connectors | Microsoft Learn
  14. What counts as a SOQL query in | Salesforce Trailblazer Community
  15. Salesforce Database Query Tool for Mac, Windows, and Linux
  16. Using Salesforce - Altair RapidMiner Documentation
  17. Introduction to Salesforce Connect for External Applications | Salesforce Ben
  18. Excel to Salesforce Connector [In-Depth Review] | Salesforce Ben
  19. SoqlXplorer for Mac - Download
  20. Data Loader Guide Version 67.0, Summer ’26 Last updated: April 8, 2026
  21. Schedule Data Loader via Command Line in Salesforce | Mirketa
  22. Salesforce Data Loader Tutorial: A Step-by-Step Guide | by UATeam | Medium
  23. How to run Data Loader on Mac M1 machines
  24. Release Data Loader V64.0.2 · forcedotcom/dataloader
  25. Use One File to Install Data Loader on macOS or Windows
  26. Data Loader V60.0.0 · forcedotcom/dataloader · Discussion #928
  27. Data Loader
  28. Considerations for Installing Data Loader | Data Loader Guide | Salesforce Developers
  29. Download and Install Data Loader | Data Loader Guide | Salesforce Developers
  30. Download and Install Data Loader
← back to the feed
NVDA 208.64 ▲ 1.73%AAPL 301.54 ▼ 1.89%MSFT 411.74 ▼ 1.18%GOOGL 363.31 ▼ 1.42%AMZN 245.22 ▼ 0.33%META 585.39 ▼ 1.28%TSLA 408.95 ▲ 4.59%AMD 490.33 ▲ 5.14%AVGO 396.60 ▲ 2.82%PLTR 136.47 ▲ 0.69%COIN 162.11 ▲ 6.37%MSTR 127.20 ▲ 5.61%NVDA 208.64 ▲ 1.73%AAPL 301.54 ▼ 1.89%MSFT 411.74 ▼ 1.18%GOOGL 363.31 ▼ 1.42%AMZN 245.22 ▼ 0.33%META 585.39 ▼ 1.28%TSLA 408.95 ▲ 4.59%AMD 490.33 ▲ 5.14%AVGO 396.60 ▲ 2.82%PLTR 136.47 ▲ 0.69%COIN 162.11 ▲ 6.37%MSTR 127.20 ▲ 5.61%