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.

Improve this question
18
  • Why aren't you using external lists for that? When you say custom list, are you really referring to custom SharePoint list?
    – Mohamed Derhalli
    Commented May 13, 2016 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
    Commented May 13, 2016 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
    Commented May 13, 2016 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
    Commented May 13, 2016 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
    Commented May 13, 2016 at 7:30

1 Answer 1

Reset to default
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.

Improve this answer
10
  • 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
    Commented May 13, 2016 at 8:02
  • Is there any way to add External content type to custom list?
    – Elina
    Commented May 13, 2016 at 8:14
  • Hi hardik using timer job we can integrate SQL to SharePoint list ?
    – Elina
    Commented May 13, 2016 at 9:51
  • Please check here if you can get something for you...blogs.msdn.microsoft.com/mind_talks/2012/04/03/…
    – Hardik
    Commented May 13, 2016 at 9:53
  • Already i referred this, you have any idea about timer job to integrate sql to sharepoint ?
    – Elina
    Commented May 13, 2016 at 9:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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