Business Connectivity Services

learn more… | top users | synonyms

1
vote
2answers
1k views

How to connect multiple external tables into one SharePoint list to perform CRUD operations

I am working with SharePoint 2013 and I have a requirement where I have to perform CRUD operations on multiple external tables (SQL Server) with SharePoint in one List and vice versa. I am able to ...
1
vote
1answer
132 views

Search in Custom indexing connector with AttachmentAssociator property in AssociationNavigator

I have a custom indexing connector with Entities associated via AssociationNavigator method. In order for Search (of SharePoint 2013) to crawl the associated entity, we need to set either the ...
1
vote
1answer
281 views

How can I create a multi-valued refiner for a Business Data Catalog external content type?

This question regards a SharePoint 2010 instance using vanilla search. I'm currently using a Business Data Catalog to pull records from a database table with an end-goal of displaying the records in ...
1
vote
1answer
370 views

Error while creating a new customer via BCS from within a web part

This is my first time that I am using BCS via a web part and in general. this is my code and I am getting the following error: The given dot notation 'CustomerID' refers to a node in Type Descriptor ...
1
vote
1answer
43 views

Limiting a view based on authentication by writing qualified username

This article http://www.thesharepointbar.com/?p=340 how to limit a read on a user in BCS, but we can't find the correct syntax for fba-users. (MS Quote: If the login mode for the user is claims-based, ...
1
vote
1answer
1k views

Can you use BCS External Content Types in conjunction with Product Catalogs in 2013?

Does anybody know if it is possible to use an External Content Type as the basis for a Product Catalog in SharePoint 2013? So if we store a load of Product data in a database are we then able to ...
1
vote
1answer
703 views

403 Error connecting to ODATA via External Content Type with SharePoint

I have a tenant on SharePoint Online (the new 2013 version). In that tenant, I have a Project Online site collection. Project Online hosts a very nice OData endpoint at ...
1
vote
1answer
149 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 ...
1
vote
1answer
187 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 ...
1
vote
2answers
600 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 ...
1
vote
1answer
446 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 ...
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
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 ...
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 ...
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 ...
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, ...
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
3answers
254 views

SharePoint foundation and BCS

I am testing SharePoint 2010 foundation with bcs to access one of my sql tables. I created a list with filters on some fields (wildcard and limit types) But unfortunately, when I display (browser) ...
1
vote
1answer
1k views

External List Error : The query against the database caused an error

I got an SQL Server 2008 R2 and a SharePoint Server. I have put up a BCS between the two servers. Reading data through a External List. This worked fine yesterday. But to day I got this error: The ...
1
vote
2answers
807 views

External list with bulk amount of data does not work properly

I have created and external content type to fetch data from a SQL table. The table currently contains 8000 records. So when I create an external list from that content type the list does not display ...
1
vote
3answers
1k views

Error while import resource file Business Data Connectivity

I am trying to use powershell for importing a resource file in Business Data Catalog but I keep getting the following error Import-SPBusinessDataCatalogModel : The root element of a valid Metadata ...
1
vote
2answers
1k views

SQL Hardening, BCS, and ECT (SharePoint 2010)

Currently running into some errors when trying to setup External Content Types with SharePoint 2010. The goal is simple which is to connect to a SQL Server and pull information into SharePoint to an ...
1
vote
1answer
593 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 ...
1
vote
2answers
459 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 ...
1
vote
2answers
1k views

How to Bind Data to Traditional ASP.NET Controls in SharePoint Foundation 2010?

First off, my background is ASP.NET Web Forms. I'm sure this is very simple but I'm quite new to SharePoint. We're running SP Foundation 2010. I'm going to build a WebPart in VS.NET 2010 and deploy ...
1
vote
2answers
407 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
3answers
1k views

Accessing External List Items Programmatically

