Difference between Tibco JDBC update and SQL direct

1. The SQL Direct activity executes a SQL statement that you provide. This activity allows you to build a SQL statement dynamically (using other activities), then pass the SQL statement into this activity’s input. This activity also allows you to execute SQL statements that are not supported by other activities in the JDBC palette. For example, DDL commands (for example, CREATE TABLE) are not available using any other activity.

2. JDBC Query-JDBC Update activities & implement writing the SQL which uses prepared statements where as SQL Direct enables you to write sql statements on the fly; So this is the most flexible way

3. JDBC Update / Query are specialized activities but they are by far more user-friendly (input / output constructed by the parametes / query). The output is already parsed and use-able. SQL Direct activity is the low level activity. It can do almost everything. But it's really not user-friendly.