Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [bcs]

Microsoft Business Connectivity Services (BCS) (formerly named the Business Data Catalog) provides the capability to allow data sources outside of SharePoint to be surfaced and potentially modifiable in SharePoint's List user interface. Use this tag for questions or problems related to configuration or using BCS.

127 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
7 votes
1 answer
6k views

Business Data Connectivity Service is not accessible

I am working on sharing service applications across farms ( SP2013 Publishing Farm, SP 2010 Consuming Farm). Services like Search, MMS and Secure Store are working perfectly fine after sharing. ...
Nadeem Yousuf-AIS's user avatar
6 votes
1 answer
1k 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 ...
Daniel Lesser's user avatar
5 votes
2 answers
1k 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 ...
Andrew Tobin's user avatar
5 votes
1 answer
2k views

System Account not having permission to update external list via BCS

My SharePoint administrator granted permissions to services, sp app pool, sp farm adim, and secure store in BCS for me to use but was only able create/delete but not update. I use SharePoint designer ...
user24453's user avatar
4 votes
2 answers
651 views

2 ways Communication required from SAP to SharePoint

I need to to get the data from SAP to SharePoint, and on performing CRUD operations via Lists from SharePoint. The updated data should also get effected in SAP. Can anyone help me in knowing how I ...
MSA's user avatar
  • 1,155
4 votes
0 answers
566 views

How to filter a paged and sorted external list

I have succesfully implented an external content type with a read list method, which can sort and page through the external data. The external content type has 4 filters (two limit and two wildcard) ...
Yavuz's user avatar
  • 333
3 votes
0 answers
315 views

SharePoint external list (sql) with multi lined text field

I have an external content type with one of the fields having huge text in it. (SQL type: varchar(MAX)). When I create the external list and open a new form, the field is a single line textbox and it ...
Vikas Kottari's user avatar
3 votes
0 answers
218 views

create custom BCS connector

What are the steps to create a custom bcs connector? I have a ftp location where the data gets updated every week. So I want to write a bcs connector which will connect to data source with the ...
user avatar
3 votes
0 answers
201 views

Ribbon is disabled when I Filter an external list in SharePoint 2010

I created an external list in sharepoint 2010 (SP1) using SPD. The backend is sql server. The I added a wildcard filter on a column called Source_System (and a limit filter). The out of the box ...
RussGove's user avatar
  • 1,254
2 votes
1 answer
716 views

unable to view sharepoint list created through BCS external list from designer

IM using BCS connecting to local DB from SharePoint site in designer creating external lists but i'm facing error as below : Cannot connect to the LobSystem (External System). Reason: 'A network-...
nags's user avatar
  • 21
2 votes
0 answers
560 views

Updating External List after Updating BCS: SharePoint 2013

I am using SharePoint 2013 and SQL Server 2012, both Enterprise Editions. Earlier I had created an External Content Type and created its External List. I have no problem performing various options ...
Merin Nakarmi's user avatar
2 votes
2 answers
86 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 ...
aaquib_khan's user avatar
2 votes
0 answers
144 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 ...
Brent Ellis's user avatar
2 votes
1 answer
3k views

The remote server returned an error: (407) Proxy Authentication Required.- BCS

We are trying to Consume OData in BCS using an App External Content Type. The OData service that we used is http://services.odata.org/V3/Northwind/Northwind.svc We followed this to create app ...
Amit's user avatar
  • 2,019
2 votes
1 answer
37 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 ...
lakshman's user avatar
2 votes
0 answers
622 views

Unable to Refresh BCS External Data

I am running into a refresh issue with BCS. Whenever I hit the little refresh button in the UI, I am repeatedly getting this error. I am using an OData web service for BCS with WindowsCredentials ...
Brent Ellis's user avatar
2 votes
1 answer
452 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 ...
Brent Ellis's user avatar
2 votes
0 answers
2k views

Getting External Data from Oracle to O365?

