Migration Engine
Move data between systems.
15 connectors. 38 transform functions. 8-stage pipeline with adaptive batching, checkpoint/resume, conflict detection, self-healing remediation, and five quality gates. Salesforce Bulk API v2 for high-volume loads.
Audit EngineNew
Know your data before you move it.
DuckDB-powered analytical engine running 68 checks across security, compliance, data quality, and architecture. Cloud detection for 14 cloud types. Vertical-specific checks. JSON, Markdown, and HTML report export. CLI or desktop.
New: Audit Engine
Connect to any Salesforce org and run a comprehensive audit. 23 universal checks cover security, data quality, schema health, and API usage. 8 vertical-specific checks for industries like nonprofits where specialized data rules apply. The DuckDB analytical engine processes org metadata at columnar speed, not row-by-row. Cloud detection identifies 14 cloud types (Sales, Service, Nonprofit, Health, Financial Services, and more) and auto-selects relevant checks.
pf-audit CLI: connect, audit, checks, version. JSON + Markdown + HTML export.
Every record passes five checkpoints. If any gate fails, the migration stops. Not pauses. Fix the issue, re-run, and every record passes clean.
AutoMapper scores every possible source-to-target field mapping using name similarity, type compatibility, and domain-specific patterns. Accept the suggestions, adjust with 38 built-in transform functions, or load a pre-built accelerator. Lookup tables, aggregations (SUM, COUNT, AVG with GROUP BY), and row context variables ($ROW_NUMBER, $BATCH_NUMBER) handle the edge cases.
38 transforms. Lookup tables. Undo/redo. Live data preview. 3 accelerators.
When the target rejects a record, Pathfinder does not just log the error. Required field missing? Applies the default and retries. String too long? Truncated. Rate limited? Switches to Bulk API. Lookup not found? Queued for a second pass after the referenced records exist. Eight pre-built remediation rules handle the errors that stop every other migration tool cold.
9 remediation actions. Checkpoint/resume. Adaptive batch sizing (50 to 2,000 records).
A composable AI engine with patterns for Salesforce development, Agentforce agent design, security review, governor limit analysis, and migration planning. Run patterns through Claude, GPT-4, or local Ollama models. Chain them into DAG pipelines with conditional nodes, loops, merge strategies, and streaming output. 14 reasoning strategies from chain-of-thought to governor-aware.
Visual DAG editor. 7 node types. 15 edge transforms. Agentforce integration.
After review by engineers from Talend, MuleSoft, dbt, Fivetran, Airbyte, Snowflake, Databricks, Confluent, and 15 other data platforms
"We exported 50,000 records and ended up with 12,000 duplicates."
Pathfinder's identity resolution uses Jaro-Winkler fuzzy matching and phonetic encoding to find duplicates before they reach the target. Composite scoring across email, name, phone, and address with configurable confidence thresholds.
"We don't know what state our Salesforce org is in."
Run 68 audit checks before the migration starts. DuckDB-powered analytics across security config, data quality, schema health, API usage, and cloud-specific rules. Get a clear report with findings and severity. Know the org before you touch it.
"The migration worked in sandbox but failed in production."
Five quality gates catch issues between extraction and loading. Validation rules, required fields, picklist mismatches, field length violations. If something will fail in production, it fails at the gate. Not at 2am.
"We spent two weeks mapping fields in a spreadsheet."
AutoMapper suggests mappings. Accelerators provide 80% pre-configured templates. 38 transform functions handle format conversion, concatenation, date parsing, and validation. Lookup tables handle value mapping. Live preview shows results before execution.
Pathfinder is a native macOS desktop application. Credentials live in the Keychain. Data lives in local SQLite and DuckDB. Processing is local. No cloud. No telemetry. No third-party access.
Fifteen built-in connectors: Bloomerang, Raiser's Edge NXT, DonorPerfect, Salesforce, Dynamics 365, HubSpot, PostgreSQL, MySQL, SQLite, CSV, Excel, JSON, XML, Google Sheets, Airtable, REST APIs, and SFTP. Plus YAML-defined custom connectors for anything with an API.
Connect to a Salesforce org. Pathfinder extracts metadata, loads it into DuckDB, and runs 68 checks covering security configuration, data quality, schema health, API limits, and cloud-specific rules. Results export as JSON, Markdown, or HTML. Runs from the desktop app or the pf-audit CLI.
For the eight most common Salesforce rejection types (REQUIRED_FIELD_MISSING, STRING_TOO_LONG, DUPLICATE_VALUE, rate limits, ENTITY_IS_DELETED, MALFORMED_ID, UNABLE_TO_LOCK_ROW), Pathfinder remediates and retries automatically. For everything else, it logs the error and continues. You configure the threshold.
Pathfinder auto-selects Salesforce Bulk API v2 for batches over 10,000 records. 500,000 records in approximately 7 minutes. Adaptive batch sizing adjusts in real-time. Checkpoint/resume means progress is never lost.
No. Native macOS desktop application. All processing is local. Credentials are in the macOS Keychain. The audit engine uses DuckDB locally. The only network traffic is between your machine and the systems you connect to.
Pathfinder is in early access for consultants and implementation partners. Built in Rust. Tested with 4,695 automated tests. Ready for production data.
Request early access