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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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!