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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
NNot_defined1665392384
Contributor II
Contributor II

Difference between tSQLtemplate and TDBRow

I recently learned about the tSQLtemplate component and the first use case that came to my mind was a "DELETE FROM TABLE" query, since we used to delete by extracting the key from a tDBInput und put it into a tDBOutput - Delete component. Hence I figued that this is a good application for a tSQLtemplate, where I can execute the code directly on the database.

However, at this point I was unaware of the TDBRow component, which accomplishes the sames task. Hence, my question is, what problem / use case does the tSQLtemplate solve, which can not be accomplished by a tDBRow component?

Labels (4)
1 Reply
Anonymous
Not applicable

Hi

tSQLTemplate performs the SQL statements and data transformations directly within the database engine itself., it is a ELT process.

TDBRow executes SQL statements via JDBC, it is a standard ETL process.

You can find the difference between ETL vs ELT in this page.

 

Regards

Shong