We have an on-premise oracle database with customer info (lets say roughly 10,000 rows), that we need to make available in our SharePoint Online (2013) environment in O365. The requirement is that ...
Brent Ellis's user avatar
2 votes
0 answers
345 views

Using code, how to sync data from CRM online 2011 to sharepoint online 2011 (or 2013) & vice-versa

I am trying for a proof-of-concept on this one. I have a sample crm-online plugin and I would like to know if through the code I can open my sharepoint online site and thereby get access to the lists/...
Anirudh's user avatar
  • 247
2 votes
0 answers
409 views

Custom BCS indexing connector with changelog inremental crawl is not working properly

Custom BCS indexing connector with changelog inremental crawl is not working properly I am writing a custom indexing connector using changelog incremental crawl approach. I'm using sample from http://...
Mitka's user avatar
  • 86
2 votes
0 answers
694 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 ...
Mark van Dijk's user avatar
2 votes
0 answers
127 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 ...
NewCoder's user avatar
2 votes
0 answers
156 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 ...
Nandan's user avatar
  • 21
2 votes
0 answers
595 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 ...
Steve B's user avatar
  • 7,508
2 votes
0 answers
190 views

External Data Column no sorting by a string based additional field

Can anyone confirm or tell me why you can't sort by an External Data column additional field if its type descriptor is a string? It works for int, bool and guid type descriptors. If I add a standard ...
Phill Duffy's user avatar
2 votes
0 answers
610 views

Populating User Profile properties with multiple values via BCS/BDC in SP2010

In SharePoint 2010, I have user profile data synchronized from active directory. Additionally, I've created a BdcModelProject in Visual Studio 2010 and done the necessary work to add some additional ...
Chris's user avatar
  • 53
1 vote
0 answers
68 views

Is it possible to sort items from an external content type?

I have an external list/content type set up that reads data from a SQL database view. I only have access to the one view, I do not have access to any tables directly. This database has been around ...
Dylan Cristy's user avatar
  • 12.7k
1 vote
1 answer
249 views

Update all BCS Field in SPSite using Powershell

When i delete an item in my external list, it's not deleted automatically from the list where i use the BCS Field. I have to click Refresh. I'm using this BCS in many lists. I'm looking for a ...
Jihen's user avatar
  • 513
1 vote
0 answers
40 views

Business Data Connectivity Model collection property

