Skip to Content

SQL Call atom in B1IF

Nov 08, 2017 at 10:07 AM


avatar image

Dear colleagues!

I use SAP Business One Integration Framework version 1.22.10. I'm developing a scenario which prepare data and insert ot to the SQL data storage. So, here is the question: is it possible to cache an opened SQL connection to use it in SQL Call atoms in for-each flow, or those atoms will always open and close SQL connections when they are called?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Heinz Pauly
Nov 09, 2017 at 04:19 PM

For all adapter calls (http, sql, ...) it is the same concept. A connection stays open, so also for JDBC calls. Means not only in this particular instance flow in for-each, but for all message-processings of this step and even for other scenario steps that are using the same connection.

If you want to optimize the described processing, please check if its possible to compile all sql-statements in 1 xform atom (concatinated by ;) and after the xform, just have 1 jdbc call to handover all sql statements together. This avoids the for-each construct and multiple adpater calls.

10 |10000 characters needed characters left characters exceeded