ಹೇಗೆ: Step by Step Creation of External List in SharePoint 2010

ಮೂಲಕ Udayakumar Ethirajulu , on May 10th, 2010

Q: SharePoint Guys talking about External list, BCS, ಇತ್ಯಾದಿ, which I never heard till SharePoint 2007, what is it?

BCS (Business Connectivity Services) is the successor of BDC (Business Data Catalog), but we have great features available in BCS. Now the data from External systems can be managed as a List in SharePoint and the data operations like create, edit, delete is made possible from the list.

wow…..That’s awesome ಜೆ

Let’s see step by step creation of External List in SharePoint. In this Example am using SQL Table as External Source.

Open the Site in SharePoint Designer

Click on External Content Types

Click on External Content in Ribbon to create new content type

Specify the values for Name and Display Name, ಕ್ಲಿಕ್ ಮಾಡಿ “discover external data sources and define options.”

In the Data Connections Screen, Click on Add Connections

Select the Data Connection type, here I am trying to connect to “Adventure works” SQL Database.

In the next screen specify your connection settings to the database and click OK.

Now the screen will list the database and its tables. Choose the required table and right click to select the operations to be performed on the list.

In Wizard choose the input parameter fields.

In Filters section, you can specify the filter for records.

Now the External Content Field will be looks like below with operations, fields & parameters.

Click on Create Lists & Form for the External Content type in Ribbon.

Specify the list details, if you need to have InfoPath forms for list forms, select “Create InfoPath Form”

Now Set Permission for Business Data Connectivity Services in Central Admin:

ಕೇಂದ್ರ ಆಡಳಿತ ಹೋಗಿ -> ಅಪ್ಲಿಕೇಶನ್ ನಿರ್ವಹಣೆ -> ಸೇವೆ ಅಪ್ಲಿಕೇಶನ್ಗಳನ್ನು ನಿರ್ವಹಿಸಿ -> ವ್ಯಾಪಾರ ಡೇಟಾ ಸಂಪರ್ಕತೆ ಸೇವೆ

ಅಂಗಡಿ ಆಯ್ಕೆ ಮತ್ತು ಮೆಟಾಡೇಟಾ ಅಂಗಡಿ ಅನುಮತಿಗಳನ್ನು ಕ್ಲಿಕ್.

Select the User and choose appropriate permissions.

Open the list in site.

Now the data can be accessed from SharePoint list.

Michael

ಫೆಬ್ರುವರಿ 10, 2011 ಮೇಲೆ 4:04 PM

Thanks for the detailed walkthrough.

I’m using SharePoint Foundation 2010 and I am successful in getting everything setup and configured using my admin account. My problem arises when I try to view the list with a non-admin account (user in the visitor’s group).

I’ve tried adding the “all users” group in the Metadata Store Permissions, but only the admin account can view the data.

Visitors received the following message: Cannot connect to the LobSystem (External System).

I don’t know if this matters, but I’m using SQL Server Express 2008 R2, as this a proof of concept farm.

ವಂದನೆ.

basma

ಜೂನ್ 3, 2011 ಮೇಲೆ 5:56 ಮೇಲೆ

Bonjour mon Problème, si des Relations de plusieurs tableaux ds ma base de Données et je veux faire un save en même temps, tu connais un tutoriel pour ce genre de problèmes

Merci

Rufino

ಜೂನ್ 14, 2011 ಮೇಲೆ 5:43 PM

Really great article.

kumar

ಜೂಲೈ 18, 2011 ಮೇಲೆ 6:47 ಮೇಲೆ

Thanks it works for me

blasak

ಇಂಗ್ಲಿಷ್ ವರ್ಷದ 9 ನೇ ತಿಂಗಳು 19, 2011 ಮೇಲೆ 4:18 ಮೇಲೆ

Bonjour,

trés bon tuto.

est-ce qu’il est possible de mettre les données qui sont récupérées dans une liste deroulante ? (par exemple : avoir un champs liste déroulante dans une liste personnalisé qui pointe sur la liste externe)

merci d’avance