https://community.qlik.com/t5/Talend-Studio/tRedshiftOutput-using-tRedshiftConnection-not-working/m-p/2258789#M40484 <P>most realistic reason for this - forgotten "auto-commit" check-box in connection properties</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2017-05-09 at 9.42.33 AM.png" style="width: 363px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lu6K.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153667i3BF0EDCB9FE5503D/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lu6K.png" alt="0683p000009Lu6K.png" /></span></SPAN></P> <P>&nbsp;</P> <P>if You do not want use auto-commit, You could use tRedshiftCommit component at the end of Job</P> Mon, 08 May 2017 22:44:41 GMT vapukov 2017-05-08T22:44:41Z https://community.qlik.com/t5/Talend-Studio/tRedshiftOutput-using-tRedshiftConnection-not-working/m-p/2258788#M40483 <P>I have successfully used a <EM>tMysqlConnection</EM> component ("Use existing connection") with a <EM>tMySQLInput</EM> component to read from a source database, but I now need to write to a Redshift database, and the <EM>tRedshiftOutput</EM> component <STRONG>does not seem to create any rows</STRONG> in there while it is set to use the existing connection from the <EM>tRedshiftOutput</EM> component.</P> Mon, 08 May 2017 16:36:25 GMT https://community.qlik.com/t5/Talend-Studio/tRedshiftOutput-using-tRedshiftConnection-not-working/m-p/2258788#M40483 GarethPenrose 2017-05-08T16:36:25Z https://community.qlik.com/t5/Talend-Studio/tRedshiftOutput-using-tRedshiftConnection-not-working/m-p/2258789#M40484 <P>most realistic reason for this - forgotten "auto-commit" check-box in connection properties</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2017-05-09 at 9.42.33 AM.png" style="width: 363px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lu6K.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153667i3BF0EDCB9FE5503D/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lu6K.png" alt="0683p000009Lu6K.png" /></span></SPAN></P> <P>&nbsp;</P> <P>if You do not want use auto-commit, You could use tRedshiftCommit component at the end of Job</P> Mon, 08 May 2017 22:44:41 GMT https://community.qlik.com/t5/Talend-Studio/tRedshiftOutput-using-tRedshiftConnection-not-working/m-p/2258789#M40484 vapukov 2017-05-08T22:44:41Z https://community.qlik.com/t5/Talend-Studio/tRedshiftOutput-using-tRedshiftConnection-not-working/m-p/2258790#M40485 <P>That is exactly what it was, thank you very much!</P> Tue, 09 May 2017 09:10:40 GMT https://community.qlik.com/t5/Talend-Studio/tRedshiftOutput-using-tRedshiftConnection-not-working/m-p/2258790#M40485 GarethPenrose 2017-05-09T09:10:40Z