Pentaho

If you are on linux there are a lot of options. If you want to do all of this through Spoon itself, you could create a KJB (Job) to execute a script which would hand off the tunnel creation to the OS layer you are using. Then your KTRs when they initialize will simply find the database connection waiting for them. Just remember that the URL has to hit localhost:whatever port forward you choose. The functionality for tunneling is not built into the default concept of connections in PDI.

Thanks. Needed this for Windows, though the options are more limited, then basically did the same solution: the scheduling is done via Task Scheduler, this then calls a Powershell script that checks if the tunnel is up, if not then creates the tunnel and calls the actual PDI job that does the load. Would be great to have the tunneling as part of connections.