How to INSERT or UPDATE a record in MS SQL with AnaplanConnect export action (jdbc properties)
We have a requirement to export Anaplan data into a Microsoft SQL Server database. We have requirement that, need to insert in a table if new records or replace with existing records.
As per Anaplan Connect latest user guide shows it’s achievable with REPLACE or INSERT IGNORE SQL commands.
But I’m facing following error message and none of the records updated/inserted into the table.
I'm unable to insert new record or update existing record with below SQL statement. Kindly help me /suggest me if I'm doing wrong or we can't achieve this requirement.
Please help me.
Thanks & regards,