Connecting MYSQL database to SharePoint Online List

%3CLINGO-SUB%20id%3D%22lingo-sub-148052%22%20slang%3D%22en-US%22%3EConnecting%20MYSQL%20database%20to%20SharePoint%20Online%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-148052%22%20slang%3D%22en-US%22%3E%3CP%3EAny%20advice%20on%20how%20to%20connect%20a%20MYSQL%20database%20to%20a%20SharePoint%20list%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-148052%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-148643%22%20slang%3D%22en-US%22%3ERe%3A%20Connecting%20MYSQL%20database%20to%20SharePoint%20Online%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-148643%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3EJuan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3B%20is%20correct%20%2C%20there%20is%20no%20direct%20way%20to%20connect%20MySql%20DB%20to%20SPO%20list%20but%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20You%20can%20migrate%20%3CSPAN%3EMySql%26nbsp%3B%20DB%3C%2FSPAN%3E%26nbsp%3Bdata%20to%20SharePoint%20list%20using%20Microsoft%20Flow%20..%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-148065%22%20slang%3D%22en-US%22%3ERe%3A%20Connecting%20MYSQL%20database%20to%20SharePoint%20Online%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-148065%22%20slang%3D%22en-US%22%3EThere%20is%20not%20a%20direct%20way%20to%20connect%20a%20MySQL%20database%20to%20a%20SPO...some%20options%20you%20can%20have%3A%3CBR%20%2F%3E(1)%20Create%20a%20WCF%20service%20that%20expose%20your%20MySQL%20Database%20so%20you%20can%20create%20an%20external%20content%20type%20in%20SPO.%20You%20will%20have%20to%20test%20this%20option%20due%20to%20the%20fact%20Microsoft%20is%20not%20doing%20any%20investment%20in%20BCS%3CBR%20%2F%3E(2)%20Create%20your%20synchronization%20logic%20so%20you%20can%20have%20your%20MySQL%20data%20in%20SPO%3CBR%20%2F%3E(3)%20Relay%20on%20third%20party%20products%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-556691%22%20slang%3D%22en-US%22%3ERe%3A%20Connecting%20MYSQL%20database%20to%20SharePoint%20Online%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-556691%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20thier%20any%20options%20to%20connect%20external%20list%20in%20Sharepoint%20online%20and%20MySql%20database%3C%2FP%3E%3CP%3Ei%20would%20like%20to%20sync%20both%20database%20and%20sharepoint%20online%20external%20list.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Any advice on how to connect a MYSQL database to a SharePoint list?

3 Replies
Highlighted
There is not a direct way to connect a MySQL database to a SPO...some options you can have:
(1) Create a WCF service that expose your MySQL Database so you can create an external content type in SPO. You will have to test this option due to the fact Microsoft is not doing any investment in BCS
(2) Create your synchronization logic so you can have your MySQL data in SPO
(3) Relay on third party products
Highlighted

 Juan Carlos González Martín  is correct , there is no direct way to connect MySql DB to SPO list but 

  You can migrate MySql  DB data to SharePoint list using Microsoft Flow ..

Highlighted

Is thier any options to connect external list in Sharepoint online and MySql database

i would like to sync both database and sharepoint online external list.