Business Connectivity Services

learn more… | top users | synonyms

1
vote
2answers
197 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 ...
1
vote
2answers
2k views

working and filtering with large external lists using BCS

I have a large set of orders (about 7500) that I want to show in my SharePoint site. I'm using BCS because I also want to link the orders to documents. I also have an external list with these ...
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 ...
0
votes
0answers
891 views

BCS custom connector and incremental crawl with search server express not working

we are currently developing a generic connector framework to access JSON-resources from an HTTP-Server. As the connector should not depend on a data model it heavily relies on DynamicType. As there ...
1
vote
1answer
430 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
585 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
150 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
240 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
122 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
206 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 > ...
2
votes
2answers
3k views

How to create an external List on SharePoint 2010 using MySQL table

I have a MYSQL database that contains customer related data from sugarcrm while a few order related data is stored in the MSSQL server. So far, I have been able to create an external list for the ...
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
293 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
3k 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 ...
1
vote
0answers
65 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 ...
3
votes
2answers
233 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 ...
7
votes
2answers
854 views

SharePoint 2010 User Profile Synchronization: BCS + WCF

I'm here because I'm trying to implement a scenario of user profile synchro with bcs connecting to wcf service. Here is the context: A remote web service is returning a full list of employee infos. ...
1
vote
1answer
965 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
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
2answers
519 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 ...
1
vote
1answer
522 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, ...
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
190 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
248 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
795 views

There are no addresses available for this application. Business Data Connectivity

I can't get the new Business data Connectivity Service i've just created to work. It says that it started, and i proceed to an iisreset as said in a lot of blogs, but it still doesn't work. Do you ...
0
votes
1answer
734 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
1answer
561 views

custom paging and sorting in BCS

I'm creating a custom .Net Assembly connector. I have to show a lot of data, so I want to page and sort that. I've already created parameters in my model for that: StartRow PageSize SortField In ...
1
vote
2answers
557 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 ...
2
votes
0answers
389 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
463 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 ...
2
votes
1answer
2k 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
1answer
939 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
448 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 ...
3
votes
1answer
655 views

Paging and sorting with BCS - Is it really possible?

I'm trying to add paging on an external list and so far it does not work 100%. The best references I could find (that actually... kinda... work) are these: Paging and sorting with BCS Paging and ...
0
votes
3answers
677 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 ...
1
vote
0answers
184 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(); ...
0
votes
0answers
199 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
40 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, ...
1
vote
2answers
4k 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 ...
3
votes
1answer
5k 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
1answer
328 views

BCSLogin failed

I got a problem when using BCS in SharePoint Foundation 2010. I'm not able to let other users see the BCS content. I tried all the possibilities I found in internet (giving permission to the users in ...
1
vote
0answers
671 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. ...
0
votes
3answers
219 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 ...
2
votes
1answer
430 views

Dropbox access from SharePoint

I am new to Dropbox, and I'd like to know if there is an easy way to access Dropbox content from SharePoint 2010 / Office 365. For example, should I consider BCS? Or is there a way to work with the ...
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, ...
5
votes
2answers
321 views

How to dynamically generate Business Connectivity Services

We are trying to deploy a Business Connectivity Services(BCS) Model solution where the properties in the model depend on the structure of the data exposed by a web service. Ideally the BCS Model ...
1
vote
1answer
464 views

How to Stop ECT Action from Using ActionRedirect

If I create an Action on an External Content Type with a URL such as this . . . ...
1
vote
0answers
151 views

updating item from an external list

I'm trying to update an item in my external list i'm using BCS and LINQ to query. That's my Update method : public static void Update(Customer customer, int parameter) { ...
3
votes
1answer
559 views

Access denied for BCS method in e-mail event receiver

I have a SPItemEventReceiver which does some stuff with an external list when a document is uploaded to a DocLib. I now wanted to have it also run when an e-mail is sent to that DocLib. I could have ...