0
votes
1answer
107 views

Is it possible to link existing Sharepoint 2010 lists to SQL server databases?

I created a SQL server database and added a table to it. Then I used Sharepoint Designer 2010 to create an external Content Type using this table. Now I can alter the according Sharepoint list which ...
1
vote
0answers
35 views

Are third party solutions really that superior to BCS?

Let us assume it is my task to establish a bidirectional connection between a SharePoint List and a SQL-database. According to Paolo Pialorsi's Developer Manual for SharePoint 2010, BCS (Business ...
0
votes
1answer
82 views

External Content Type = access denied

I have an External Content Type created. It connects to a SQL Server 2005 db, using "Impersonate Windows Identity" authentication, with an account over in Secure Store Service. I've got a Read List ...
1
vote
0answers
18 views

BCS: Allow deletion of rows only under a given condition

I created a BCS Model and external data type for a MS SQL table. I added a delete action, too, and it is working as expected. But now I want to allow the user only to delete items, that aren't ...
0
votes
1answer
394 views

Create a SharePoint 2010 BCS connection to Web Service with Visual Studio only

While I have been using SharePoint for quite some time I have not used BCS at all (except way back when I took some training). What I am looking for are steps to create a BCS connector to an external ...
5
votes
2answers
630 views

Updating Active Directory User Information from Sharepoint User Profiles BCS Data

I am investigating the possibility of updating Active Directory user account information from Sharepoint 2010 User Profiles. I am aware that there is functionality to synchronise data from the User ...
1
vote
1answer
196 views

SharePoint 2010 - Create related hierarchical fields from external source

Is there a way to create two related columns as a custom field type in SharePoint? For example, can you develop a custom field type named CustomerOrder that consists of two related lookup columns ...
2
votes
2answers
711 views

Deleted item still showing up in search results if only doing Incremental Crawls

I'm trying to set up a Sharepoint search service using a Content Source based on an external BCS data source. In the BDC model, I implemented the operations I needed, adding a SpecificFinder, an ...
0
votes
1answer
215 views

Search External Content type not returning all records

I have a sql view that returns 449 records. I have setup my external content type to point to this view and have implemented via SPD the read item and read list operations. I have created the ...
2
votes
1answer
1k views

External List from External Content Type: missing and/or error

I've created an ECT w/ Read List and Read Item operations using SharePoint Designer, saved it, and given myself permissions. The ECT's external data source is a WCF service. When I try to create an ...
1
vote
1answer
134 views

External List not returning values

I have an external list which isn't returning any values. The list uses an external content type, which gets information from a SOAP service. After creating the content type using a read item and ...
2
votes
0answers
420 views

LastModifiedTimeStampField not working in incremental crawl (SharePoint 2010 + BCS + FS4SP)

I'm using a custom BCS .Net Assembly connector with my BDC model but can't seem to get the Incremental Crawl working correctly. It keeps doing a Full crawl, or at least it seems that way because the ...
1
vote
2answers
535 views

Deploy BCS profile page without SPD

Is it possible to deploy a BCS profile page via a WSP? Did anyone try this including settting the default action on the external content type? All references I can find explain how to create a ...
2
votes
1answer
2k views

How To Define Specific ReadItem Finder with List View in External List?

I have an external list which is using the BCS to pull data from a custom database. This database has several views which have the same column structure and several that do not. I have been adding ...
1
vote
1answer
402 views

How to Set Input Filter Programmaticlly in BCS

I have a Method in Entity which takes 2 input filters. Now I want to set a value in this filter. How can I do that? I already got the collection of Filters using the GetFilters() method of the ...
1
vote
0answers
143 views

Use Secure Store Credentials to connect to database with Windows Authentication in Visual Studio solution?

Background: I have an external content type that has been developed in a Visual Studio 2010 solution. This content type is based mostly off elements in a database that are accessed via stored ...
1
vote
1answer
1k views

How to call Finder Method with Parameters using BCS Runtime Model

Hi i have created BCS model which use secure store service for authentication to External system.Everything works fine using out of box external list and BCS webparts but i want to create custom ...
1
vote
1answer
279 views

Specify external content type lookup for deployable list?

I have a ListTemplate which is being deployed with Visual Studio. Is it possible to make a reference from this template to an external content type that runs on the farm? Or must I manually add these ...
0
votes
1answer
2k views

Error with External Content Type List: “Unable to display this web part”

I have deployed an external content type to my local Sharepoint 2010 Server using a Visual Studio solution. The deployment appears to work. I can view the details of the content part in the central ...
3
votes
1answer
2k views

Sharepoint Incremental Crawl and BCS

I have a BCS connector (partial BDC Model posted below) and I'm noticing some issues with Sharepoint crawls. My full crawl seems to work perfectly, but incremental is pulling back the same number of ...
1
vote
1answer
1k views

Connect ECT to SharePoint List in InfoPath?

I'm trying to create a list in Infopath 2010. I'd like one of the fields to be a drop down list that connects to an external content type list. It doesn't show any of the External Content Type Lists ...
0
votes
1answer
237 views

External list in SharePoint 2010 with unique item permissions

Is there any way to set permission for bdc items within external list?
0
votes
1answer
688 views

BCS issue: CalculatePermissionsForCurrentThread

I have a BCS model which is causing problems in the production environment. Everything works fine from within SharePoint context, but outside the context (a WCF service to be precise) I'm getting ...
0
votes
1answer
37 views

ValidateEntitySecurity failed on multitenant BSC installation

I've got a multitenant BCS service setup. It all seems to work; I've imported my model and it properly lists the entities in the model. But when I try to create an external list based on the model, ...
0
votes
3answers
212 views

BCS in a multi tenant scenario

I'm planning on creating a BCS layer which will be used in a multi tenant scenario. The plan is as follows: multiple clients will all get a SharePoint site. They will sync data from their ERP into a ...
1
vote
1answer
558 views

BDC hide identifier in new item form

I'm working on a simple bdc model in visual studio. i use the entity framework to access the data on the database. Everything works fine (all CRUD operations) but in the "New item" form i have to ...
0
votes
1answer
550 views

BDC - User profile sync won't sync with sql server/wcf service

I created simple web service which implement 2 methods (one (no parameters) return list of object, another (one parameter - upId int) returns simple object with 3 properties (bool, string, and int ...
1
vote
1answer
234 views

The operation(s) generations creates an SQL query which exceeds the length limit in Business Data Connectivity Metadata Store

I am trying to add a table from a SQL database as an external content type. When I do so I am getting the following error: The database table has 188 columns (I did not design this legacy system. I ...
5
votes
2answers
633 views

Use custom page in _layouts for display item form

I was wondering if I could acheive the following. I have a custom application page living in _layouts which displays an entity based upon an external content type item. For external lists using this ...