Contents
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). Same data are in sharepoint list1 (Customlist Name : Employeedatabase) also but exept PhoneNumber column.
When do you need an external content type?
Creating an external content type is a pivotal task when you are working with external data. An external content type contains important information about connections, access, methods of operation, columns, filters, and other metadata that is used to retrieve the data from the external data source.
How to create external content types for SQL Server?
Click Add Connection, select SQL Server in the External Data Source Type Selection dialog box, and then click OK. In the SQL Server Connection dialog box, enter the name of the server, the database name, an optional description, and then click OK. To choose an authentication mode,…
How to create associations between external content types?
Create the association on the external content type that has the foreign key to the parent external content type. For example, consider the Customer-Order scenario where a customer places multiple orders. Each order has a field that lists the name of the customer who placed the order, in addition to other fields such as Price, Quantity, and Date.
The external data column enables users to add data from external content types to standard SharePoint lists. Just like an external list, external data columns can display data from any external content type that is modeled in Business Connectivity Services (BCS).
How to look up external content in SharePoint?
Enable external data search: You can use SharePoint Server search from an intranet portal to look up information about a specific external content type, such as a customer. SharePoint Server search retrieves the data directly from the external system.