Business Connectivity Services

learn more… | top users | synonyms

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

Multiple filters in ECT External Item Picker in SharePoint 2010 BCS?

I am using SharePoint 2010 BCS to connect to a SQL Server database table and created an External Content Type (ECT). In this ECT you can specify a filter and I have done that, and I mapped the ECT to ...
1
vote
1answer
486 views

External Content Types are not available. Contact your system administrator - BCS - User profile sync

I'm trying to setup a BCS connection from a SQL view -> user profile properties. I've created the external content type and got the right view. I also set the "set object permission", checked all ...
1
vote
1answer
72 views

External list edit form not shown

I created an external list using Business Connect Services. I have added operations for read list, read item and update item. Then create external list using external content type. I can display list ...
1
vote
1answer
58 views

BCS Question (changing data source of a web service)

We are going to be building a Web Service (on-premise) to connect our data to SharePoint online (o365) using BCS and OData. If we migrate our database from one location (in Oracle) to another (e.g. ...
1
vote
2answers
774 views

Why aren't my result types working with managed properties?

I'm having trouble getting Result Types working in SharePoint Search. I've defined a result source for one of my BDC datatypes, plus a result type that matches everything from that result source. ...
1
vote
2answers
180 views

Query External Data using BCS

I'm using SharePoint 2013 and I'm developing a webpart that has to query an external data and show the results. I cannot create external list due to the fact that my external table has more than ...
1
vote
1answer
238 views

Item-level security possible with OData external content type?

I've created an External Content Type which uses an OData service as it source, and I created a content source in the Search Service Application in order to crawl this data. This works fine. However, ...
1
vote
1answer
194 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
337 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
462 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
45 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
2k 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
940 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
170 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
203 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
679 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
494 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
1answer
256 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
305 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
1k 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
581 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
496 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
256 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
934 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
665 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
501 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
2k 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
471 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
607 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
896 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
433 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
160 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
4k 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
833 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
12 views

SharePoint 2013 BCS and SQL Views

I have setup my SharePoint 2013 publishing site with BCS and Secure Store so that users can access multiple external lists within the site and if they have the correct permissions setup in Secure ...
1
vote
0answers
20 views

Sharepoint 2013 accessing external list in workflows

I have created an external list using WCF connections. I have in that list all the information that I need. Now I need to access that data from another list workflow(sharepoint 2013 platform ...
1
vote
1answer
77 views

Business Data List web part customization?

I have a question with business connectivity services in SharePoint 2013. I have a connection with CRUD access using an SQL server. The list view displays all records, but I have use the Business Data ...
1
vote
0answers
15 views

After importing, src attribute is removed from img tag [closed]

This is SP2010. I am using BCS and an external list to read in HTML from a non-SharePoint CMS. The HTML includes typical rich-text content, including images. Looking at the external list text, I can ...
1
vote
0answers
86 views

BDC types not coming up as crawled properties in SharePoint 2013 search

I am trying to setup search in my SharePoint 2013 site, using BCS, connecting to a .Net assembly which is exposing the types. The first time I deployed the solution, the exposed types came up as ...
1
vote
1answer
31 views

Crawled properties missing for Business Data source

We've implemented and crawled a Business Data Connectivity Service data source. I can find the items based on the values in their fields, but when I look at Crawled Properties, there is only the ...
1
vote
2answers
33 views

Using External Data in SharePoint 2013

Hi i am new to SharePoint, i have been given a requirement and i am not able to find the right approach. We have a SharePoint portal which keeps track of employees details, very recently we have ...
1
vote
0answers
34 views

Select Default Filter in BDCM File

When working with Business Connectivity Services (BCS) and Business Data Connectivity Model (BDCM) files, does anyone know in the code where to set the "default" Filter and hide the option? Right ...
1
vote
1answer
28 views

External content types in sharepoint

I have an external list based webpart with 5 wild card filters. when I searched using one filter the required item is displayed but the same item is not displayed using other filter. For example if an ...
1
vote
1answer
236 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 ...