Kettle报表自动化
来自我们牛逼哄哄的东哥的笔记
1.
![](https://images2015.cnblogs.com/blog/1025061/201702/1025061-20170216103142722-721212192.png)
2.
![](https://images2015.cnblogs.com/blog/1025061/201702/1025061-20170216103154207-1062016456.png)
3.
![](https://images2015.cnblogs.com/blog/1025061/201702/1025061-20170216103202472-900044689.png)
- 选择数据库链接
- 贴报表SQL
4.
![](https://images2015.cnblogs.com/blog/1025061/201702/1025061-20170216103209691-403701427.png)
- 文件名:选择路径,excel文件由kettle自动创建,自己只需输入创建文件的名称。
- 拓展名:后缀写上
5.
![](https://images2015.cnblogs.com/blog/1025061/201702/1025061-20170216103218144-1568405788.png)
此为sheet页名称
6.
![](https://images2015.cnblogs.com/blog/1025061/201702/1025061-20170216103225754-2065837606.png)
根据自己的情况选择不同excel格式
7.
![](https://images2015.cnblogs.com/blog/1025061/201702/1025061-20170216103232222-1088476997.png)
8.
![](https://images2015.cnblogs.com/blog/1025061/201702/1025061-20170216103243597-1012231727.png)
邮件发送分为job和ktr里两种组件,只有转换里的邮件组件才能发送附件。
9.
![](https://images2015.cnblogs.com/blog/1025061/201702/1025061-20170216103251660-205714344.png)
定义常量数据,这些常量在后面会用到
10.
![](https://images2015.cnblogs.com/blog/1025061/201702/1025061-20170216103257035-1483318179.png)
文件里的系统变量properties
11.
![](https://images2015.cnblogs.com/blog/1025061/201702/1025061-20170216103303113-827977047.png)
把相应的变量,常量给选上。
12
![](https://images2015.cnblogs.com/blog/1025061/201702/1025061-20170216103330066-1273750296.png)
OK