SharePoint List sync with SQL Server Database

%3CLINGO-SUB%20id%3D%22lingo-sub-4633%22%20slang%3D%22en-US%22%3ESharePoint%20List%20sync%20with%20SQL%20Server%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-4633%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20establish%20a%20sync%20with%20a%20SQL%20Table%20and%20SharePoint%20list%20without%20using%20third%20party%20tool%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-388900%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20sync%20with%20SQL%20Server%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388900%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2281%22%20target%3D%22_blank%22%3E%40Rashid%20Mohammed%3C%2FA%3E%26nbsp%3B%3A%20Let%20me%20know%20if%20you%20figured%20out%20a%20solution%20for%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-388899%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20sync%20with%20SQL%20Server%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388899%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F4570%22%20target%3D%22_blank%22%3E%40Richard%20Bourke%3C%2FA%3E%26nbsp%3B%26amp%3B%20the%20original%20poster%20of%20question%20or%20anyone%3F%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EDid%20you%20figure%20out%20a%20way%20to%20accomplish%20this%3F%20I%20have%20the%20exact%20same%20situation%20where%20I%20want%20to%20connect%20some%20of%20the%20lists%20in%20the%20SP%20online%20site%20to%20tables%20in%20our%20local%20SQL%20Database%20(not%20on%20azure%20or%20cloud%20hosted)%3CBR%20%2F%3E%3CBR%20%2F%3EUse%20Case%3A%26nbsp%3B%20for%20one%20example%20the%20'Branch%20managers'%20list%20with%20Manger%20Name%20%26amp%3B%20Employee%20ID%26nbsp%3B%20should%20be%20in%20sync%20with%20the%20'Branch%20Managers'%20table%20in%20the%20SQL%20DB.%20The%20purpose%20of%20doing%20so%20is%20when%20we%20fill%20out%20a%20request%20form%20in%20Sharepoint%2C%20the%20Branch%20manager%20dropdown%20looks%20up%20branch%20managers%20list%20which%20should%20have%20the%20branch%20manager%20information%20as%20per%20SQL%20table%20(which%20is%20the%20golden%20copy%20of%20data)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-14937%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20sync%20with%20SQL%20Server%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-14937%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20you%20looked%20to%20see%20if%20BCS%20would%20do%20what%20you%20need%3F%20Its%20for%20surfacing%20database%20content%20in%20SharePoint%20lists.%20Its%20more%20complicated%20in%20SharePoint%20online%2C%20particularly%20if%20your%20database%20is%20on%20premise%2C%20but%20there%20are%20a%20lot%20of%20great%20resources%20out%20there%20with%20guidance%20on%20setting%20up%20an%20external%20content%20type%20etc.%20This%20link%20can%20get%20you%20started%3A%20%3CA%20href%3D%22https%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Foffice%2Fhh418045%2528v%3Doffice.14%2529.aspx%3Ff%3D255%26amp%3BMSPPError%3D-2147217396%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Foffice%2Fhh418045%2528v%3Doffice.14%2529.aspx%3Ff%3D255%26amp%3BMSPPError%3D-2147217396%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EAnother%20possible%20approach%2C%20if%20you%20could%20publish%20restful%20service%20in%20front%20of%20your%20database%2C%20it%20would%20be%20possible%20to%20do%20something%20with%20JSLink%20to%20grab%20the%20choice%20data%20for%20the%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-14916%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20sync%20with%20SQL%20Server%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-14916%22%20slang%3D%22en-US%22%3E%3CP%3EA%20real%20sync%20(two-way)%20including%20conflict%20management%2C%20authentications%2C%20logging%2C%20notifications%26nbsp%3Betc.%20isn't%20easy%20to%20setup%20in%20a%20few%20minutes.%20Try%203rd%20party%20products%20%3D%20to%20start%20quickly%20with%20SQL%20(any%20vendor%20supported)%20and%20SharePoint%20(any%20version%20or%20plan).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHope%20that%20helps.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%2C%20Frank%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-6199%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20sync%20with%20SQL%20Server%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-6199%22%20slang%3D%22en-US%22%3EPower%20BI%3F%20Let%20me%20know%20your%20Ideas.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-5075%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20sync%20with%20SQL%20Server%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-5075%22%20slang%3D%22en-US%22%3EI%20was%20looking%20something%20which%20can%20be%20done%20within%20SPO%20without%20any%20external%20app%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-5073%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20sync%20with%20SQL%20Server%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-5073%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20have%20a%20Choice%20column%20with%20options%20beeing%20pulled%20from%20a%20sql%20table.%20I%20was%20thinking%20of%20making%20the%20a%20lookup%20column%20where%20the%20lookup%20list%20will%20be%20in%20sync%20with%20sql%20database.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-4640%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20sync%20with%20SQL%20Server%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-4640%22%20slang%3D%22en-US%22%3E%3CP%3ETake%20a%20look%20at%20this%20%3A%20%3CA%20href%3D%22http%3A%2F%2Fwww.axioworks.com%2Fsqlist%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.axioworks.com%2Fsqlist%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-4637%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20sync%20with%20SQL%20Server%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-4637%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20could%20use%20Power%20Bi%20for%20this.%20but%20you%20need%20more%20info%20what%20you%20want%20to%20establish.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKR%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1204920%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20sync%20with%20SQL%20Server%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1204920%22%20slang%3D%22en-US%22%3E%3CP%3EYes%20very%20much%20so%20with%20the%20free%20tool%20Fusion%20from%20NoCodeSolution.com%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2281%22%20target%3D%22_blank%22%3E%40Rashid%20Mohammed%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1204923%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20sync%20with%20SQL%20Server%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1204923%22%20slang%3D%22en-US%22%3EHi%20Rashid%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20do%20it%20elegantly%20with%20the%20free%20tool%20Fusion%20from%20NoCodeSolution.com%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1204925%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20sync%20with%20SQL%20Server%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1204925%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F246800%22%20target%3D%22_blank%22%3E%4097sid%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EYou%20can%20do%20it%20elegantly%20with%20the%20free%20tool%20Fusion%20from%20NoCodeSolution.com%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1204926%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20sync%20with%20SQL%20Server%20Database%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1204926%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F4570%22%20target%3D%22_blank%22%3E%40Richard%20Bourke%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20do%20it%20elegantly%20with%20the%20free%20tool%20Fusion%20from%20NoCodeSolution.com%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Is it possible to establish a sync with a SQL Table and SharePoint list without using third party tool? 

