How to Establish Connection with External SQL Server DataBase using PHP
We are trying to establish a connection with an External SQL Server DB using Service cloud PHP (File Manager scripts) to update the data (small amount of data) in SQL tables. We want to achieve it with out using any API's. We are okay if it is possible by any other means other than PHP but it should be with in Service cloud with out any need of integrations.
Could anyone suggest if it is possible?
We have a simple business case where if a field "xyz" is updated in table T1 in service cloud the same should be updated in the SQL DB also in table T2 for the field 'xyz' synchronously.