+ Start a Discussion
A BroadbentA Broadbent 

Pulling data from MySQL to salesforce (and possibly back again)

Hi,
I am new to salesforce.
I currently have a wordpress site that logs customer queries and leads to a few custom tables in the mysql database of the WP site. I can see there there are many tools out there that can connect salesforce to MySQL. Can anyone recommend a plugin that works with good documentation.
I will need the plugin to read/write to this DB.

Thanks
NagaNaga (Salesforce Developers) 
Hi A Broadbent,


Web service callouts: You can write a trigger on the object that you want to get notified from which you can make @future web service callout to your web services (which you have already covered in your question and I'm including this here for completeness)

Outbound SOAP messages: If you want to get updates only from one object (for e.g. Account or Contact), then outbound SOAP message can be used to fire a call to your web service. Note that outbound SOAP messages provide you the WSDL and you need to implement this WSDL and you will not be able to use an existing web service.

Polling: You can design a solution on your external system to continuously poll Salesforce to get any new data. There are several methods based on the technology that you use. For e.g. If you use DbAmp or Pragmatic Works Task Factory, you can write regular SQL code or use SSMS and SQL Agent to schedule a job to retrieve the delta records (i.e. only those who got updated or inserted).

Streaming API: You can use Streaming API to define a SOQL query on the objects that you are interested to receive the updates and develop client on your external system to get notifications in real-time. Please check out the 'Getting started with Streaming API' and 'Streaming API Developers Guide' I'm not that familiar with NodeJS and I do not know if it provides API to handle Bayeux protocol. So this might be a deal breaker to use Streaming API.

Of all the four options, I believe the Streaming API is the best in terms of performance and scalability. However, if your requirements to get real-time notifications are very minimal and DbAmp/PragmaticWorks Task Factory may be the easiest and quickest way to implement as it doesn't require any extra coding on the Salesforce side. These tools are not that costly too.

Please also see the video below for more information on this


http://www.youtube.com/watch?v=Gx2KKdQBP98&list=PL5r_cn5WNR8z9VAFosNbnp9rFdeORN5t6

Please let me know if this was helpful

Best Regards
Naga kiran
nbknbk
Hi A Broadbent,

Below are the feasible options from My sql to salesforce.
  • CastIron - http://www-01.ibm.com/software/integration/cast-iron-cloud-integration/salesforce-integration/
  • SSIS
  • Mulesoft
Based on your requirement you can check suitable option . (real time integration/one time activity..)

 
David GardelDavid Gardel
Hi there,

There are three completely different ways how can you do bi-directional integration between Salesforce and MySQL:

- First one is to use (SOAP, REST). It requires quite impressive knowledge about codding, so it won`t be easy for all users
- Using AppForce API. You supposed to be the good expert at this AppForce API
- As an alternative, you can try 3rd parties connectors: Devart SSIS (https://www.devart.com/ssis/salesforce.html) (desktop) or Skyvia (https://skyvia.com/connectors/salesforce)(web-based no coding integration).