EKOS:从遗留 ERP 源码证据生成可对账 Lakehouse,iDempiere 实测过银层测试
EKOS 在 iDempiere/Oracle 上演示:用源码、迁移与目录证据驱动 Trino/Iceberg/dbt 管线,Silver 测试近全通过,并强调大规模删除需人工确认。
开源项目 EKOS 公布一项里程碑:把遗留 ERP 源码证据编译进可对账的 Lakehouse 管线,而不是靠人工假设「表大概长这样」。团队以开源 Java ERP iDempiere(跑在 Oracle 上)做实测。
公开数字包括:分析 4,542 个 Java 文件;生成约 1,060 页源系统文档;对 165 张表做端到端测试,Bronze 层与 Oracle 逐表对账;Silver 层 3,667 项测试中 3,664 项通过;测试过程中发现 6 个真实缺陷;从分析到 Silver「零次 LLM 调用」。管线形态为 Trino 写入 Iceberg Bronze,再经 dbt-trino 做 Silver,并由 Dagster 编排。增量加载策略依据源码行为选择;删除通过分桶键比较检测,大规模删除会先卡住等人确认;Silver 测试用例来自数据库约束与 Java 模型。
团队同时坦陈边界:完整 849 表跑批仍受内存限制;仍有 195 处冲突待人工复核;Gold Mart 起草可用但后续工作还在进行。对经营与数据团队,这更像「把现代化证据链写进流水线」的示范:每条管线决策都能指回来源,测试失败能回到约束与模型,而不是一份难以复查的迁移脚本。对企业经营智能化场景,价值在于降低「迁完才发现对不上账」的风险,把人工复核集中在真正冲突的少数点上。
综合来看,读者可先核验官方渠道与发布时间,再结合自身业务边界与合规要求决定是否跟进试点;本文仅整理公开信息,不构成采购、投资或法律建议,关键数字与能力边界请以一手文档为准。
EKOS Builds Evidence-Backed Lakehouse Pipelines from Legacy ERP Code
🚀 A MAJOR MILESTONE FOR EKOS 🔥
From legacy ERP source code to a reconciled Lakehouse.
What happens when enterprise data pipelines are built on evidence from the source system—not assumptions?
We put EKOS to the test on iDempiere, an open-source Java ERP running on Oracle.
🔥 THE RESULTS:
🔍 4,542 Java files analyzed 📚 1,060 pages of source-system documentation generated 🧪 165 tables tested end-to-end, with every Bronze table reconciled against Oracle 📊 3,664 of 3,667 Silver tests passed 🛠️ 6 real bugs uncovered during testing ⚙️ Zero LLM calls from analysis through Silver
But the real milestone goes beyond the numbers.
EKOS compiled source code, database migrations, Git history, documentation, and the live Oracle catalog into an evidence-backed knowledge ledger.
That evidence informed the pipeline:
→ Trino → Iceberg Bronze → dbt-trino Silver → Dagster orchestration
Incremental loading is selected based on source-code behavior. Deletes are detected through bucketed key comparisons, with safeguards that hold mass deletions for human approval. Silver tests derive from database constraints and the Java model.
Every pipeline decision carries its evidence.
The full 849-table run remains constrained by available memory, and 195 conflicts still await human review. Gold Mart drafting works; the remaining work is ongoing.
This is a major step toward making legacy modernization more traceable, testable, and grounded in how enterprise systems actually behave.
EKOS: Enterprise knowledge, compiled into engineering evidence.
#EKOS #DataEngineering #Lakehouse #OpenSource4o @Oracle @OracleCloud @googlecloud @thatjeffsmith @SQLServer @Dell @IBM