独立开发与工具 Stack Exchange · 2026-08-21

子公司要把集团库里属于自己的那部分搬回本地，旧 ETL 软件已到生命末期

A subsidiary needs to move its slice of the parent's ODBC database on-prem, but the old ETL software is end-of-life

30 秒速览

谁在提Stack Exchange · 2026-08-21 · 2 评
想要什么子公司要把集团库里属于自己的那部分搬回本地，旧 ETL 软件已到生命末期
能做成什么面向中小企业的轻量 ODBC/SQL 增量同步 ETL：『把母公司库里的子集定期搬到自己服务器』开箱即用，按实例或数据量收费。

原帖原话

“We are a subsidiary and copy via ODBC part of a big database from our parent company onto our own servers. The old software we are using is at the end of its life-cycle; it was never the best and we built a lot of workarounds within and around it.”

“我们是子公司，通过 ODBC 把集团大数据库里属于我们的部分复制到自己服务器上加工。旧软件已到生命末期，从来不算好用，我们围绕它做了大量 workaround。现在想为未来做打算。”
— Stack Exchange · 2026-08-21 · softwarerecs.stackexchange.com/questions/95538/etl-s…

需求背景与痛点

痛在哪

数据搬运链路靠一堆 workaround 撑着，软件停维在即，换系统既要兼容老 ODBC 源又不能中断日常报表。

可以做成什么

能做成什么

面向中小企业的轻量 ODBC/SQL 增量同步 ETL：『把母公司库里的子集定期搬到自己服务器』开箱即用，按实例或数据量收费。

怎么验证它

读完原帖的评论区，把重复出现的具体场景记下来——重复次数就是需求的密度。
搜索「ETL / 数据同步」相关的现有工具，确认它们只覆盖了哪一环。
用一句话落地页，投回 Stack Exchange 或同类社群，看有没有人主动问价格。

已有方案与差异

Talend、Airbyte、SSIS（对非技术子公司偏重）

社区原声 · 热门评论

Pentaho can do that. You set up your workflow (read from ODBC, write to your database, perform ETL transformations, etc) then define how often you want it to run, for instance monthly. Commercial support is available.

— Nicolas Raoul · ▲ 1

You can use Debezium with commercial support from Red Hat LLC. https://access.redhat.com/articles/4938181 https://debezium.io It can replicate your database at every change, rather than once per month. After you set it up, you don't have to run it manually, it is all automatic. "Consolidation" is subjective so I suggest doing that in a different stage.

— Nicolas Raoul · ▲ 0

打开原帖核对

同一痛点的其他讨论

开发者工具与基础设施 (7)