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?

Like Follow 1

- Steve Mason
- smason
- 5 mths ago
- Bugs or Issues
- Reported - view
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

Like
- Steve Mason
- smason
- 5 mths ago
- Bugs or Issues
- Reported - view
Ferdinand Tonby-Strandborg

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

Like
- Ferdinand Tonby-Strandborg
  
  ferdinand_TS
  
  5 mths ago
  
  Reported - view
  Hi Steve Mason,
  
  That's great to hear! Thank you!
  
  Like
- Steve Mason
- smason
- 9 days ago
- Bugs or Issues
- Reported - view
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.

Like