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.