topic Issue connecting to redshift from tredshiftconnection component in Talend Studio https://community.qlik.com/t5/Talend-Studio/Issue-connecting-to-redshift-from-tredshiftconnection-component/m-p/2212166#M9899 <DIV> I am trying&nbsp;to load data into one of the table in redshift.So i have created a metadata connection for the db. It connected successfully. </DIV> <DIV> Attaching the screenshot below for reference. </DIV> <DIV> &nbsp; </DIV> <DIV> <SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="conn_connection_from_metadata_masked.JPG" style="width: 781px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M97E.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136094i468972AF3350CF99/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M97E.jpg" alt="0683p000009M97E.jpg" /></span></SPAN> </DIV> <DIV> &nbsp; </DIV> <DIV> 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 </DIV> <DIV> &nbsp; </DIV> <DIV> <STRONG>"DriverManager.getConnection</STRONG> </DIV> <DIV> <STRONG>("jdbc:redshift://XXXXXXXX.redshift.amazonaws.com:5439/YYY?loglevel=1")&nbsp;</STRONG> <STRONG>trying com.amazon.redshift.jdbc.Driver</STRONG> </DIV> <DIV> <STRONG>getConnection returning com.amazon.redshift.jdbc.Driver "</STRONG> </DIV> <DIV> <STRONG>&nbsp;</STRONG> </DIV> <DIV> Attaching screenshot below for the reference&nbsp; </DIV> <DIV> &nbsp; </DIV> <DIV> <SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="issue.JPG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M98G.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136296iC29B04C3A99981EE/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M98G.jpg" alt="0683p000009M98G.jpg" /></span></SPAN> </DIV> <DIV> Could </DIV> Sat, 16 Nov 2024 03:11:28 GMT Prateekk 2024-11-16T03:11:28Z Issue connecting to redshift from tredshiftconnection component https://community.qlik.com/t5/Talend-Studio/Issue-connecting-to-redshift-from-tredshiftconnection-component/m-p/2212166#M9899 <DIV> I am trying&nbsp;to load data into one of the table in redshift.So i have created a metadata connection for the db. It connected successfully. </DIV> <DIV> Attaching the screenshot below for reference. </DIV> <DIV> &nbsp; </DIV> <DIV> <SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="conn_connection_from_metadata_masked.JPG" style="width: 781px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M97E.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136094i468972AF3350CF99/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M97E.jpg" alt="0683p000009M97E.jpg" /></span></SPAN> </DIV> <DIV> &nbsp; </DIV> <DIV> 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 </DIV> <DIV> &nbsp; </DIV> <DIV> <STRONG>"DriverManager.getConnection</STRONG> </DIV> <DIV> <STRONG>("jdbc:redshift://XXXXXXXX.redshift.amazonaws.com:5439/YYY?loglevel=1")&nbsp;</STRONG> <STRONG>trying com.amazon.redshift.jdbc.Driver</STRONG> </DIV> <DIV> <STRONG>getConnection returning com.amazon.redshift.jdbc.Driver "</STRONG> </DIV> <DIV> <STRONG>&nbsp;</STRONG> </DIV> <DIV> Attaching screenshot below for the reference&nbsp; </DIV> <DIV> &nbsp; </DIV> <DIV> <SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="issue.JPG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M98G.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/136296iC29B04C3A99981EE/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M98G.jpg" alt="0683p000009M98G.jpg" /></span></SPAN> </DIV> <DIV> Could </DIV> Sat, 16 Nov 2024 03:11:28 GMT https://community.qlik.com/t5/Talend-Studio/Issue-connecting-to-redshift-from-tredshiftconnection-component/m-p/2212166#M9899 Prateekk 2024-11-16T03:11:28Z Re: Issue connecting to redshift from tredshiftconnection component https://community.qlik.com/t5/Talend-Studio/Issue-connecting-to-redshift-from-tredshiftconnection-component/m-p/2212167#M9900 can you upload a screenshot of basic settings of tRedshiftConnection component?<BR /> Wed, 26 Feb 2020 08:33:56 GMT https://community.qlik.com/t5/Talend-Studio/Issue-connecting-to-redshift-from-tredshiftconnection-component/m-p/2212167#M9900 Anonymous 2020-02-26T08:33:56Z