Kettle

来自开放百科 - 灰狐
(版本间的差异)
跳转到: 导航, 搜索
(Screenshots)
第38行: 第38行:
 
Image:kettle-02.png
 
Image:kettle-02.png
 
Image:kettle-03.png
 
Image:kettle-03.png
 +
Image:spoon-transformation.png|设计转换
 +
Image:spoon-job.png|设计任务
 +
Image:spoon-logview.png|日志
 +
Image:spoon-welcome.png|欢迎页
 +
Imaeg:spoon-verify.png|验证转换
 +
Image:spoon-debug.png|调试转换
 
</gallery>
 
</gallery>
 +
 +
{{Comment}}
  
 
[[Category:ETL]]
 
[[Category:ETL]]

2010年10月6日 (三) 14:40的版本

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

目录

Used for

  • 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

Repository

MySQL

create database kettle;

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

admin/admin 

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

Kettle Repository DDL

Kettle slave server

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

Links

Screenshots

Comment-32x32.png

<discussion>characters_max=300</discussion>

分享您的观点
个人工具
名字空间

变换
操作
导航
工具箱