ACH

The Automated Clearing House (ACH) connector bridges the gap between financial transaction data and analytical workflows. It allows users to query ACH files — such as payment batches, returns, or change notifications— using standard SQL without manual parsing, reformatting, or reliance on proprietary banking tools.

At its core, the connector treats each ACH entry as a structured record and each batch as a logical table. It automatically interprets NACHA-formatted files, mapping headers, entries, and control records into clearly defined fields. When you query an ACH file, the connector reconstructs its hierarchical layout, transforming what’s typically a flat, position-based format into data your query engine can reason about.

This connector is designed for both simplicity and precision. With just a few lines of configuration, you can open up entire ACH files for validation or reporting. Yet, for more complex workflows that require custom field mappings or addenda parsing, you can fine-tune behavior using a rich set of options that control how Metaform interprets and normalizes each transaction segment.