Kettle使用

一 Kettle下载

版本为：7.1.0.0-12

已解决Mysql数据库驱动不匹配问题。驱动包版本为mysql-connector-java-5.1.37-bin.jar。

具体问题：

Couldn't get field info from [select * from user]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version 
for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1

二Kettle输入、输出表数据乱码解决

1. set names utf8;

2. characterEncoding utf8