Is it possible to have a collection property in a BDC model? I added a property to my model class like this: public class MyModel { public IEnumerable<String> MyCollectionProperty { get; ...
Szybki's user avatar
  • 178
1 vote
1 answer
120 views

SP Online WCF External Content Types using SP Designer 2013

To create External Content Types in SharePoint Online, i have created a WCF service and hosted it in IIS and it is working fine as shown below. Now, I tried to create External Content types using ...
Neha Ala's user avatar
1 vote
1 answer
1k views

An error occurred while retrieving data from "". Administrators, see the server log for more information

In my list, i used an external data column. but i get this error when I try to retrieve the list of Investment manager. How i can fix that please?
Jihen's user avatar
  • 513
1 vote
0 answers
30 views

Business connectivity services return no data from web service

I am having trouble with Read List operation. The operation calls a method from my service which accepts one parameter, Title. If default value is set as null or none in operation settings, then no ...
user3497678's user avatar
1 vote
0 answers
21 views

Record level permission in BCS

In my scenario users want to access in external database that have record level permission (per user) in another table. Is it any way to use record level permission in Business Connectivity Services ...
Mahdi Sheikhi's user avatar
1 vote
1 answer
224 views

Create external list in sharepoint Via API data

I want to create an external list in SharePoint via API data. My questions are as follows: 1- How to create external list in SharePoint via API data? 2- when user updates item in SharePoint, how ...
Sai's user avatar
  • 629
1 vote
0 answers
73 views

SharePoint 2013 Search Deletion Policies for BCS

Background We are in the middle of upgrading our SharePoint farm from 2010 to 2013, and I am running into some issues with search content. In 2010, we utilized FAST Search for SharePoint 2010, and I ...
BJenkins's user avatar
1 vote
0 answers
82 views

Business Connectivity Service on Sharepoint online-How to link with external data source?

We have a sharepoint online(O365) solution,now we are maintaining all our dept user data in a virtual db in our dept itself,i just want to know how to connect our sharepoint site to that data source ...
Vish's user avatar
  • 81
1 vote
0 answers
192 views

Connect from external list from different site collections via OData in SP Online

I am using SharePoint Online and I have followed the steps of the tutorial: But the OData service url was the list of the second site collection. https://myTenant.sharepoint.com/sites/Site ...
Tito's user avatar
  • 291
1 vote
0 answers
98 views

Can not retrieve sql server routine return parameter schema information

I am trying to create an external content type on Sql stored procedure in sharepoint 2013 and getting the following error: Invalid Object Name '#...' .Can not retrieve sql server routine return ...
Misha's user avatar
  • 83
1 vote
0 answers
71 views

External Content Type from an OAuth2 secured REST data store in SharePoint Online

Is it possible to create an external content type that accesses a RESTful data store which requires OAuth2 authorisation without building a proxy website in between?
Dale M's user avatar
  • 133
1 vote
0 answers
237 views

Read External List (BCS) Data in SharePoint Hosted App

I have this SharePoint hosted app on SharePoint Online. In this app, I am able to read the data from any SharePoint List/Library using the REST calls. However, when I try to fetch the items from a ...
Piyush's user avatar
  • 215
1 vote
0 answers
218 views

Fill in External Item Picker (BDC) with query string value with InfoPath

We are trying to customize a 'new' form with InfoPath so that our query string value (idPatient) is automatically filled in into the External Item Picker (BDC entity). In InfoPath, we have set up the ...
Perneel's user avatar
  • 71
1 vote
0 answers
52 views

Query BCS Connection to Update a SP 2013 Library

I have a requirement to update a SP 2013 Library (let's call this Test Library) The requirements are detailed below: Update all items with a Status = Created If Status = Created update: Name, ...
Nina G's user avatar
  • 935
1 vote
0 answers
75 views

SharePoint 2013 BCS Action mailto not working

I have SharePoint 2013 and I am using BCS to show data from external database. For this external content type I have an action "mailto:{0}", it does not work and generates error "Could not redirect to ...
KayEye's user avatar
  • 169
1 vote
1 answer
584 views

Sync SharePoint list with CRM entities via BCS (on-premises)

all. I have a task to implement one-way synchronization from a custom list on SharePoint to specific type of entities on Dynamics CRM. The case is pretty simple to explain. There is an App (Add-in) ...
Alisher Abdurakhmanov's user avatar
1 vote
1 answer
318 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 ...
user1339913's user avatar
1 vote
1 answer
160 views

Active Directory Import and it "not supporting" Business Connectivity Services Import

I'm in the process of setting up a new SharePoint farm. We only really need one way import for Active Directory so I've been thinking we'll go with simplified Active Directory Import... however... of ...
mtwelve's user avatar
  • 91
1 vote
0 answers
119 views

How to implement Update/Delete operations using Business Data Web part

I have created a web part page for displaying the contents of my external list with a Filter parameter. I'm using a Business Data List Web part for this. I need to have Update/Delete operations for ...
IshaK's user avatar
  • 11
1 vote
0 answers
365 views

BCS REST Performance Issues

So we're migrating from On-Prem 2010 to Office 365 and I need to convert some of our simple calendar webparts to online solutions. I've setup an External Content Type in 365 using SharePoint Designer....
Chad's user avatar
  • 760
1 vote
0 answers
42 views

How to tell an ECT developed in VS to use credentials from Secure Store Service?

I am trying to develop an External Content Type using Visual Studio so I can use External Data Source columns in a SharePoint list. Most of the stuff I am finding online uses Designer, but I don't ...
Dylan Cristy's user avatar
  • 12.7k
1 vote
1 answer
930 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 ...
radicalEdward's user avatar