My desired end result for this project is when a lead record is converted to person account, an HTTP callout will be made to update and external MySQL database.
My initial approach was to utilize the PHP toolkit and have the MySQL database updated via PHP connection to salesforce, but with this approach I cannot have the update occur in real time and I would like the data send be triggered from salesforce, not from a time based inquiry by the SQL database.
Has anyone had success with using REST integrated with MySQL? It appears this approach would require a plugin to MySQL to support REST and all reviews I have found show this may be unstable?
My other thought was to develop a Heroku app to act as a connector between the two. What would the most effective approach be to update the MySQL database from a salesforce triggered event?
To summarize my desired flow:
1) Lead object is converted to person account
2) On lead conversion, basic client data is sent to update MySQL database on external server.
OR (alternate functionality considered)
1) Custom button to be added to lead object to send data to the MySQL database.
Any other ideas to make this connection from salesforce to MySQL are appreciated as long as they are not time based. I need this to function either via trigger or class code called from custom button (real time). Thanks everyone in advance for any ideas or suggestions!!!