Business Connectivity Data Services in O365
Hello I was asked about the possibility of adding an Azure SQL table to a SharePoint Online site; I see tutorials saying its possible but I'm currently stuck on trying to trying the create in SharePoint Designer 2013 with the error message below. I have access to the admin and can get to the BCS service pages. I also added myself to the services permissions but no change. Is BCS and External Content types still available in SharePoint Online or have they been deprecated in some of the Content Type changes made recently? I saw this post with someone with the same error but they don't really mention if its gone or not https://techcommunity.microsoft.com/t5/sharepoint-developer/the-business-data-connectivity-metadata-store-is-currently/m-p/780648Connection SharePoint List/DocLib to (Azure) SQL data
I'm not a SharePoint dev, but have some experience with SharePoint lists and also SQL. However not in combination. While researching this, I notice "Business Connectivity Services" seems to be the answer. However it seems BCS isn't really actively worked on? Is using this future proof? Lets take this simple example: In a Azure SQL database we have a list of clients. In a SharePoint list I want a choicefield with a dropdownlist populated with the names of these clients.
