How to INSERT or UPDATE a record in MS SQL with AnaplanConnect export action (jdbc properties)

anildudam · 2023-08-29T14:20:40+00:00

There was an error rendering this rich post.

Hi ALL,

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,

Kumar

Accepted answers

All comments

Konstantin Malchushkin

Did you try this SQL code in SQL manager?
Did it insert the data?

If not then problem is in SQL code.

It seems it tries to insert data to [Master] data base, and it could be that your data base has another name.

[data base name].[dbo].[SQLDB_tbl]

anildudam

Hi Konstantin,

Sorry for the late reply.

I tried the above SQL query to run directly but it's not successful due to it's not a valid command.

REPLACE is a function to replace a string.

I'm looking a solution "how to update a record or insert if not available in a table through Anaplan Connect?

Thanks @ regards,

Anil

Quick Links

Can you help?

Unanswered questions

Invalid Parent - Combined List
Hello Anaplan Community, I have a product hierarchy with 5 levels . For a client requirement, I need to transform this product hierarchy into a combined list , to be able to select different levels of the hierarchy in a line item (drop down list) For this, I tried to create different saved views where I have for example :…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…