Asmath,
Upsert in SQL Server (without NiFi) can be difficult, and even
error-prone if concurrency is needed [1]. I suspect that's why it
hasn't been attempted in PutDatabaseRecord (well, via the MSSQL
adapter(s)) as of yet. I haven't tried it without creating a procedure
so I'm not sure if the MSS
Hi,
I am looking for some help on how to deal with upserts/updates on SQL
Server with NIFI.
I get a flow file where the records are updated. Primary key are already
defined on the table.
I don't want to try the logic of delete and insert, is there a way to
handle upsert automatically with this a