I have a MYSQL database that contains customer related data from sugarcrm while a few order related data is stored in the MSSQL server.

So far, I have been able to create an external list for the orders using SPD and external content types leveraging BDC for SP 2010 . But regarding MySQL , I am slightly lost as it seems there are no apparent straightforward ways to do this.

Googled my way to land up in a few places where people either wrote some piece of BCS code or used some third party solution. If someone has tried the same before, kindly share the approach as it will be really helpful.

2 Answers 2


I don't understand what you are after. You are saying that you found some places where people wrote piece of BCS ? Why doesn't that work for you?

Here is a very good explained guide that I used to connect MySQL with BCS:



I hope this link helps.


  • Thanks for the solution, however I had seen this link before and as mentioned in my question I am looking for approach (precisely the steps and logic behind). Third party solutions are there but even those solutions work with a certain logic. I am looking for the same.
    – ArkoD
    Commented Jul 10, 2012 at 12:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.