AWS released new versions of Redshift JDBC driver.
I am using Talend DI and Talend ESB version 6.4.1 which do not use the most recent Redshift JDBC driver (in Modules I see Redshift JDBC 41 22.214.171.1246 used).
I have a Jar file JDBC 4.2 version 126.96.36.1995.
AWS releases JDBC updates on regular basis. The same applies to PostgreSQL JDBC driver, btw, and Oracle and MS-SQL too.
So the question is generic;
Can I have some clear instructions on how to update the Talend 6.4.1 Redshift (and others) JDBC drivers to the latest versions?
I need the instructions for the ordinary DI Jobs and also for jobs invoked via Karaf Routes ESB.
I have found numerous posts on the topic of updating/installing Talend JDBC and found them either wrong (perhaps for earlier versions of Talend Studio?) or at least very confusing.
I am hopeful there is an existing article which apply to Talend 6.4.1 and has clear unambiguous instructions on installing new versions of JDBC drivers.
Thanks for your suggestion. So far, we don't have any documentation or article about ' Update JDBC drivers to the latest versions'. We will make an investigation on it and then come back to you as soon as we can.
There is two ways to override a driver in the Talend software. Just replace the jar file with this new one but keep the old name under the studio\configuration\.m2\repository\org\talend\libraries path. Or just go into the component plugin directory and replace in the .xml files in the <import> section the jar file name.
<IMPORT NAME="Driver-Redshift" MODULE="redshiftJDBC42-no-awssdk-188.8.131.527.jar"
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to use an API-First Approach to Modernize your Applications
Read about some useful Context Variable ideas
Take a look at the Talend Studio improvements for API Services