Hi all,
I want to ask about the difference between "write data entity" and "write record".
As an example, I have to store information in the database on 3 different tables, and I am using the "write multiple data entity" option.
which would be the most optimal performance in these cases, 3 "write records" or "write multiple data entity" with 3 transitions?
Discussion posts and replies are publicly visible
Hello, We can decide this based on our requirement where we are going to use the smart services to write the data.
we use Write to Multiple Data Store Entities Smart Service writes multiple CDT values to multiple entities within the same data store where you can update multiple entities within a single database transaction.
We can use the Write Records smart service which easily insert or update data in your source system and then automatically sync those changes in Appian. We have multiple advantages of data sync.
please refer this link for more info and based in the requirement we can decide on which one to choose:
https://docs.appian.com/suite/help/22.1/records-data-sync.html#benefits-of-data-sync