write directly from interface to DB

Hi All,
I have developed a SAIL interface that is be able to directly write to DB using the function

a!writeToDataStoreEntity(cons!NCContainmentAction,local!newContainmentAction)

the local!newContainmentAction is an object created locally as

local!newContainmentAction:fn!cast('type!{www.pirelli.com/.../appian}NonConformityContainment',{})

This approach is very helpful because we are able to write directly on DB avoiding many other nodes witch, before using this approach, we used to elaborate data and write to DB
It also seems that SAIL code is simpler and faster to manage because we deal with the object and its attributes

I have never seen this kind of approach in Appian SAIL documentation so I would like to understand if it is correct and if you suggest or not to use it

Thank you in advance

Elia




OriginalPostID-249822

  Discussion posts and replies are publicly visible

Parents
  • @philb sorry but I can't understand what you mean ..
    What is the difference if you use a smart service to write into DB ?
    A process , started in background, can change data meanwhile another user is viewing a report or something else in the same table ..
    Data transactions are managed by DB so is not possible to have deadlock or something else on DB ... in any case I think the situation is equal to a smart service that performs a write operation ...


Reply
  • @philb sorry but I can't understand what you mean ..
    What is the difference if you use a smart service to write into DB ?
    A process , started in background, can change data meanwhile another user is viewing a report or something else in the same table ..
    Data transactions are managed by DB so is not possible to have deadlock or something else on DB ... in any case I think the situation is equal to a smart service that performs a write operation ...


Children
No Data