How to add rows of value to database

Do you have the list of values stored in a CDT variable?

If yes, you can use a!writeDataStoreEntity() in the saveInto parameter of a button to add/update all the rows in the table.

If you have multiple CDT variables and you need to add/update rows in multiple tables, use a!writeToMultipleDataStoreEntities() in the saveInto parameter of the button. 

If you do not have the list of values stored in a CDT variable, you can create a stored procedure in your database, pass all your variables to the stored procedure from Appian using the execute stored procedure plugin and let the procedure do all the adds and updates. Call the execute stored procedure plugin on button click. That way, one button click will allow you to add/update multiple rows.