kettle定时同步oracle2mysql

1首先要在kettl的安装目录下放入驱动包

例如：D:\software\Kettle\pdi-ce-7.1.0.0-12\pdi-ce-7.1.0.0-12\data-integration\lib

mysql-connector-java-5.1.37.jar

ojdbc6-11.2.0.1.0.jar

mongo-java-driver-3.2.2.jar

2数据源链接最好写成配置文件

配置文件路径：C:\Users\Administrator\.kettle\kettle.properties 内容如下：

# This file was generated by Pentaho Data Integration version 7.1.0.0-12.
# 
# Here are a few examples of variables to set: 
#
# PRODUCTION_SERVER = hercules
# TEST_SERVER = zeus
# DEVELOPMENT_SERVER = thor
#
# Note: lines like these with a # in front of it are comments
#

#jvm启动参数
#PENTAHO_DI_JAVA_OPTIONS = -Xms2048m -Xmx4096m -XX:MaxPermSize=256m

#每次转换条数
PRE_CONV_NUM = 1000

#GS mongo服务器
GS_MONGO_ADDRESS = 127.0.0.1
GS_MONGO_PORT = 27017
GS_MONGO_DATABASE = dzswjdbtar
GS_MONGO_SCRAM = SCRAM-SHA-1
GS_MONGO_USERNAME = dzswjdbtar
GS_MONGO_PASSWORD = 123456

#DS mongo服务器
DS_MONGO_ADDRESS = 127.0.0.1
DS_MONGO_PORT = 27017
DS_MONGO_DATABASE = dzswjdb
DS_MONGO_SCRAM = SCRAM-SHA-1
DS_MONGO_USERNAME = dzswjdb
DS_MONGO_PASSWORD = 123456

#GS mysql服务器
GS_MYSQL_ADDRESS = 127.0.0.1
GS_MYSQL_PORT = 3306
GS_MYSQL_DATABASE_LHYWZX = lhywzx
GS_MYSQL_DATABASE_YHZX = yhzx
GS_MYSQL_DATABASE_TEST = test
GS_MYSQL_USERNAME = root
GS_MYSQL_PASSWORD = 123456

#DS mysql服务器
DS_MYSQL_ADDRESS = 127.0.0.1
DS_MYSQL_PORT = 3306
DS_MYSQL_DATABASE_LHYWZX = lhywzx
DS_MYSQL_DATABASE_YHZX = yhzx
DS_MYSQL_DATABASE_TEST = test
DS_MYSQL_USERNAME = root
DS_MYSQL_PASSWORD = 123456

修改配置后需要重启kettle生效

正式书写同步脚本：

kettle定时同步oracle2mysql