Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello everyone
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 1.2.1.1006 used).
I have a Jar file JDBC 4.2 version 1.2.8.1005.
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.
Thank you
Hello,
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.
Best regards
Sabrina
Also need to know how does one update the Redshift jdbc jar version from Designer?
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.
Example:
Talend\7.1.1\studio\plugins\org.talend.designer.components.localprovider_7.1.1.20181026_1147\components\tRedshiftConnection\tRedshiftConnection_java.xml
<IMPORT NAME="Driver-Redshift" MODULE="redshiftJDBC42-no-awssdk-1.2.16.1027.jar"