Business Connectivity Services

learn more… | top users | synonyms

1
vote
2answers
3k views

Access denied by Business Data Connectivity on Setting Metadata Store Permissions

When I try to configure Metadata Store Permissions I keep getting this error I am the Farm Administrator and have full access on Sharepoint to start with. Now as I drilled down further looking at ...
1
vote
3answers
2k views

How to sync a Sharepoint 2010 list with data from a table in SQL server

I have a table in SQL server 2008 and a list in sharepoint 2010 that has a few columns from this table and a few other unrelated columns as well. This SQL server table keeps changing and I want to ...
1
vote
1answer
73 views

Read/Write capability in BCS

Can someone tell me what exactly does "Read/Write Capability" means in Business Connectivity Services for SharePoint 2010? I read it somewhere that this is a new feature in 2010 which was not present ...
1
vote
1answer
1k views

Synchronization of SharePoint 2010 List with SQL Server Table

I need to create a list such that the values on the list can be stored in SQL table as well. I need to attach workflows to the list item as well. Its a simple workflow with two approval process ...
1
vote
3answers
4k views

Setting Value of External Field in Code

I cannot seem to find any examples of how to set a BCS External Field via code. I have two lists that both have a BCS field named "Industry". When an item is created in List A I need to create a new ...
1
vote
2answers
500 views

StreamAccessors >> Can SharePoint 2010 BCS return multiple attachments?

Can SharePoint 2010 BCS return multiple attachments? I have a database which stores multiple attachments per entity. Would like to have all of them accessible, but I've insufficient experience with ...
1
vote
1answer
2k 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
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
5k 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
132 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
164 views

BCS Managed Client Code Get all method instances

When using the class Microsoft.BusinessData.MetadataModel.Entity entity; does anyone know how to get all the External Content type operation method instances so i can dynamically pass the value to ...
1
vote
1answer
71 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
1k 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
289 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
281 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
222 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
389 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
534 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
46 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

Event fire and Workflow Attach to External List?

What is the best way approach to attach workflow and Event Receiver on External List? How to store Directly External Data to SharePoint Custom List?List
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
1k 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
193 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
219 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
733 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
534 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
265 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
313 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
672 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
514 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
257 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
2k 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
1k 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
2k 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
718 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
534 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
534 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
636 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
1k 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
450 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
836 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
0answers
10 views

Integrating Sharepoint with Dynamic CRM using K2 SmartObject Services [closed]

I want to Synchronize Microsoft Dynamic CRM with Sharepoint List, so that all the account's will be exported to sharepoint list. Can i do it with the help of K2 SmartObject Services.?
1
vote
1answer
21 views

SharePoint 2010 bcs item limit

I have an on premise SharePoint 2010 implementation. I need to implement a custom form with 65 fields which has rich text, drop downs and some complex filtering logic on the form. I want to load the ...