JDBC Store node is great for automatically inserting records into your database. I also recommend looking at the JDBC Execute node as it gives you greater control of your insert and update statements. For example, you can pass in SQL field bindings and then use those just as you would in any other SQL tool. The question marks (?) represent the fields in the same sequence as the SQLQueryFieldBindings property. For example, an insert statement would look like the following (the dashes denote comments)
INSERT INTO customers (first_name, last_name, email, id)
VALUES (?, ?, ?, ?)
