I want to update a Salesforce Object from a Stored Procedure inside Microsoft SQL Server. Is this possible?
I have use case that will get data from 'X' database .From 'X' db SQL server will get data into raw table and it will apply some business rules and stores the data into localtable. Now by using these local user table i need to compare with data in the Salesforce user object. if there is any change of data in user object then i need to update in salesforce. this should be done only to active users. for this purpose i need to construct a staging table in sql and by using this staging table in sql i need to update in salesforce. my approach is i need to create a view and should get all columns from local user table and then by using this view i need to create a stored proc and then staging table . from staging table i need to use update stored proc . so it will updated in cloud. please let me know whether it is correct or not or any suggestions plz let me know any links where i can find some pseudo code