Business Connectivity Services

learn more… | top users | synonyms

0
votes
2answers
976 views

Update and Create Problem with Adding Columns to an Existing External Content Type in SharePoint 2010

I used SharePoint Designer 2010 to create an external content type (ECT) that consumes and writes data to SQL Server. [Went through the process of connecting to a database table, then right-clicking ...
1
vote
1answer
942 views

User profile properties mapped to a BCS connection requires two syncs for new users

I have the User Profile Service Application up and running in a SharePoint 2010 farm. It is configured with two synchronization connections; one to Active Directory and a second to a backend database ...
1
vote
2answers
309 views

BCS Security Access Using Secure Store in code question

I have Secure Store and also Kerberos setup on my development and production farms. I am using Event Receivers to access BCS data. I have verified that if I simply impersonate a user that has access ...
1
vote
1answer
509 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 ...
9
votes
7answers
13k views

How to sync a SQL database with a SharePoint List?

I need to sync an already existing SQL Database to a SharePoint 2010 list. Two way sync would be great but one way sync is also alright. Any documentation in this regard would be of a great help. ...
1
vote
0answers
361 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 ...
0
votes
2answers
697 views

An empty pipe element is not allowed - the Powershell I copied fails

I am just trying to fix something to get my BCS external list created. All indications are that the server has too many rows for BCS so here is what I put into the Powershell IDE running as ...
1
vote
2answers
381 views

merge data in a sharepoint2010 user profile property sync with sql using BCS

i have configured the user profile syncing with my custom SQL table. i require 4 properties that are with 6 columns in the table & the scenario is i have to concatenate the strings of the 3 ...
0
votes
1answer
725 views

What are the BCS/External List Limitations for ECMA CSOM?

I cannot seem to find any documentation on this topic. Are there any limitations for what I can or cannot do with the JavaScript CSOM in SharePoint Server Standard 2010 External Lists as compared to ...
1
vote
2answers
177 views

BCS Date Only field on Update Form

I'm tasked with finding a method for Updating a field that is defined as Date in SQL, but rendered as DateTime through BCS (as there is no Date-only type). On the Update form, I only want a Date ...
2
votes
1answer
1k views

External list with friendly display names for columns

I have an external content type that I'm accessing through a .NET assembly. So I created a BDC model with Type="DotNetAssembly" (for now with just finder and specific finder operations). It works, ...
1
vote
1answer
1k 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
363 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 ...
0
votes
2answers
1k views

SharePoint 2010 Foundation BCS Errors

We have an BCS issue on a Sharepoint Foundation multi-tenant farm. Users are able to create external content types using SharePoint Designer 2010, but when they browse to the list of external data we ...
1
vote
0answers
60 views

Getting error while creating ECT using WCF that is hosted in SharePoint through SharePoint Designer [closed]

I am getting error while creating ECT using WCF that is hosted in SharePoint through SharePoint Designer. The error message is Object Reference. When I Host this WCF then I am able to create ECT ...
0
votes
2answers
478 views

External List and jQuery

I have an external list that I want to hackup with jQuery. If i put a simple alert in document .ready, it fires, and THEN the SharePoint progress spinner shows up, and then the data is returned - long ...
1
vote
0answers
136 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
192 views

Do not load data in design mode of webpart

I have custom webpart which gets data from external database using BCS. When I add the webpart in a webpart zone, it queries the BDC to get data so it take time to insert webpart. I only want to query ...
2
votes
0answers
108 views

BCS and External List: Validations and Business Logic

I have been able to define an External List through a WCF Service. This works well, but I am now moving onto more advanced scenarios - I would like my Create, Update and Delete methods to implement ...
1
vote
0answers
170 views

Does BCS support creating an external list from an existing list in a different web application using List Web Services

I have sharepoint 2010 farm where there are multiple web applications. I am trying to understand BCS and its capabilities. This is the structure I have :- Web Application A > Site Collection > ...
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 ...
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
2answers
219 views

Update CRM from User Profile

We currently have Sharepoint 2010 setup to use AD to get useraccounts, and a BCS connection to provide extra information to the User Profile of users. The data from AD is very basic: only username and ...
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
778 views

External list Reading items very slow

I am trying to retrieve all the columns from External list from sharepoint 2010. Em using the below code SPListItemCollection collection = list.GetItems(query); foreach (SPField field in ...
3
votes
2answers
991 views

TFS-SharePoint integration

I am currently investigating how to push data from Team Foundation Server to SharePoint. Are there any connections available out of the box? Any useful online references? Third party tools?
1
vote
1answer
903 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
2answers
404 views

How can i use External Content Types - SQL Authentication with NO Kerberos

I'm in the process of using ECT and the data is in a sql sever. Before i get started is this possible with no kerberos existing in this current environment. So the service where SP resides is ...
0
votes
3answers
1k views

Importing data from Excel/Word into a SharePoint List

Is it possible to import data from an Office Excel or Word file into a list in SharePoint (specifically SharePoint Online)? I have imported data from SharePoint lists to Word files.
1
vote
2answers
485 views

ReadList with Association for External Content Type via Visual Studio

I would have thought this is a common requirement but I just cannot seem to find any resources addressing this. I have several Entities defined along with Associations between them. They deploy ...
1
vote
1answer
411 views

How to display a list across multiple sites?

I want to be able to create a customized list, "Test", on my main page, "Home" of SharePoint. I want to be able to link to that custom list, "Test", onto another site in the same collection, ...
2
votes
1answer
178 views

Should I Use Business Connectivity Services or Not in This Specific Scenario

I'm currently working on a SharePoint Standard 2010 project. I would have preferred to use the User Profile Service to sync with AD to populate employee details, but our AD doesn't have much ...
0
votes
1answer
220 views

External list in SharePoint 2010 with unique item permissions

Is there any way to set permission for bdc items within external list?
9
votes
3answers
940 views

FAST Search Security Trimming of non Windows External Content Types

We have integrated a back-end web application into SharePoint 2010 using the BCS and the OOTB Web Services connector. The data in the backend system is protected by ACLs and we need these ACLs to be ...
2
votes
1answer
1k views

External Content Type Search not returning results

I have configured my 2010 External Content Type for search by adding the RootFinder property to the ReadList method. I have also added the ShowInSearchUI property to the LOB entry. I then set up my ...
0
votes
0answers
177 views

Sharepoint 2010 Fast Search Blobs listing from external database [closed]

I am working on a search engine to crawl documents from a Database. The blobs are stored as BytesArray into SQL server 2008 R2. The files types are PDF, Doc and Docx mainly. I have to do that with ...
0
votes
1answer
35 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
1answer
636 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 ...
2
votes
0answers
318 views

Business Connectivity Services over OData : caching and paging?

I'm planing a new application for a customer that requires to read data from an external system. Basically, the external system will expose a read-only OData service (to be defined actually). The ...
1
vote
0answers
402 views

Association created by VS does not work

I am trying to create several ECT with Associations between them. Been playing around with several tools and reading/watching a handful of tutorials. I have gotten my pieces to work when playing ...
0
votes
1answer
310 views

BCS StreamAccessor method

I've implemented a StreamAccessor method for my BCS indexing connector. My source is an SQL database which has a table that contains records. Some of the records have links to files. My problem is ...
0
votes
1answer
753 views

External Content Type and Entity Framework

I have been struggling with this project for about two weeks now. I have successfully created an External Content Type using Visual Studio and have deployed it. I was also able to use the SharePoint ...
0
votes
1answer
378 views

bind item id to custom webpart in dispform.aspx

I've created a custom webpart that shows me some details of a dossier. I've added a DossierID property like this: public Guid DossierId { get; set; } This identifies the dossier from which I want ...
2
votes
1answer
3k views

CAML and External List - pass parameter to ReadList (finder) method

I have a Finder method defined on an External Content type (created with Visual Studio). Whan That method receives a parameter. So the method is something like ReadList(string partnerName). I have ...
0
votes
3answers
513 views

SpecificFinder not called on Sharepoint 2010 BCS

I have an external content type for which I created a BDC model with a LobSystem of type dot.NET assembly. I have a SpecificFinder and a Finder method defined. I also have an external list created on ...
0
votes
3answers
199 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
0answers
170 views

Read sharepoint external-list items

I am working with sharepoint 2010. I have an external list. I need to retrieve the list items from the external list for which i am using the following code below. SPQuery query=new SPQuery(); ...
2
votes
1answer
414 views

How to customize profile pages for external content type search results?

I have set up the SP 2010 enterprise search to include searches in line-of-business data. (In my concrete case that would be data from Dynamics CRM 2011 but I hope that is not relevant). I have ...
1
vote
4answers
1k views

BDC to BCS Application Definition Upgrade

I'm trying to perform an upgrade of a SharePoint 2007 environment to 2010. Our plan is to move to entirely new hardware and do a content database migration. In such a scenario, it seems that BDC ...
1
vote
0answers
587 views

Navision + sharepoint.

For the last couple of weeks we have been struggling with an issue that we could not solve. This issue are concerning Sharepoint and Navision 2009. So we really hope that you would find a solution. ...