Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
GarethPenrose
Contributor
Contributor

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.

Labels (2)
1 Solution

Accepted Solutions
vapukov
Master II
Master II

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

0683p000009Lu6K.png

 

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

View solution in original post

2 Replies
vapukov
Master II
Master II

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

0683p000009Lu6K.png

 

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

GarethPenrose
Contributor
Contributor
Author

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