sharepoint external context type

7/31/2019 SharePoint External Context Type

1/7

SharePoint 2010 : How to create External

Content type

English:

External Content type allows you to make seamless interface between SharePoint 2010 andexternal data storage (ie. SQL server). Using External Content type, you can create anExternal List which stores the data to predefined storage. You can imagine of having a tablewith SharePoint list interface.

To create an External Content type, you need SharePoint Designer 2010. If you curious

enough, the External Content type is enhancement of Business Data Connector (BDC) inprevious version. It will now depend on Business Connectivity Services (BCS) which moreor less same as BDC.

Imagine that you have a table in SQL Database and you want to create SharePoint list whichdirectly stores the data in that table.

1. Open SharePoint Designer and click on External Content Types

2. Define the new External Content Type name. Then click on External System tostart to connect to external Data Storage.
http://blog.libinuko.com/wp-content/uploads/2010/04/SPS2010_BDC0000.png


2/7

3. Define connection to external data storage. (ie. DB name, and security)

In my case, I use SQL server as my data storage.
http://blog.libinuko.com/wp-content/uploads/2010/04/SPS2010_BDC0002.pnghttp://blog.libinuko.com/wp-content/uploads/2010/04/SPS2010_BDC0001.pnghttp://blog.libinuko.com/wp-content/uploads/2010/04/SPS2010_BDC0002.pnghttp://blog.libinuko.com/wp-content/uploads/2010/04/SPS2010_BDC0001.png


3/7

There are 3 security connection options in SQL Server Data Source:Connect with Users Identity => it will use running users credential to access to DB

server. This implies that you need to manage users access rights in DB server. Connect with Impersonated Windows Identity => it will use impersonated WindowsIdentity ; usually the Application Pool identity. Connect with Impersonated Custom Identity => it will use specified user/password

combination ; you need to define the Custom Identity separately.


4/7

Now, we already have the External List with the tables and views.

4. Select any table for the External Content types. In this scenario, I select RequestTbl formy data storage. Right click on the selected table, and SPD2010 will show you the availableoperations.

The External Content Types requires at least Read Item and Read Listoperation. In every operation you will need at least 1 identifier.

Follow the wizard to create an operation.


5/7

Dont forget that every operation requires at least 1 identifier. You can choose ID

field from the table.


6/7

You can also define the default view filter, for example, by default this external content typewill show only the first 100 items.

5. Publish the new content type by click Save button.
http://blog.libinuko.com/wp-content/uploads/2010/04/SPS2010_BDC0011.pnghttp://blog.libinuko.com/wp-content/uploads/2010/04/SPS2010_BDC0010.pnghttp://blog.libinuko.com/wp-content/uploads/2010/04/SPS2010_BDC0009.pnghttp://blog.libinuko.com/wp-content/uploads/2010/04/SPS2010_BDC0011.pnghttp://blog.libinuko.com/wp-content/uploads/2010/04/SPS2010_BDC0010.pnghttp://blog.libinuko.com/wp-content/uploads/2010/04/SPS2010_BDC0009.pnghttp://blog.libinuko.com/wp-content/uploads/2010/04/SPS2010_BDC0011.pnghttp://blog.libinuko.com/wp-content/uploads/2010/04/SPS2010_BDC0010.pnghttp://blog.libinuko.com/wp-content/uploads/2010/04/SPS2010_BDC0009.png


7/7

Now you already have new External Content Type. You can also create external content typeto call .NET CLR and WCF Service. Next , how to use the external content type in a list.

Related Posts:

SharePoint: Writing Custom Web Service for SharePoint in Supported Mode (part-2) SharePoint Designer: Visual Touch Using Using Conditional Formatting

April 10th, 2010 | Tags:External Content Type,Howto,Office 2010| Category:Office,Office

2010,SharePoint 2007
http://blog.libinuko.com/2011/08/31/sharepoint-writing-custom-web-service-for-sharepoint-in-supported-mode-part-2/http://blog.libinuko.com/2011/08/31/sharepoint-writing-custom-web-service-for-sharepoint-in-supported-mode-part-2/http://blog.libinuko.com/2011/05/04/sharepoint-designer-visual-touch-using-using-conditional-formatting/http://blog.libinuko.com/2011/05/04/sharepoint-designer-visual-touch-using-using-conditional-formatting/http://blog.libinuko.com/tag/external-content-type/http://blog.libinuko.com/tag/external-content-type/http://blog.libinuko.com/tag/external-content-type/http://blog.libinuko.com/tag/howto/http://blog.libinuko.com/tag/howto/http://blog.libinuko.com/tag/howto/http://blog.libinuko.com/tag/office-2010/http://blog.libinuko.com/tag/office-2010/http://blog.libinuko.com/tag/office-2010/http://blog.libinuko.com/category/office/http://blog.libinuko.com/category/office/http://blog.libinuko.com/category/office/http://blog.libinuko.com/category/office/office-2010/http://blog.libinuko.com/category/office/office-2010/http://blog.libinuko.com/category/office/office-2010/http://blog.libinuko.com/category/office/office-2010/http://blog.libinuko.com/category/microsoft-sharepoint/http://blog.libinuko.com/category/microsoft-sharepoint/http://blog.libinuko.com/category/microsoft-sharepoint/http://blog.libinuko.com/category/microsoft-sharepoint/http://blog.libinuko.com/category/office/office-2010/http://blog.libinuko.com/category/office/office-2010/http://blog.libinuko.com/category/office/http://blog.libinuko.com/tag/office-2010/http://blog.libinuko.com/tag/howto/http://blog.libinuko.com/tag/external-content-type/http://blog.libinuko.com/2011/05/04/sharepoint-designer-visual-touch-using-using-conditional-formatting/http://blog.libinuko.com/2011/08/31/sharepoint-writing-custom-web-service-for-sharepoint-in-supported-mode-part-2/

sharepoint external context type

Documents