欢迎大家赞助一杯啤酒🍺 我们准备了下酒菜：Formal mathematics/Isabelle/ML, Formal verification/Coq/Agda, C++/Erlang/Lisp
Kettle
来自开放百科 - 灰狐
（版本间的差异）
小 (→Used for) |
小 |
||
| 第5行： | 第5行： | ||
License: GNU General Public License (GPL) | License: GNU General Public License (GPL) | ||
| − | |||
==组成== | ==组成== | ||
Pentaho Data Integration (Kettle) 包含以下工具： | Pentaho Data Integration (Kettle) 包含以下工具： | ||
| 第13行： | 第12行： | ||
*Carte：一个在远程主机运行任务和转换的轻量级服务器 | *Carte：一个在远程主机运行任务和转换的轻量级服务器 | ||
| − | == | + | ==用处== |
* Data warehouse population with built-in support for slowly changing dimensions, junk dimensions and much, much more. | * 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 | * Export of database(s) to text-file(s) or other databases | ||
| 第23行： | 第22行： | ||
* Application integration | * Application integration | ||
| − | == | + | ==仓库== |
MySQL | MySQL | ||
create database kettle; | create database kettle; | ||
| 第31行： | 第30行： | ||
[[Kettle Repository DDL]] | [[Kettle Repository DDL]] | ||
| − | == | + | |
| + | ==集群== | ||
./carte.sh 127.0.0.1 8080 | ./carte.sh 127.0.0.1 8080 | ||
http://127.0.0.1:8080 | http://127.0.0.1:8080 | ||
cluster/cluster | cluster/cluster | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | == | + | ==图集== |
<gallery widths=100px heights=100px perrow=6> | <gallery widths=100px heights=100px perrow=6> | ||
Image:kettle-repository.png|Kettle Repository | Image:kettle-repository.png|Kettle Repository | ||
| 第54行： | 第50行： | ||
</gallery> | </gallery> | ||
| − | {{ | + | ==链接== |
| + | *http://kettle.pentaho.org/ | ||
| + | *http://docs.huihoo.com/kettle/ | ||
| + | *http://download.huihoo.com/kettle/ | ||
| + | |||
| + | {{comment}} | ||
[[category:ETL]] | [[category:ETL]] | ||
2013年2月2日 (六) 13:46的版本
Kettle is a powerful, open source, metadata-driven ETL tool
Pentaho Data Integration (ETL, EII - jobs & transformations)
License: GNU General Public License (GPL)
目录 |
组成
Pentaho Data Integration (Kettle) 包含以下工具：
- Spoon：一个创建转换和任务的图形化IDE
- Kitchen：一个运行任务的命令行工具
- Pan：一个运行转换的命令行工具
- Carte：一个在远程主机运行任务和转换的轻量级服务器
用处
- 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
图集
Kettle Repository
设计转换
设计任务
日志
欢迎页
验证转换
调试转换
链接
<discussion>characters_max=300</discussion>
分享您的观点
