If you have a web service setup on a remote server (SQL-end) you could leverage the delete trigger to make a callout to that service with the deleted record's information.
If you have a web service setup on a remote server (SQL-end) you could leverage the delete trigger to make a callout to that service with the deleted record's information.
I think I would want to make an HTTP callout from an apex trigger /class to a web server php script which could perform the operations necessary. Does this sound correct?
If this is the right approach how should I authenticate this HTTP callout from salesforce in my web server? It is crucial to make sure that the php script is only accessible from salesforce
You can either setup basic authentication on your web server and configure the callout to pass the authentication information - or you can lock down the IPs that your web server responds to by the list of datacenter IPs that Salesforce maintains.
All Answers
I think I would want to make an HTTP callout from an apex trigger /class to a web server php script which could perform the operations necessary. Does this sound correct?
If this is the right approach how should I authenticate this HTTP callout from salesforce in my web server? It is crucial to make sure that the php script is only accessible from salesforce
You can either setup basic authentication on your web server and configure the callout to pass the authentication information - or you can lock down the IPs that your web server responds to by the list of datacenter IPs that Salesforce maintains.