I am looking for the best options on connecting my SharePoint list with external data sources like SQL database and exchange servers to update the contacts list automatically. I am using SharePoint 2010. Any suggestions on this.
1 Answer
For SQL databse you have to use BCS, Can you please what do you mean by contact list ? It is custom list ? If so again you have to use BCS...
http://blog.arjanfraaij.com/2011/07/sharepoint-2010-using-bcs-with-sql.html http://www.codeproject.com/Articles/60190/Business-Connectivity-Services-in-SharePoint https://msdn.microsoft.com/en-us/library/office/ee557243(v=office.14).aspx
Hope this help!!!
-
Yes sidhharth its a custom list. Thanks for the links. I will implement them on my beta site and will follow up if am stuck anywhere. thanks again.SPLearner– SPLearner2016-09-28 17:08:53 +00:00Commented Sep 28, 2016 at 17:08
-
np...best luck....!!!!Siddharth Vaghasia– Siddharth Vaghasia2016-09-28 17:16:42 +00:00Commented Sep 28, 2016 at 17:16