13 Replies
Highlighted

You could use Power Bi for this. but you need more info what you want to establish.

 

KR

 

Paul

Highlighted
Highlighted

I would like to have a Choice column with options beeing pulled from a sql table. I was thinking of making the a lookup column where the lookup list will be in sync with sql database.

Highlighted
I was looking something which can be done within SPO without any external app
Highlighted
Power BI? Let me know your Ideas.
Highlighted

A real sync (two-way) including conflict management, authentications, logging, notifications etc. isn't easy to setup in a few minutes. Try 3rd party products = to start quickly with SQL (any vendor supported) and SharePoint (any version or plan).

 

Hope that helps.

 

Thanks, Frank

 

 

Highlighted

Have you looked to see if BCS would do what you need? Its for surfacing database content in SharePoint lists. Its more complicated in SharePoint online, particularly if your database is on premise, but there are a lot of great resources out there with guidance on setting up an external content type etc. This link can get you started: https://msdn.microsoft.com/en-us/library/office/hh418045%28v=office.14%29.aspx?f=255&MSPPError=-2147...

Another possible approach, if you could publish restful service in front of your database, it would be possible to do something with JSLink to grab the choice data for the column.

Highlighted

@Richard Bourke & the original poster of question or anyone? 

Did you figure out a way to accomplish this? I have the exact same situation where I want to connect some of the lists in the SP online site to tables in our local SQL Database (not on azure or cloud hosted)

Use Case:  for one example the 'Branch managers' list with Manger Name & Employee ID  should be in sync with the 'Branch Managers' table in the SQL DB. The purpose of doing so is when we fill out a request form in Sharepoint, the Branch manager dropdown looks up branch managers list which should have the branch manager information as per SQL table (which is the golden copy of data)

Highlighted

@Rashid Mohammed : Let me know if you figured out a solution for this.

Highlighted

Yes very much so with the free tool Fusion from NoCodeSolution.com

@Rashid Mohammed 

Highlighted
Hi Rashid,

You can do it elegantly with the free tool Fusion from NoCodeSolution.com

Highlighted

@97sid 

You can do it elegantly with the free tool Fusion from NoCodeSolution.com

Highlighted

@Richard Bourke 

You can do it elegantly with the free tool Fusion from NoCodeSolution.com