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

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!

Which are all ways to handle record sync error during the process itself for write to record smart service.

If we configure write to record and if record sync fails with any reason after writing into source table then what could be the way to identify the issue in sync.

I can think of Record sync smart service by passing identifier after write to record to make sure it works and then notify the initiator for any error and to contact support team.

Any other suggestion apart from record sync error notification to Admin?

The smart service will handle that and fail in case of an error. Then the alert management of the process model kicks in.

We also recently introduced a feature for a "recovery sync": docs.appian.com/.../records-data-sync.html

This helps because if a write fails due to a sync issue, it will automatically retry a full sync and recover from the issue. It doesn't address all issues, but does account for a lot of intermittent issues!

We also recently introduced a feature for a "recovery sync": docs.appian.com/.../records-data-sync.html

This helps because if a write fails due to a sync issue, it will automatically retry a full sync and recover from the issue. It doesn't address all issues, but does account for a lot of intermittent issues!