kettle数据库连接使用变量

 

 

1. 在数据库连接页面配置参数

2. 修改C:\Users\gous003\.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
#
mysql_HOST=
mysql_PORT=
mysql_DB=
mysql_USERNAME=
mysql_PASSWORD=

MSSQL_HOST=
MSSQL_PORT=
MSSQL_DB=
MSSQL_USERNAME=
MSSQL_PASSWORD=