1

We have a requirement Creating External Content type in sharpoint 2013 based on that SQL database Table.

For example in sql i have four database(db1,db2,db3,db4) and sharepoint i have 4 custom list(list1,list2,list3,list4).

db1 having 4 columns

Same data are in sharepoint list1(Customlist Name : Employeedatabase) also but exept PhoneNumber column.

So i need to add this Phone Number column to Employeedatabase custom list through External content type.

when i add this External Content Type to Employeedatabase custom list PhoneNumber column should be added and Based on that EMPID in that same row PhoneNumber should be update.

How i can achieve this through code without using sharepoint designer?

This is just example like that we are having more database with more columns. Please anyone share sample code snippet or any link for this.

Thanks in advance.

  • Why aren't you using external lists for that? When you say custom list, are you really referring to custom SharePoint list? – Mohamed Derhalli May 13 '16 at 7:19
  • Already we are having more than 100 Custom List in our site.So in existing site only we need to add external content type. – Elina May 13 '16 at 7:23
  • What's the relationship between this content type and the nature of the existing custom list? Is there a specific need to add it to the list? – Mohamed Derhalli May 13 '16 at 7:25
  • Yes, actually in our site SharePoint list does not contain all database(sql) & columns.So manually we can't find which list missing which column.So using sql database we are creating ECT then add this ECT to particular list. – Elina May 13 '16 at 7:29
  • Client need this requirement. i searched lot But i did'd find anything , so its possible ?Are you getting my question ? – Elina May 13 '16 at 7:30
2

Please find the steps to be followed in SharePoint Designer to achieve your desired result.

SharePoint 2013: BDC Configuration And Creating External Content Type and External List

UPDATED

SharePoint List From SQL Server Table (External Content Type with SharePoint Designer)

Please let me know if you need some more help.

Thanks.

  • this is for Extrenal list hardik. I need to add External Content type to already existing custom list. Sharepoint and SQL both should communicate. Any data added to sharepoint list it will come to SQL. From sql i added new item it will added to Sharepoint list – Elina May 13 '16 at 8:02
  • Is there any way to add External content type to custom list? – Elina May 13 '16 at 8:14
  • Hi hardik using timer job we can integrate SQL to SharePoint list ? – Elina May 13 '16 at 9:51
  • Please check here if you can get something for you...blogs.msdn.microsoft.com/mind_talks/2012/04/03/… – Hardik May 13 '16 at 9:53
  • Already i referred this, you have any idea about timer job to integrate sql to sharepoint ? – Elina May 13 '16 at 9:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.