自动化 ETL/数据库迁移解决方案
我正在寻找一个 ETL 解决方案，我们可以手动创建配置，然后部署以自主运行。这是基本的转换，不需要有太多的功能。关键点是可以根据特定需求进行更多定制的免费或开源软件。
事实上，这可以简化为一个在 Linux 服务器上运行的简单数据库迁移工具。本质上与上面相同，但除了重命名列之外，我们可能根本不需要验证/转换数据。
我忘了提及，这必须是非常跨平台的。我希望能够将其部署到服务器，并在 OSX 和 Windows 上测试它。
I'm looking for an ETL solution that we can create a configure by hand and then deploy to run autonomously. This is basic transformation, it need not be feature heavy. Key points would be free or open source'ed software that could be tailored more to suit specific needs.
In fact, this could be reduced to a simple DB migration tool that will run on a Linux server. Essentially the same as the above but we probably won't need to validate / transform the data at all besides renaming columns.
I forgot to mention that this is going to have to be very cross platform. I'd like to be able to deploy it to a server, as well as test it on OSX and Windows.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
尝试 Pentaho 或 Talend。 Pentaho 有一个很好的作业调度范例以及 ETL 工作台 (Kettle)。我没有使用过 Talend，但我听说过一些好消息，我想它也具有类似的功能。
Try Pentaho or Talend. Pentaho has a nice job-scheduling paradigm as well as the ETL workbench (Kettle). I haven't used Talend, but I've heard good things and I imagine it carries similar functionality.