AWS Redshift JDBC driver

Highlighted
Seven Stars

AWS Redshift JDBC driver

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

 

Moderator

Re: AWS Redshift JDBC driver

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: AWS Redshift JDBC driver

Also need to know how does one update the Redshift jdbc jar version from Designer? 

Employee

Re: AWS Redshift JDBC driver

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"

 

 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

An API-First Approach to Modernizing Applications

Learn how to use an API-First Approach to Modernize your Applications

Watch Now

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog

Talend Studio Improvements for API Services

Take a look at the Talend Studio improvements for API Services

Watch Now