tRedshiftOutput using tRedshiftConnection not working?

Six Stars

tRedshiftOutput using tRedshiftConnection not working?

I have successfully used a tMysqlConnection component ("Use existing connection") with a tMySQLInput component to read from a source database, but I now need to write to a Redshift database, and the tRedshiftOutput component does not seem to create any rows in there while it is set to use the existing connection from the tRedshiftOutput component.


Accepted Solutions
Thirteen Stars

Re: tRedshiftOutput using tRedshiftConnection not working?

most realistic reason for this - forgotten "auto-commit" check-box in connection properties

Screen Shot 2017-05-09 at 9.42.33 AM.png

 

if You do not want use auto-commit, You could use tRedshiftCommit component at the end of Job

-----------

All Replies
Thirteen Stars

Re: tRedshiftOutput using tRedshiftConnection not working?

most realistic reason for this - forgotten "auto-commit" check-box in connection properties

Screen Shot 2017-05-09 at 9.42.33 AM.png

 

if You do not want use auto-commit, You could use tRedshiftCommit component at the end of Job

-----------
Six Stars

Re: tRedshiftOutput using tRedshiftConnection not working?

That is exactly what it was, thank you very much!