AnsweredAssumed Answered

How can I enable batching when inserting into the DB ? The "Batch Count" option at operation level seems to be only related to committing, but I'm actually interested in having less interactions with the database...

Question asked by BogdanTopor5381 on Nov 4, 2013
Latest reply on Nov 5, 2013 by BogdanTopor5381

     I know that Boomi is based on Java, so there should be a way to add multiple queries to a batch and execute the whole batch at once. This is very important for my project because I need to obtain less interactions with the database. 

     I've managed to merge the documents to be inserted so all the queries reach the DB Connector simultaneously and I've set a high enough value for the "Batch Count" option. But that seems to only be related to commiting the transaction.

     So, how can I obtain this with Boomi?

Outcomes