开源ETL框架 [英] Open Source ETL framework

问题描述

我被要求对两个ETL框架进行原型设计。要求如下：

I was asked to prototype two ETL frameworks. The requirements are as follows:

• 开源


• 适用于Linux


• 维护


• 可以在网络浏览器上查看日志（很高兴）


• 用Perl，Python，Ruby或Java编写

• Open Source
• Available to Linux
• Maintained
• Logs can be viewed on web browser (nice to have)
• Written in Perl, Python, Ruby or Java

原始文件可以是任何内容（excel，csv，html页面等..）
目标数据库是MySQL。

The raw file can be anything (excel, csv, html page etc..) The target database is MySQL.

请勿删除姓名，请根据您的经验说明优缺点。

Dont just drop names, please indicate the advantages/disadvantages based from your experience.

谢谢！

推荐答案

我用过 Kettle 。它有自己的GUI，但如果您更喜欢使用API​​自己进行ETL，它也会受到支持。它已被证明对我非常有用，并且已经有一些插件已经可用。

I've used Kettle. It has its own GUI, but if you rather use the API to do the ETL yourself it's also supported. It has proved to be very useful to me and there are a few plugins already available for it.

这篇关于开源ETL框架的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！