Issue connecting to redshift from tredshiftconnection component

Highlighted
One Star

Issue connecting to redshift from tredshiftconnection component

I am trying to load data into one of the table in redshift.So i have created a metadata connection for the db. It connected successfully.
Attaching the screenshot below for reference.
 
conn_connection_from_metadata_masked.JPG
 
After the successful connection in metadata, I have extracted the same connection into job and tried testing connection. The connection was established and disconnected immediately with below error message
 
"DriverManager.getConnection
("jdbc:redshift://XXXXXXXX.redshift.amazonaws.com:5439/YYY?loglevel=1") trying com.amazon.redshift.jdbc.Driver
getConnection returning com.amazon.redshift.jdbc.Driver "
 
Attaching screenshot below for the reference 
 
issue.JPG
Could
Tags (1)
Community Manager

Re: Issue connecting to redshift from tredshiftconnection component

can you upload a screenshot of basic settings of tRedshiftConnection component?
----------------------------------------------------------
Talend | Data Agility for Modern Business

2019 GARTNER 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

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Downloads and Trials

Test drive Talend's enterprise products.

Downloads