topic Redshift connection in Talend Integration Cloud in Talend Studio

Redshift connection in Talend Integration Cloud

bradsheridan — Sat, 16 Nov 2024 07:18:42 GMT

hey there Community! Got a simple one for you (hopefully!)

In TIC version 7, I need to create a Connection to Redshift. So I in Integration Cloud > Management > Connections, I click on "Add Connection" and choose Redshift. My question is what should be the format of for the 'Host'??

Should it just be: <nameofclusterhere>.us-east-1.redshift.amazonaws.com ???

Or does it need to be something like: jdbc://<nameofclusterhere>.us-east-1.redshift.amazonaws.com ???

I'm trying to run my published Flow (using a Cloud Engine) and am getting:

....java.sql.SQLNonTransientConnectionException: [Amazon][JDBC](10100) Connection Refused: [Amazon][JDBC](11640) Required Connection Key(s): PWD; [Amazon][JDBC](11480) Optional Connection Key(s): AuthMech, BlockingRowsMode, DisableIsValidQuery, DriverLogLevel, FilterLevel, Language, loginTimeout, OpenSourceSubProtocolOverride, socketTimeout, ssl, sslcert, sslfactory, sslkey, sslpassword, sslrootcert, tcpKeepAlive, TCPKeepAliveMinutes, unknownLength at com.amazon.exceptions.ExceptionConverter.toSQLException(Unknown Source) at com.amazon.jdbc.common.BaseConnectionFactory.checkResponseMap(Unknown Source) at com.amazon.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source) at com.amazon.jdbc.common.AbstractDriver.connect(Unknown Source) at java.sql.DriverManager.getConne.....

thanks in advance!

Brad

Re: Redshift connection in Talend Integration Cloud

Anonymous — Fri, 23 Nov 2018 06:58:21 GMT

Hello,

Are you referring to online user guide about: TalendHelpCenter:Managing Connections?

Best regards

Sabrina

Re: Redshift connection in Talend Integration Cloud

bradsheridan — Sat, 24 Nov 2018 18:19:09 GMT

Hi Sabrina and thanks for the link. It's not quite exactly that particular link...I had found one for Talend documentation that is specifically about setting up a Redshift connection. However, that didn't help either.

What we did that was successful was create a 'custom connection' and for the parameter 'host', we used: <nameofclusterhere>.us-east-1.redshift.amazonaws.com

In other words, we left off "jdbc://" in the beginning

thanks!