Kettle

2010年8月20日 (五) 12:09的版本

Kettle is a powerful, open source, metadata-driven ETL tool

Pentaho Data Integration (ETL, EII - jobs & transformations)

License: GNU General Public License (GPL)

最新版: 3.2.0

Data warehouse population with built-in support for slowly changing dimensions, junk dimensions and much, much more.
Export of database(s) to text-file(s) or other databases
Import of data into databases, ranging from text-files to excel sheets
Data migration between database applications
Exploration of data in existing databases. (tables, views, synonyms, )
Information enrichment by looking up data in various information stores (databases, text-files, excel sheets, )
Data cleaning by applying complex conditions in data transformations
Application integration

MySQL

create database kettle;

然后通过资源库的创建向导完成数据库的创建，会新建41个表 (3.0.1版本)，然后每次启动登录资源库

admin/admin

可把整个资源库导出: repositories.xml, 也可把资源库从xml导入

./carte.sh 127.0.0.1 8080
http://127.0.0.1:8080
cluster/cluster

@@ 第16行： / 第16行： @@
 * Application integration
 ==Repository==
-[[Image:kettle-repository.png|thumb|right|Kettle Repository]]
 MySQL
   create database kettle;
@@ 第34行： / 第33行： @@
 ==Screenshots==
-[[Image:kettle-01.png|thumb|left]] [[Image:kettle-02.png|thumb|left]] [[Image:kettle-03.png|thumb|left]]
+<gallery perrow=6>
+Image:kettle-repository.png|Kettle Repository
+Image:kettle-01.png
+Image:kettle-02.png
+Image:kettle-03.png
+</gallery>
+[[Category:BI]]