How to implement transactions in appian

I have a process like this. I want to use transaction constraints on three write record nodes. Is there some easy way I can implement my require. 

 

another question is what the functional of sync records. 

I have read this document. https://docs.appian.com/suite/help/25.2/Sync_Records_Smart_Service.html But I don't understand the node's function and what scenario will use this node. I think when I use the write records, the data has already update into the database and sync automatically, why I need this node.

 

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer

    Constraints :- Instead of using three separate Write Records nodes, configure all three records in a single Write Records node. This automatically creates one transaction, ensuring that if any write fails, all operations roll back while maintaining all record and database relations.


    To understand sync record smart service first understand basics of sync record:-
    Sync Records synchronizes data from your database into Appian’s record cache.
    What is Sync? --> Appian maintains a cache layer of your database data. Instead of querying the database every time, Appian retrieves data from this cache. Much faster data retrieval and better performance
    Database ← stores your actual data
    Sync Records ← copies/updates data from database to Appian cache
    Appian Cache ← fast, in-memory storage for quick access
    Record View/Queries ← read from cache instead of database.


    When you make database changes (especially outside Appian or bulk operations), you use Sync Records to update Appian’s cache with the latest database information like executing database insert script directly in database.

Reply
  • 0
    Certified Lead Developer

    Constraints :- Instead of using three separate Write Records nodes, configure all three records in a single Write Records node. This automatically creates one transaction, ensuring that if any write fails, all operations roll back while maintaining all record and database relations.


    To understand sync record smart service first understand basics of sync record:-
    Sync Records synchronizes data from your database into Appian’s record cache.
    What is Sync? --> Appian maintains a cache layer of your database data. Instead of querying the database every time, Appian retrieves data from this cache. Much faster data retrieval and better performance
    Database ← stores your actual data
    Sync Records ← copies/updates data from database to Appian cache
    Appian Cache ← fast, in-memory storage for quick access
    Record View/Queries ← read from cache instead of database.


    When you make database changes (especially outside Appian or bulk operations), you use Sync Records to update Appian’s cache with the latest database information like executing database insert script directly in database.

Children