ETL工具Kettle用户手册

LeeWen2020

1884

202页

29次

2019-10-10

5墨值下载

技术资料，【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 标签 ............................................................................................... 1 1

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 b le s） .................................................................................................................. 20

技术资料，【Kette3.0 用户手册】

©深圳市神盾信息技术有限公司，2008 第 2 页/共 202 页

7.1 变量使用 ................................................................................................................. 20

7.2 变量范围 ................................................................................................................. 20

7.2.1 环境变量 ......................................................................................................... 20

7.2.2 Kettle 变量 ...................................................................................................... 21

7.2.3 内部变量 ......................................................................................................... 21

8. 转换设置（Transformation Settings） .................................................................................. 22

8.1 描述 ......................................................................................................................... 22

8.2 屏幕截图 ................................................................................................................. 22

8.3 选项 ......................................................................................................................... 25

8.4 其它 ......................................................................................................................... 26

9. 转换步骤（Transformation steps） ....................................................................................... 27

9.1 描述 ......................................................................................................................... 27

9.2 运行步骤的多个副本 ............................................................................................. 27

9.3 分发或者复制 ......................................................................................................... 28

9.4 常用错误处理 ......................................................................................................... 29

9.5 Apache 虚拟文件系统（VFS）支持 .................................................................... 31

9.6 转换步骤类型 ......................................................................................................... 33

9.6.1 文本文件输入（Text Input） ........................................................................ 33

9.6.2

 表输入（Table Inpu t ） ................................................................................... 45

9.6.3 获取系统信息（Get System Info） ............................................................... 47

9.6.4 生成行（Generate Rows） ............................................................................ 51

9.6.5 文件反序列化（De-serialize from file）（原来名称为 Cube 输入） .......... 52

9.6.6 XBase 输入（XBase input） ......................................................................... 53

9.6.7 Excel 输入（Excel Input） ............................................................................ 54

9.6.8 XML 输入(XML input) .................................................................................. 58

9.6.9 获取文件名(Get File Names) ......................................................................... 61

9.6.10 文本文件输出(Text File Output) .................................................................... 62

9.6.11 表输出(Table output) ...................................................................................... 65

9.6.12 插入/更新(Insert/Update) ............................................................................... 68

9.6.13 更新（Update） ............................................................................................. 70

9.6.14 删除(Delete) .................................................................................................... 71

9.6.15 序列化到文件(Serialize to file)(以前是 Cube Output) .................................. 72

9.6.16 XML 输出（XML output） ........................................................................... 73

9.6.17 Excel 输出(Excel Output) ............................................................................... 76

9.6.18 Access 输出（Microsoft Access Output） ..................................................... 78

9.6.19 数据库查询(Database lookup) ....................................................................... 80

9.6.20 流查询（Stream lookup） ............................................................................. 81

9.6.21 调用数据库存储过程(Call DB Procedure) .................................................... 83

9.6.22 HTTP 客户端(HTTP Cient) ............................................................................ 84

9.6.23 字段选择 (Select values) ............................................................................... 86

9.6.24 过滤记录(Filter rows) ..................................................................................... 89

9.6.25 排序记录（Sort rows） ................................................................................. 90

9.6.26 添加序列(Add sequence) ................................................................................ 91

9.6.27 空操作-什么都不做(Dummy-do nothing) ..................................................... 93

of 202

5墨值下载

关注

评论