Business Connectivity Services

learn more… | top users | synonyms

0
votes
2answers
511 views

replication of document libraries in sharepoint 2010

In sharepoint 2010, Need to have a document library in a site and another document library in another site and the 2nd document library should be an exact copy of the 1st document library(with the ...
0
votes
1answer
168 views

How to connect between two document libraries in different webapplications using BCS?

In Sharepoint 2010 , How to connect between two document libraries in different webapplications using BCS?. The webapplications has sitecollections and sites in it and the sites are getting created ...
0
votes
1answer
139 views

Sharepoint 2010, BCS and inner join

We have external content type based on a table in database. It was created using SharePoint designer. Unfortunately one of the column is referencing another table, which is dictionary - primary table ...
0
votes
1answer
262 views

KeywordQuery to search by BCS Entity Name and Namespace

I have built a custom search connector to crawl and index external content types. That works quite well. I find the index entities in the search center as well through using the API of ...
2
votes
1answer
611 views

Paging and sorting in sharepoint BCS

I saw this post about Paging and sorting and tried to do simiral thing in my project. But failed to do so. Everything works fine apart from instead of getting the value i get the parameter name. ...
1
vote
2answers
3k views

BCS and Filtering/Paging - External List vs Business Data List Web Part

I am trying to learn BCS for use in an in-house application. To keep it simple at this point I am limiting myself to a single table even though the table has FK references for grouping and some ...
1
vote
1answer
538 views

SharePoint BCS with SOAP web service using custom authentication

I'm very new to using BCS in SharePoint 2010. I'm not really sure how to go about my problem or if it's even possible without coding a custom solution in Visual Studio using .NET. I have a SOAP web ...
0
votes
0answers
80 views

Auto-generated code for “Using”, “SQLConnection”, “ReadItem”, “ReadList” methods

I am beginner in SharePoint 2010 development. and doing following lab: Module 6: Accessing external data with Business Connectivity Services in SharePoint 2010 ...
1
vote
0answers
163 views

Can't get Custom BCS Connector with filters to work

I am trying to create a BCS connector in Visual Studio that connects to a WCF service. I first used an parameterless GetAccounts method as the source for the ReadList method, and the wanted to add ...
0
votes
2answers
1k 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 ...
2
votes
1answer
1k 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
345 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
546 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 ...
10
votes
7answers
14k 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. ...
2
votes
0answers
402 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
772 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
422 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
850 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
185 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, ...
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
392 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
61 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
541 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
142 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
211 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
116 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
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
224 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
868 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
1k 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
983 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
454 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
515 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
455 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
186 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
233 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
988 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
192 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
36 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
680 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
351 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
431 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
320 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
839 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 ...