Sharepoint List Colum with External Data

%3CLINGO-SUB%20id%3D%22lingo-sub-650591%22%20slang%3D%22en-US%22%3ESharepoint%20List%20Colum%20with%20External%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-650591%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20create%20a%20sharepoint%20list%20and%20define%20a%20column%20there.%20This%20column%20should%20contain%20customer%20names.%20The%20customer%20names%20should%20come%20from%20an%20external%20data%20source.%3C%2FP%3E%3CP%3EThe%20external%20data%20source%20is%20an%20MS%20SQL%20Server%20on%20premise.%3C%2FP%3E%3CP%3EI%20tried%20to%20define%20a%20content%20data%20type.%20But%20I%20did%20not%20succeed.%3C%2FP%3E%3CP%3EThanks%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-650858%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20List%20Colum%20with%20External%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-650858%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F349570%22%20target%3D%22_blank%22%3E%40swagner%3C%2FA%3E%26nbsp%3Bwhat%20version%20of%20SharePoint%20are%20you%20using%3F%20One%20approach%20is%20to%20Business%20Connectivity%20Services%2C%20another%20is%20to%20use%20Flow%20with%20a%20Data%20Gateway%20and%20SQL%20Server%20connection%2C%20another%20is%20to%20use%20a%20tool%20like%20BCS%20MetaMan%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Flightningtools.com%2Fdownload-a-data-integration-tool%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Flightningtools.com%2Fdownload-a-data-integration-tool%3C%2FA%3E%26nbsp%3Bor%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.layer2solutions.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.layer2solutions.com%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-651066%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20List%20Colum%20with%20External%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-651066%22%20slang%3D%22en-US%22%3EHello%3CBR%20%2F%3EI%20use%20sharepoint%20online%20office365%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I would like to create a sharepoint list and define a column there. This column should contain customer names. The customer names should come from an external data source.

The external data source is an MS SQL Server on premise.

I tried to define a content data type. But I did not succeed.

Thanks for your help.

2 Replies
Highlighted

@swagner what version of SharePoint are you using? One approach is to Business Connectivity Services, another is to use Flow with a Data Gateway and SQL Server connection, another is to use a tool like BCS MetaMan, https://lightningtools.com/download-a-data-integration-tool or https://www.layer2solutions.com/

Highlighted
Hello
I use sharepoint online office365