How to update existing records(s) and insert as new records if not exists like UPSERT

Options
anildudam
anildudam
in Integrations and extensibility

Hi,

How to update existing records(s) and insert as new records if not exists like UPSERT through Anaplan Connect script for MS SQL Server?

Thanks & regards,

Anil

Tagged:

Answers

  • QuinE
    QuinE
    Options

    Hi @anildudam - there is no real way to do this with Anaplan Connect except to flush and refill your Anaplan target.

  • anildudam
    anildudam
    Options

    Hi QuinE,

    Thanks for your reply.

    We should not delete existing data from the table as per the requirement, so I did other way around like create another stag table just for insert then run the merge query to update or insert main table through Windows batch script of SQLCMD like below.

    image.png

    Anaplan support team helped me on the sqlcmd solution.

    Thanks & regards,

    Anil

Categories