Connection 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 dropdownlistpopulated with the names of these clients.
SharePoint External List Permissions
I created an External List on Sharepoint that gets data from SQL server. On My account I can see the list data and everything works ok. I want to grant access to a group of users (Basically the whole team) I added the whole team to the sharepoint site and everyone can access it ok. However when they go to the list with External conetent I get: Access denied by Business Data Connectivity. Correlation ID:dd5d6f9f-2054-a000-87b8-8c3592d584a7 What I did to try to fix: I updated the BCS External content type permissions to include the group (Sharepoint Admin > BCS). Currently I gave them all the permissions (Edit, Execute, Selectable in Clients, Edit Permissions). I also set MetaData Store permissions to also include this group. There I also gave them all permissions like above. I have made these changes over 24 hours ago and none of the users can access the list. They all get the same error. What am I missing? Any help would be greatly appreciated.
