Thread: Sync?
View Single Post
  #2  
Old 04-22-2008, 10:11 AM
mike mike is offline
Administrator
 
Join Date: May 2007
Posts: 248
Send a message via AIM to mike Send a message via MSN to mike Send a message via Yahoo to mike Send a message via Skype™ to mike
Thumbs up Yes, it should work!

Quote:
Originally Posted by zishan876 View Post
Hi:
Is there a way to sync data from salesforce to MYSQL to check something and bring it back to salesforce on a click of a button...
LIke for example, I am on salesforce and want to book a room for a hotel but the data of the room avialability is on MYSQL database. Has anyone try to sync from a click of a button from salesforce to MYSQL and then back...
Maybe its the wrong place to ask but I am giving it a shot...
Thanks
Yes it is possible.

If you had a button and it's action was to call an external script (using your example)

Code:
http//www.yoursite.com/somescript.php?check_date=[date_from_salesforce]
and the script on your server, somescript.php would process the date coming in from Salesforce and query your MySQL database and then return the date back to Salesforce in the same script

At least I think that would work

~Mike
Reply With Quote