Profile

UPDATE 2   I now also tested using the default connection type of MySQL -> Native (JDBC) instead of a Generic database specification.   The results are identical. Driver 5.1.49 with PDI 9.0 connecting to MySQL 8.0.20 appears not to retrieve field names.   Any help appreciated as having to revert to old ...

UPDATE 1   I have just tried using a Generic database -> Native (JDBC) connection with the 5.1.49 driver and changing the Custom driver class name to the old org.gjt.mm.mysql.Driver.   Testing this in 9.0, it connects OK (no sha2_caching_password issues) , however, the Table Input still retrieves the ...

Hi Sergio,Yes, 100%. As it is via the Generic database -> Native (JDBC) database connection, 8.0.x drivers have worked perfectly in Pentaho 8.x for me to date. You just set the Custom driver class name to 'com.mysql.cj.jdbc.Driver'. This is a valid database connection setup.I do appreciate that to use ...

Hi,   There appears to be an issue with the Table Loader in PDI 9.0 as follows. It is very easy to repeat and the same test/transformation works perfectly in PDI 8.2 with identical configuration. Any help appreciated.   The problem/example:   In a new transformation, I add just a Table Input node and ...

Quick update for anyone reading.   I must apologise because after additional testing it was the Ubuntu UI theme that was causing the issues I saw.   It turns out that PDI 9.0 can work reasonably (if you are just using Spoon and Carte) without libwebkitgtk-1.0-0. The only noticable difference is that ...

Thanks Tatu. Really appreciate the help.I will update my post accordingly.Regards,Iain

Hi,   The dependency libwebkitgtk-1.0-0 for PDI (spoon in particular) is simply not available for the latest stable and long-term support version of Ubuntu (20.04 - Focal Fossa). Unfortunately, I think this appears to have the effect of making some of the UI components not visible (See attached).   I ...