Basic dependence
Lijie open source project on Git
Gitee.com/lijie520241…
Sqlite database, installation tutorial link
www.runoob.com/sqlite/sqli…
Apache-tomcat, installation tutorial link
Blog.csdn.net/u012964753/… www.cnblogs.com/lpgit/p/109… Wait, there are lots of detailed tutorials online
KETTLE, installation tutorial link
www.jianshu.com/p/c76bac247… The resource library connection is changed to Sqlite, the configuration will be given below the article or you can search online
Configuring a Resource Library
The Sqlite database needs to be pre-built, as shown in figure flu.db
Host name:? JDBC :sqlite:D:\flu\sqlite\flu.db Database name :D:\flu\sqlite\flu.db port number: -1
Port number -1 can be used for successful connection
After the configuration is complete, the Kettle conversion or job can be saved to the configured resource library
Create a scheduling resource library
SQL in the Kettle – Scheduler project to create a version of Sqlite, create the table structure in an Sqlite database independent of the Kettle resource library, and modify the configuration file under the project. Under the WEB – INF \ classes \ resource
db.properties
#jdbc.driver=com.mysql.cj.jdbc.Driver #jdbc.url=jdbc:mysql://localhost:3306/km? serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false #jdbc.username=root #jdbc.password=root jdbc.driver=org.sqlite.JDBC jdbc.url=jdbc:sqlite://d:/flu/sqlite/km.db jdbc.username= jdbc.password=Copy the codekettle.properties
# Kettle Properties # Kettle Properties Used to initialize the kettle environment variables (the kettle/kettle. The properties in the path), pointing to the kettle root directory (for example, D: \ data - integration) Kettle. Home =D:\\flu\ pdi-ce-8.3.0.0-371\\data-integration # Absolute path to kettle under plugins file Kettle. plugin=D:\\flu\ pdi-ce-8.3.0.0-371\\data-integration\\plugins # Kettle. script=Html\ js\ libs\ url # kettle.loglevel=basic # kettle.loglevel=basic # kettle.loglevel=basic # kettle.loglevel=basic Kettle.log.file. path=D:\\flu\\ kettley-schedule \\logs # Save the path of uploaded file conversion (.ktr) or job (.kjb) kettle.file.repository=D:\\data-integration\\testCopy the code