Acts on the actual DB structure or on the data (although without handling data).
tMSSqlRow executes the SQL query stated onto the specified Microsoft SQL Server or Azure SQL database, depending on the nature of the query and the database. The row suffix means the component implements a flow in the Job design although it doesn't provide output.
The SQLBuilder tool helps you write easily your SQL statements.
For more technologies supported by Talend, see Talend components.