There are really only two ways to do it on a repeated basis. Either you use REST APIs or you find a JDBC driver that will do the heavy lifting for you and let you use SQL against Magento. Where Kettle is missing some data sources, I use the Generic driver setting and use a driver from elsewhere. CData has a decent one. You can also use other cloud services which extract from platforms like this and get the data closer to Kettle.