The database

Data Splitter 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 Data Splitter table field destinations for that row have been filled.

Data Splitter 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 Data Splitter is empty and the corresponding database field doesn't allow null values.

Note also that Data Splitter uses ODBC as its database interface, so the DBMS of choice must provide a suitable ODBC driver in order to work in conjunction with Data Splitter.

Visit datasplitter.com/database.html for more information.