Aug 05 2016 02:16 AM
Is it possible to establish a sync with a SQL Table and SharePoint list without using third party tool?
Aug 05 2016 02:24 AM
You could use Power Bi for this. but you need more info what you want to establish.
KR
Paul
Aug 10 2016 05:31 AM
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.
Aug 10 2016 05:44 AM
Aug 18 2016 12:20 AM
Sep 22 2016 11:12 AM - last edited on Jan 10 2018 10:44 AM by Eric Starker
Sep 22 2016 11:12 AM - last edited on Jan 10 2018 10:44 AM by Eric Starker
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
Sep 22 2016 12:17 PM - edited Sep 22 2016 12:44 PM
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.
Mar 26 2019 09:56 AM
@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)
Mar 26 2019 09:57 AM
@Rashid Mohammed : Let me know if you figured out a solution for this.
Mar 02 2020 09:44 AM
Yes very much so with the free tool Fusion from NoCodeSolution.com
Mar 02 2020 09:46 AM
Mar 02 2020 09:46 AM
You can do it elegantly with the free tool Fusion from NoCodeSolution.com
Sep 04 2023 02:07 AM