Forum Discussion
BCS External Lists are Failing
Thanks for the response jcgonzalezmartin and I agree with your suggestion that legacy features are getting pruned.
A trouble ticket was opened and here was the response:
"To recap, to trouble shoot this issue SharePoint designers is needed, However SharePoint Designer is not covered under MSFT 365 support."
My guess is that some new rules are being enforced on exactly what SQL sources you can connect to.
Per this article
https://support.microsoft.com/en-us/office/introduction-to-external-data-676e60e7-d99f-463f-a173-65e9d63538c0?ui=en-us&rs=en-us&ad=us
"SPO only supports WCF and SQL Server Azure Connectors"
It appears that the SharePoint Online team just started enforcing this in the last few days (July 4th or 5th, 2020). SQL Virtual Machines apparently did not make the cut.
-Ben
I have also been looking through the same documentation. In my case I have been asked surface
external lists hosted in classic SPO pages ( yes really!) and with data residing on SQL Server 2016 on-premises, via the Azure Data Gateway. I am trying to get my head around what can be achieved or indeed supported
- External lists without BCS,
- External lists using WCF, with BCS configured on SharePoint Online
- Only available to users with E3 or E5 or SharePoint Plan 2 licenses
- Creating DataSources in 1) SharePoint Designer 2010 2) SharePoint 2013.
- Just going with SQL Server Connectors via Power Apps designer - this does work yay!