Acts on the actual DB structure or on the data (although without handling data).
tVectorWiseRow is the specific component for this database query. It executes the SQL query stated in the specified 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 your SQL statements easily.
For more technologies supported by Talend, see Talend components.