Main difference between ‘write to entity’ and ‘write to records'

Certified Senior Developer

Hi all, I am new to the Appian.

I am created an interface with record type, add option and a process model to save the data in database.

Created process model with the options ‘write to entity’ and ‘write to records. Below is my understanding.

  1. Enable activity chaining is refreshing record type data in both the options.
  2. Rule input for interface can be created by using CDT. This will work only for ‘write to entity’.
  3. ‘Write to entity’ and ‘Write to record’ both are same. ‘Write to record’ is the latest one and ‘Write to entity’ is the legacy approach.

 Please confirm is there any other main difference.

  Discussion posts and replies are publicly visible

Parents
  • One of the biggest differences is just the number of objects used. We created the Write Records node because that enables you to use a record type for all operations - if you use Write to DSE, you must create a CDT, Data Store, and Entity to perform the write.

    There are also a couple of additional benefits to Write Records:

    • You can write records and related records together, which makes it easy to update multiple tables at once
    • You can use Write Records to also write record events, which can help you understand the key milestones in your application
    • Write Records has an option to skip the node if an error occurs (while Write to DSE does not), which gives you more flexibility in writing data
    • Write Records is more efficient at updating data - if certain fields are not included or not changed, Write Records ignores them, making updates faster and less likely to accidentally overwrite data

    Like Stefan said - I generally recommend using Write Records over Write to DSE. It has a lot of benefits over Write to DSE, and we're also continuing to make updates to Write Records in the coming quarters!

Reply
  • One of the biggest differences is just the number of objects used. We created the Write Records node because that enables you to use a record type for all operations - if you use Write to DSE, you must create a CDT, Data Store, and Entity to perform the write.

    There are also a couple of additional benefits to Write Records:

    • You can write records and related records together, which makes it easy to update multiple tables at once
    • You can use Write Records to also write record events, which can help you understand the key milestones in your application
    • Write Records has an option to skip the node if an error occurs (while Write to DSE does not), which gives you more flexibility in writing data
    • Write Records is more efficient at updating data - if certain fields are not included or not changed, Write Records ignores them, making updates faster and less likely to accidentally overwrite data

    Like Stefan said - I generally recommend using Write Records over Write to DSE. It has a lot of benefits over Write to DSE, and we're also continuing to make updates to Write Records in the coming quarters!

Children