Skip to Content

SQL Call atom in B1IF

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    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.

    Add comment
    10|10000 characters needed characters exceeded