DemandHunt 海外社區機會雷達
繁中
獨立開發與工具 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:『把母公司庫裡的子集定期搬到自己服務器』開箱即用,按實例或數據量收費。

怎麼驗證它

  1. 讀完原帖的評論區,把重複出現的具體場景記下來——重複次數就是需求的密度。
  2. 搜索「ETL / 數據同步」相關的現有工具,確認它們只覆蓋了哪一環。
  3. 用一句話落地頁,投回 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
打開原帖核對

同一痛點的其他討論

相關機會