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.....
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
