Business Connectivity Services

learn more… | top users | synonyms

0
votes
0answers
84 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 ...
0
votes
1answer
168 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 ...
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 ...
0
votes
1answer
672 views

How to create an external list from an ECT using powershell

I have an External Content Type in my Metadata store and I want to create an external list using that ECT, using Powershell script. I tried to use $Web.Lists.Add() with SiteTemplate = "External ...
1
vote
0answers
182 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 ...
2
votes
0answers
493 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
0answers
121 views

Searching CRM 2011 records in Sharepoint 2010

I need to search Microsoft Dynamics CRM 2011 (onpremise or online) records in SharePoint 2010 (onpremise and preferably foundation but can go to enterprise if it is a must). I want to know from ...
1
vote
1answer
2k views

BCS External Item picker

There are two external lists like 'Project' and 'Task'. Task referencing project by using field ProjectID. I've created external content types. For 'Project' content type I've marked field ...
0
votes
2answers
886 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
525 views

How to connect Outlook to an external list, which uses external connector in DLL

The task: connect Outlook with the external list, which was created in Visual Studio and uses SAP connector (sapnco.dll). What I've done: Created this external list. I can see all information in ...
1
vote
2answers
629 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 ...
0
votes
1answer
1k 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
1answer
459 views

Using collection parameters with BCS entities results in “No constructor” error

I have a problem using collections for in-parameters with BCS entity methods and since I'm pretty sure you should be able to do this there must be some error that I haven't found. I have created a ...
2
votes
2answers
198 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
956 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
445 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
601 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
153 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
244 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
123 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
213 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
4k 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
300 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
69 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
234 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
911 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
993 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
561 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
536 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
2k 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
191 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
255 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
899 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
747 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
573 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
598 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
409 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
478 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
960 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
465 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
679 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
721 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
185 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(); ...