I have been trying to connect my MYSQL server to Sharepoint so Sharepoint list will automatically sync to mysql. Any answers would be greatly appreciated. Willing to use other databases as long I am able to get a database up and running and synced with Sharepoint List.
1 Answer
SharePoint Online cannot directly connect to on-premise sql server.
Here are some options for you:
2.Use Azure Hybrid Connections:https://asishpadhy.com/2018/01/19/getting-on-premises-data-from-sql-to-sharepoint-online-using-azure-hybrid-connections/
3.Create custom WCF service: https://docs.microsoft.com/en-us/dotnet/framework/wcf/feature-details/how-to-create-a-basic-wcf-web-http-service
References:
https://www.peters.com/blog/exposing-sql-data-sharepoint-online/