Apologies if there is an existing thread but I have not been able to find it. We are using PDI 4.4 for a number of transformations running on the same installation. Different transformations use Oracle databases at different version levels and therefore need different drivers.

Experimentally, putting multiple ojdbc#.jar files in libext/JDBC (e.g., ojdbc7.jar and ojdbc14.jar) appears to work. Each transformation somehow runs correctly -- so far. However, without confirmation that this should work, we may be living dangerously. Is PDI designed to work this way? If not, what is the "right" way to handle the situation where one needs to read and write to multiple Oracle versions?

Thank you.