DTBuild provides database access via ODBC, "Open Database Connectivity". Database fields are treated as destinations, to which data can be sent or appended. Sending data to a database field is not sufficient to update the database, however: the "Output table row" action must be used to add a new table row after all the DTBuild table field destinations for that row have been filled.
DTBuild also allows execution of SQL statements, which must be defined as variables. Building the SQL in a variable (using the "Clear variable", "Append to" and "Send to" actions) allows placement of input stream values and other run-time data within the SQL statement.
Note: It is recommended that table fields be configured in the DBMS to allow null values. The "Output table row" action may fail if a database field within DTBuild is empty and the corresponding database field doesn't allow null values.
Note also that DTBuild uses ODBC as its database interface, so the DBMS of choice must provide a suitable ODBC driver in order to work in conjunction with DTBuild.
Visit dtutilities.com/database.html for more information.