External Events Database Triggers

Dear Canary team,

I have an external MSSQL server storing Events, and I would like triggers in the database on INSERTs and UPDATEs on the Events and EventProperties tables, however I cannot make this work.

Most solutions I have found online to the error suggest changing the INSERT statement, and so I was wondering if there is any way to do so? Or if there is an alternative solution to my issue?

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Ferdinand Tonby-Strandborg ,

    According to development, you cannot add an insert or update trigger to those tables with the syntax we are using. Sorry ☹️

  • Ferdinand Tonby-Strandborg

    We added a work item to support this functionality in a later release!

  • Hi Ferdinand Tonby-Strandborg ,

    This has been resolved in v23.0. You can reach out to your Canary representative if you need a download link.

print this pagePrint this page
Like1 Follow
  • Status Fixed
  • 10 mths agoLast active
  • 4Replies
  • 71Views
  • 3 Following