Kettle版本4.1.0
∙ 打开Spoon软件，windows下面双击Spoon.bat即可。
∙ 创建一个转换。
![](https://wkrtcs.bdimg.com/rtcs/image?w=781.90&md5sum=328e55a0fcd4e05e052e5ee21eeb4e06&sign=980e48f6ea&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=43&ipr={"t":"img","r":"r_3","w":"781.90","h":"423.43","dataType":"jpeg","c":"word/media/image1.jpeg","imgOriW":1348,"imgOriH":730})
∙ 创建两个数据源，一个是oracle的一个是mysql的。
![](https://wkrtcs.bdimg.com/rtcs/image?w=374.00&md5sum=328e55a0fcd4e05e052e5ee21eeb4e06&sign=980e48f6ea&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=43&ipr={"t":"img","r":"r_3","w":"374.00","h":"503.00","dataType":"jpeg","c":"word/media/image2.jpeg","imgOriW":374,"imgOriH":503})
![](https://wkrtcs.bdimg.com/rtcs/image?w=391.00&md5sum=328e55a0fcd4e05e052e5ee21eeb4e06&sign=980e48f6ea&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=43&ipr={"t":"img","r":"r_3","w":"391.00","h":"395.00","dataType":"jpeg","c":"word/media/image3.jpeg","imgOriW":391,"imgOriH":395})
∙ 创建表输入。
![](https://wkrtcs.bdimg.com/rtcs/image?w=1055.00&md5sum=328e55a0fcd4e05e052e5ee21eeb4e06&sign=980e48f6ea&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=43&ipr={"t":"img","r":"r_3","w":"1055.00","h":"637.00","dataType":"jpeg","c":"word/media/image4.jpeg","imgOriW":1055,"imgOriH":637})
∙ 创建字段选择。
![](https://wkrtcs.bdimg.com/rtcs/image?w=1336.00&md5sum=328e55a0fcd4e05e052e5ee21eeb4e06&sign=980e48f6ea&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=43&ipr={"t":"img","r":"r_3","w":"1336.00","h":"636.00","dataType":"jpeg","c":"word/media/image5.jpeg","imgOriW":1336,"imgOriH":636})
∙ 创建表输出，将输入表的value字段映射为输出表的str字段。
注意：如果目标表没有，是新建的，则应该点击SQL按键进行SQL语句创建表。
![](https://wkrtcs.bdimg.com/rtcs/image?w=982.00&md5sum=328e55a0fcd4e05e052e5ee21eeb4e06&sign=980e48f6ea&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=43&ipr={"t":"img","r":"r_3","w":"982.00","h":"696.00","dataType":"jpeg","c":"word/media/image6.jpeg","imgOriW":982,"imgOriH":696})
∙ 将三个步骤连接起来。
![](https://wkrtcs.bdimg.com/rtcs/image?w=745.00&md5sum=328e55a0fcd4e05e052e5ee21eeb4e06&sign=980e48f6ea&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=43&ipr={"t":"img","r":"r_3","w":"745.00","h":"301.00","dataType":"jpeg","c":"word/media/image7.jpeg","imgOriW":745,"imgOriH":301})
∙ 创建一个作业
![](https://wkrtcs.bdimg.com/rtcs/image?w=573.00&md5sum=328e55a0fcd4e05e052e5ee21eeb4e06&sign=980e48f6ea&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=43&ipr={"t":"img","r":"r_3","w":"573.00","h":"431.00","dataType":"jpeg","c":"word/media/image8.jpeg","imgOriW":573,"imgOriH":431})
∙ 创建一个转换
∙
![](https://wkrtcs.bdimg.com/rtcs/image?w=1330.00&md5sum=328e55a0fcd4e05e052e5ee21eeb4e06&sign=980e48f6ea&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=43&ipr={"t":"img","r":"r_3","w":"1330.00","h":"575.00","dataType":"jpeg","c":"word/media/image9.jpeg","imgOriW":1330,"imgOriH":575})
∙ 创建一个定时job
![](https://wkrtcs.bdimg.com/rtcs/image?w=942.00&md5sum=328e55a0fcd4e05e052e5ee21eeb4e06&sign=980e48f6ea&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=43&ipr={"t":"img","r":"r_3","w":"942.00","h":"509.00","dataType":"jpeg","c":"word/media/image10.jpeg","imgOriW":942,"imgOriH":509})
∙ 连接好job和transformation，运行job
![](https://wkrtcs.bdimg.com/rtcs/image?w=871.00&md5sum=328e55a0fcd4e05e052e5ee21eeb4e06&sign=980e48f6ea&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=43&ipr={"t":"img","r":"r_3","w":"871.00","h":"332.00","dataType":"jpeg","c":"word/media/image11.jpeg","imgOriW":871,"imgOriH":332})
本文来源：https://www.2haoxitong.net/k/doc/a7d79251b52acfc789ebc964.html
文档为doc格式