Forum Discussion

RStelzig's avatar
RStelzig
New Contributor
3 years ago

Is it possible to perform an upsert to Postgres in SnapLogic?

Hi Everyone, Is there an option to configure an existing Postgres snap to perform an upsert to a given table? I am building a pipeline to create a daily feed to a postgres database and would like...
  • mina's avatar
    mina
    Employee
    8 years ago
    Copy Link

    Hi @slaytanic70, there is an example script in this post
    CLI for BCP (SQL SVR) and dynamic file names

    Let us know how it works for you and any questions.

    • slaytanic70's avatar
      slaytanic70
      New Contributor III
      8 years ago
      Copy Link

      @mina, thanks so much for this! I’m going to work on it this afternoon and this weekend. I took a quick peek and I think this will do the trick.

    • slaytanic70's avatar
      slaytanic70
      New Contributor III
      8 years ago
      Copy Link

      I made a simple modification to the 1_Run_BCP_CLI and I replaced the batch file with notepad.exe. I just want to see notepad open.

      A couple issues happened:

      1. With the snaplex on sqlserver 2012 - nothing happens…it just hangs there.
      2. I installed the snaplex on my laptop and had the pipeline run against there. It opens notepad.exe no problem, but the pipeline continues running.

      What needs to be done for it to complete?

      Thanks for your help!
      FS