Geek Answers Handbook

Pentaho data integration - MySQL database connects to SSH

I am trying to connect to a remote MySQL database using Pentaho Data Integration (JDBC Driver). Therefore, I need to create an SSH connection.

Is it possible to do this inside / using the tool?

Guess I solved this:

I just needed to create SSH Port Forwarding:

ssh -L 3306:localhost:3306 remote.url
+4
source share
1 answer

There is no way to do this that I know about in the PDI. But you would not want that. I would take an approach to configure your MySQL client to use an encrypted connection, and then connect the JDBC driver to it.

Sorry, I do not do MySQL, so I do not know how to do it from my head.

Brian

0
source

More articles:


All Articles