Go Back   Mike Simonds > Salesforce > Salesforce Coding Discussions

This is a discussion on Sync? within the Salesforce Coding Discussions forums, part of the Salesforce category; Hi: Is there a way to sync data from salesforce to MYSQL

Reply
 
LinkBack Thread Tools Rate Thread
  #1  
Old 04-22-2008, 07:28 AM
Junior Member
 
Join Date: Mar 2008
Posts: 12
Question Sync?

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

  #2  
Old 04-22-2008, 10:11 AM
Administrator
 
Join Date: May 2007
Posts: 214
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3  
Old 04-22-2008, 09:13 PM
Junior Member
 
Join Date: Mar 2008
Posts: 12

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4  
Old 04-23-2008, 06:56 AM
Administrator
 
Join Date: May 2007
Posts: 214
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

Quote:
Originally Posted by zishan876 View Post
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump



Powered by vBulletin


SEO by vBSEO 3.2.0 RC8 ©2008, Crawlability, Inc.

1 2 3 4 5