Using PDI Kettle to import Google sheets to SQL server DB on schedule

After the former article of connection to Google Spreadsheets, we’re going to import the data “on schedule” and “automatically” now.

https://datamansamxiao.wordpress.com/2019/09/11/using-pentaho-data-integration-pdi-to-connect-google-sheets/

Don’t doubt. It’s totally different topic and function. I’m sure you can’t even get it done in 1 day again. I saved your working day (or even more) in 10 mins. You’re welcome.

Sam

Steps are as below:

1. Create a “Job” (not “transform” as former article)
2. Pull “start” -> “transform” -> “Success”
3. Know the function in PDI- Kitchen.bat
4. Using Kitchen.bat to set your own batch file
5. Testing with proper log
6. Result

1. Create a “Job” (not “transform” as former article)

2. Pull “start” -> “transform” -> “Success”

3. Know the function in PDI- Kitchen.bat

https://forums.pentaho.com/threads/89732-What-is-Kettle(PDI)-and-functional-of-Kettle-about-Spoon-Pan-etc/

4. Using Kitchen.bat to set your own batch file

5. Testing with proper log

6. Result

Please don’t ask me about the task setting in OS. There are plenty of articles of it.

Originally published at http://datamansamxiao.wordpress.com on September 19, 2019.