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.
Datasheet
- Class
- ETL framework, SYSPRO → Postgres
- Schema discovery
- Automatic, via SYSPRO Dds* dictionary
- Sync
- Watermarked incremental, overnight
- Models
- Typed dbt staging + dim_/fct_ marts
- Module coverage
- 10 core SYSPRO modules
- Target
- SYSPRO 8 installs
- Status
- Live — in production
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
Deployment status
Tru-Trac Rollers (Centurion)
Interested in Phalanx?
Let's discuss how Phalanx can fit into your operations.
Talk to us about Phalanx