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.
128
questions with no upvoted or accepted answers
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.
...
- 18.7k
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 ...
- 51
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 ...
- 53
5
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 ...
4
votes
2
answers
622
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 ...
- 1,155
4
votes
0
answers
565
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) ...
- 333
3
votes
0
answers
312
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 ...
- 468
3
votes
0
answers
213
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 ...
user13408
3
votes
0
answers
199
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 ...
- 1,254
2
votes
1
answer
702
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-...
- 21
2
votes
0
answers
546
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 ...
- 363
2
votes
2
answers
84
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 ...
- 21
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 ...
- 746
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 ...
- 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 ...
- 21
2
votes
0
answers
604
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 ...
- 746
2
votes
1
answer
448
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 ...
- 746
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 ...
- 746
2
votes
0
answers
344
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/...
- 247
2
votes
0
answers
407
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://...
- 86
2
votes
0
answers
689
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 ...
- 449
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 ...
- 45
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 ...
- 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 ...
- 7,466
2
votes
0
answers
189
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 ...
- 335
2
votes
0
answers
608
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 ...
- 53
1
vote
0
answers
59
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 ...
- 12.5k
1
vote
1
answer
229
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 ...
- 523
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; ...
- 178
1
vote
1
answer
118
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 ...
- 41
1
vote
1
answer
876
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?
- 523
1
vote
0
answers
28
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 ...
- 11
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 ...
1
vote
1
answer
218
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 ...
- 629
1
vote
0
answers
71
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 ...
- 85
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 ...
- 71
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 ...
- 291
1
vote
0
answers
96
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 ...
- 83
1
vote
0
answers
70
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?
- 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 ...
- 215
1
vote
0
answers
213
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 ...
- 71
1
vote
0
answers
51
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, ...
- 935
1
vote
0
answers
73
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 ...
- 169
1
vote
1
answer
550
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) ...
1
vote
1
answer
308
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 ...
- 617
1
vote
1
answer
155
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 ...
- 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 ...
- 11
1
vote
0
answers
359
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....
- 750
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 ...
- 12.5k
1
vote
1
answer
922
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 ...
