技术资料，【Kette3.0 用户手册】
©深圳市神盾信息技术有限公司，2008 第 1 页/共 202 页
Kettle 3.0 用户手册
目录
Kettle 3.0 用户手册 ...................................................................................................................... 1
Kettle 3.0 用户手册 ...................................................................................................................... 6
1. Kettle 介绍 ................................................................................................................................ 6
1.1 什么是 kettle ............................................................................................................. 6
1.2 Kettle 的安装 ............................................................................................................ 6
1.3 运行 Spoon ............................................................................................................... 6
1.4 资源库 ....................................................................................................................... 6
1.5 资源库自动登录 ....................................................................................................... 7
1.6 定义 ........................................................................................................................... 8
1.6.1 转换 ................................................................................................................... 8
1.6.2 任务 ................................................................................................................... 8
1.7 选项 ........................................................................................................................... 9
1.7.1 General 标签 ................................................................................................... 10
1.7.2 Look Feel 标签 ............................................................................................... 11
1.8 搜索元数据 ............................................................................................................. 12
1.9 设置环境变量 ......................................................................................................... 13
2. 创建一个转换或任务 ............................................................................................................. 13
3. 数据库连接(Database Connections) ...................................................................................... 14
3.1 描述 ......................................................................................................................... 14
3.2 设置窗口 ................................................................................................................. 14
3.3 选项 ......................................................................................................................... 14
3.4 数据库用法 ............................................................................................................. 15
4. SQL 编辑器(SQL Editor) ....................................................................................................... 16
4.1 描述 ......................................................................................................................... 16
4.2 屏幕截图 ................................................................................................................. 16
4.3 局限性 ..................................................................................................................... 16
5. 数据库浏览器(Database Explorer) ........................................................................................ 17
5.1 屏幕截图 ................................................................................................................. 17
5.2 描述 ......................................................................................................................... 17
6. 节点连接（Hops） ................................................................................................................ 18
6.1 描述 ......................................................................................................................... 18
6.2 转换连接 ................................................................................................................. 18
6.3 任务连接 ................................................................................................................. 18
6.4 屏幕截图 ................................................................................................................. 18
6.5 创建一个连接 ......................................................................................................... 19
6.6 拆分一个连接 ......................................................................................................... 19
6.7 转换连接颜色 ......................................................................................................... 19
7. 变量（Va ria ble s） .................................................................................................................. 20
