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

Originally Posted by zishan876

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

Hey Mike:
Thank you for the reply... Do you have an example of something like this...Where I can ping a mysql database and bring back some info if availiable into salesforce filling out the fields in sf...
If so Can I see...
Thanks
Zishan

Originally Posted by zishan876

Hey Mike:
Thank you for the reply... Do you have an example of something like this...Where I can ping a mysql database and bring back some info if availiable into salesforce filling out the fields in sf...
If so Can I see...
Thanks
Zishan

I do not have a specific example man, sorry! I do however or maybe I can show you an integration that we have. It is not using MySQL, it uses Oracle. I would be glad. If you have skype, contact me on their > sportsrant2002 is my Id.

I can then use a program called Unyte to show you my desktop and maybe help point you in the right direction


~Mike