Connection SharePoint List/DocLib to (Azure) SQL data

%3CLINGO-SUB%20id%3D%22lingo-sub-1922722%22%20slang%3D%22en-US%22%3EConnection%20SharePoint%20List%2FDocLib%20to%20(Azure)%20SQL%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1922722%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20not%20a%20SharePoint%20dev%2C%20but%20have%20some%20experience%20with%20SharePoint%20lists%20and%20also%20SQL.%3C%2FP%3E%3CP%3EHowever%20not%20in%20combination.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhile%20researching%20this%2C%20I%20notice%20%22Business%20Connectivity%20Services%22%20seems%20to%20be%20the%20answer.%3CBR%20%2F%3EHowever%20it%20seems%20BCS%20isn't%20really%20actively%20worked%20on%3F%26nbsp%3BIs%20using%20this%20future%20proof%3F%3CBR%20%2F%3E%3CBR%20%2F%3ELets%20take%20this%20simple%20example%3A%3CBR%20%2F%3EIn%20a%20Azure%20SQL%20database%20we%20have%20a%20list%20of%20clients.%3CBR%20%2F%3EIn%20a%20SharePoint%20list%20I%20want%20a%20choicefield%20with%20a%20dropdownlist%26nbsp%3Bpopulated%20with%20the%20names%20of%20these%20clients.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1922722%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ebcs%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

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. 

 

 

 

 

 

 

0 Replies