The following bit of code throws an Unauthorized Operation exception when I try to enumerate the items in the list. Any ideas? SPSecurity.RunWithElevatedPrivileges(delegate() { ...
1
vote
1answer
576 views

Custom View Header Rendering Twice on External List

I'm starting to work with custom view stylesheets on an external list. I am finding the header is rendering twice - once upon initial page render and again after the data is returned from the server: ...
1
vote
2answers
728 views

BDC external type with dropdown data entry

I would like to be able to have a BDC entity setup such that when you create a list from the external content type the new item form automatically comes setup with a lookup field for one of the ...
1
vote
1answer
400 views

Populate SharePoint Group from BCS External List

I have a BCS External List that is giving me the data that I want. Currently that data is usernames (domain\username). Is there anyway to sync/import/connect an External List with a SharePoint ...
1
vote
1answer
156 views

SPBuiltInFieldId structure for BCS - is there any const for “BdcIdentity”?

For SPListItem's built-in field values we have SPBuiltInFieldId class with many guids - SPBuiltInFieldId.Title and so on. Now I am working with BCS and I can't find any built-in object for ...
1
vote
3answers
3k views

Problems configuring External List on Sharepoint Foundation 2010

I have created a new database on MS SQL SERVER SHAREPOINT instace that contains two simple tables. Then I tried to link values defined in these tables by implementing External Content Types using ...
1
vote
1answer
822 views

Exporting Application Model from SP Designer 2010 to Visual Studio 2010 BDC Model Project

I've created an Application Model in SP Designer 2010 and exported it (XML file). I'd like to use the definition in a Business Data Connectivity Project in Visual Studio 2010. Is there a way to ...
1
vote
1answer
57 views

How to do a Filter in a BCS External Data picker

I am using an OData web service with BCS (testing with Northwind) and I would like to define some filters when using the External Data picker. I'd like to be able to have a drop down that then ...
1
vote
0answers
20 views

Keep SQL Connection Alive during ReadItem

Is there any way to keep a connection open during the ReadItem process or is there a best practice around this? Basically if i'm calling ReadItem in BCS 100K times, how can I streamline that ...
1
vote
1answer
205 views

REST API ItemCount on oData BCS List

I have a list generated from a BCS oData provider and I am attempting to get the number of items in the list so I can generate a $top on my request rather than bring back only the 100 item generic ...
1
vote
0answers
97 views

Authentication between SharePoint O365 and external OData web service

We are using SharePoint Online (O365) with ADFS. We are also building an on-premise OData web service to provide data into the cloud as an External Content Type. We understand generally how to use ...
1
vote
1answer
234 views

Fast Search for Sharepoint 2010: Incremental Crawl Memory Leak

Background My organization has been attempting to use FAST Search for Sharepoint 2010 as a search solution for our DMS. I am currently utilizing a .Net indexing connector to index a database of ~ 8 ...
1
vote
0answers
21 views

Sharepoint Business Connectivity Service PrincipalIdentityNotMappedException

Today all external lists on farm suddenly stopped working and I cannot configure any BCS application in central admin configuration. There are ...
1
vote
0answers
38 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 ...
1
vote
1answer
301 views

Throttled While Crawling Large External Databases

I created an ECT using SPD2013 last week. It connects to a SQL DB while using the Secure Store to impersonate a domain user for a particular DB View. Last week, I used my personal (farm admin) ...
1
vote
1answer
88 views

SharePoint 2010 - BCS secondary columns in viewedit.aspx

I was wondering if this has happened to anyone and if anyone can suggest a fix is. | SharePoint 2010 | Top level site | Administrator permissions I had a number of BCS connections to a document ...
1
vote
0answers
87 views

namespace on external content type

I have noticed that when moving BCS lists/external content types from my development computer to our production server, it keeps the namespace of my development computer. For example, all the ...
1
vote
0answers
19 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 ...
1
vote
1answer
65 views

Kerberos + SharePoint

Kerberos - the beast of SharePoint - has been configured and is creating tickets on my test environment WFE. I also had RevertToSelf for the BCS service application turned on. I am able to create an ...
1
vote
1answer
60 views

Show Atom feed as external content

I hope that this is the correct place to ask this. I have a site that "spits out" an ATOM feed/seedlist that I want to show in SharePoint as an external content type. So far I know that this is done ...
1
vote
2answers
496 views

Using BCS and WCF to add external data to sharepoint index

Being completely new to the whole SharePoint environment, I am having trouble understanding exactly how to crawl external data into a SharePoint index. What I need to accomplish is that a user can ...
1
vote
1answer
60 views

How to create a External Content Type equivalent to a Document Set?

I'd like to create an External Content Type either inheriting from or equivalent to a Document Set. I'm not finding any good examples and Document Sets are derived from folders, so the API must be ...
1
vote
0answers
40 views

BCS entity code update

I have a problem with the develop with BCS and the Search in SharePoint 2013... I develop an entity that connect with UCM documents and it incorporates in search service (crawling, indexing, etc) The ...
1
vote
1answer
521 views

SharePoint 2013 Result Sources - Combining BCS Content Source with SP Content Source - Only See SP Content Source

Scenario: Content Source 1: Standard SharePoint Local Sites Content Source 2: BCS Application Seek to create 1 Unified Search Result from a Common Result Source.. I have been trying to combine a ...