Phalanx is the data layer behind the Ph-Ecosystem. It reads SYSPRO's metadata catalogue (DdsTables, DdsColumns, DdsForeignKeys, DdsColumnValues) on first run to auto-discover the schema — no hand-mapped column lists, no manual type coercion. From there it loads to Postgres with watermark-based incremental sync (only the delta rows touched per cycle), then emits typed dbt staging models so analysts can build dimensional marts without leaving dbt.
Designed for SYSPRO 8 installs and the businesses that have outgrown spreadsheet exports but can't justify a full data-team headcount.
Key capabilities
- Metadata-driven schema discovery via SYSPRO Dds* dictionary
- Auto-generated dbt staging models (`phalanx generate --module INV`)
- Watermarked incremental sync — only delta rows per cycle
- Ten core SYSPRO modules out of the box (Inv, Ar, Sor, Por, Gl, Ap, Sal, Wip, Bom, Grn)
- Postgres data warehouse with dimensional marts (dim_/fct_)
- Pairs with Pharos for natural-language queries against the warehouse
Deployments
Tru-Trac Manufacturing (Centurion)
Interested in Phalanx?
Let's discuss how Phalanx can fit into your operations.
Talk to us about Phalanx