How to conect sharepoint 2013 BCS with MySQL?

Question

How to connect sharepoint BCS with MySQL? I try to connect BD MySQL from BCS at SharePoint Online.

Answer 1

In SharePoint On-Prem you can achieve this by

• Building a custom BCS Modal via Visual studio or

• Using a third-party solution like

  • BCS Meta Man
  • CData.

---

In SharePoint Online, you can Create external content types for OData data sources, Unfortunately, I am not an expert in MySql to inform you the available OData REST API for MySQL but you can check this

Meanwhile, you can build an OData Service EndPoint, then consume it within a SharePoint Hosted Add-In or by using a BDC Model. Check the detail steps at SharePoint Online OData BCS

Check also

• Manage Business Connectivity Service Applications
• BCS in Sharepoint Online Limitations