BCS External List Limitations
-
quinta-feira, 1 de setembro de 2011 10:10
Hi All,
Going thru BCS in one of the application but found following limitations with.
Any body out there who could suggest me with something or say any use of third party tool
BCS External List Limitations
1) Workflows cannot be configured on External Lists
2) Cannot create Information Management Policies
3) No versioning or version history
4) No Inline Editing or Datasheet View
5) No ratings
6) No ability to Export to Excel, Create Visio Diagram, Open with Access or Open with Project
7) No REST access through ListData.svc to External Lists
8 ) No RSS Feeds
9) No Item Level Permissions
10) No item or field level validation
11) No Lookups
12) No attachments
Todas as Respostas
-
sexta-feira, 2 de setembro de 2011 09:38
Hello.
BCS is not the only one method of accessing data from external sources.
You can use methods without these limitations such as:
-completely custom webparts developing
-standard storing data inside sharepoint(not in external source).
The best choice depends on your goals. Every method have different cost, time and business value for customer.
Ivan Gorbadey. Sharepoint 2010 MCPD & MCITP.- Marcado como Resposta Emir LiuMicrosoft Contingent Staff, Moderator sexta-feira, 9 de setembro de 2011 10:53
- Não Marcado como Resposta John Hartford sábado, 10 de setembro de 2011 12:19
-
quinta-feira, 24 de novembro de 2011 12:52
I see Limitation number 7.
No REST access through ListData.svc to External Lists
Should I create a custom WCF with operations in it ?
Or any other alternative that you would suggest.
-
segunda-feira, 28 de novembro de 2011 06:56If you have to use External List, then make call to your database to add, edit, delete the items from the external list using custom webpart. It will directly reflect to your External List.
-
sábado, 18 de fevereiro de 2012 03:15
You could create an Enttity Framework Model in one project. Then in a second project in the same solutin, create a wcf data services that exposes the EF Model as rest. That can be deployed to SharePoint. In a third project in the solution you can create a BCS .net assembly connector that uses the EF Model.
This will expose an EF Model using both rest and External Content Types in sharepoint.
-
segunda-feira, 28 de maio de 2012 20:43Can't we use workflow & event receivers with external list?
-
terça-feira, 29 de maio de 2012 07:47That's correct, Amit, you can't use them.
Kind regards,
Margriet BruggemanLois & Clark IT Services
web site: http://www.loisandclark.eu
blog: http://www.sharepointdragons.com
-
sexta-feira, 15 de junho de 2012 19:58
You wrote: standard storing data inside sharepoint
I am impressed that you would even write that down. Yes, I guess we could trash all of our external systems and store EVERYTHING inside of SHAREPOINT, I just was not smart enough to realize that.
-
segunda-feira, 18 de junho de 2012 07:24
Let's keep it positive, Ivan didn't mean to imply that you should take down all your external systems and migrate the contents to SharePoint. On a related note, the following Wiki page discusses benefits of storing data in a database, list or external list: http://social.technet.microsoft.com/wiki/contents/articles/9638.sharepoint-2010-best-practice-keep-relational-data-in-a-database-or-migrate-it-into-a-custom-list.aspx To be clear, those options don't prevent the use and usefulness of other legacy systems or storage types.
Kind regards,
Margriet BruggemanLois & Clark IT Services
web site: http://www.loisandclark.eu
blog: http://www.sharepointdragons.com
.png)
