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.
387
questions
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.
...
CommunityBot
- 1
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 ...
CommunityBot
- 1
1
vote
1
answer
133
views
BCS - Cannot open server requested by the login. The Login Failed
I am trying to create an external list from my Azure DB using BCS. I already setup the SQL, and I was able to connect to it through SSMS. But when I tried SPD to create external content type I am ...
- 1
0
votes
1
answer
1k
views
BCS External list login failed error
I have created external list from external content type, external content created from Azure SQL Database, but when i open the list it gives me following error.
Cannot connect to the LobSystem (...
CommunityBot
- 1
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 ...
CommunityBot
- 1
0
votes
1
answer
1k
views
Creating External Content Type under BCS model by connecting to an Oracle Database
I want to create an External content type by connecting to an Oracle database using VS or SP designer,to show data in an external list?
I am a bit new to BCS model so a little background will be ...
CommunityBot
- 1
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 ...
CommunityBot
- 1
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 ...
CommunityBot
- 1
0
votes
1
answer
25
views
BCS: get notified when data is changed in sql server?
We were using a sharepoint 2019 list as logging list and we moved that to SQL server. Then using BCS we are only reading the data from SQL and displaying in sharepoint using External Content Type and ...
- 3,560
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 ...
CommunityBot
- 1
0
votes
0
answers
13
views
Imported BDC file using CA not showing up in SPD
We're in the process of moving an application/site from 2013 to 2019. I do not have CA rights but had an admin import the .bdcm file into the 2019 environment that I exported from 2013 using SPD. He ...
0
votes
1
answer
29
views
Importing Data from Excel to Sharepoint (External Data field)
I have a list containing external data columns. I have an excel file that has values for external data columns. I want to bulk update via Powershell. When I try to update the value from excel to ...
- 3,560
1
vote
3
answers
733
views
What is BCS and what can it do for me?
I've been hearing a lot about it but even having Googled the subject I'm not sure what it is or what it can do for me. I believe BDC's could be considered a BCS component? What is BCS?
- 1,008
1
vote
2
answers
3k
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 http://sampletenant....
- 1,008
0
votes
0
answers
40
views
SharePoint designer craziness
I am using SharePoint Designer 2013, when I try to add an external system in the external content type dialog, it adds the system, I can browse databases and routines. If I try to browse views then ...
- 2,284
1
vote
2
answers
927
views
Custom BCS Connector Incremental crawl not working with AssociationNavigator
I created a custom BCS connector in SharePoint 2013.
I need to use the changelog approach for incremental crawling. Since I am crawling the file system like data source I am using AssociationNavigator ...
- 1
7
votes
2
answers
8k
views
BCS in Sharepoint Online
What are the features and limitations of BCS in Sharepoint online.
Can we create an external content type using Stored procedure in Sharepoint online.
0
votes
2
answers
66
views
Pass parameters to external list on SP2019 Standard
I have an external list that is displaying data from a SQL Server view. Now, I want to add filtering. The problem is that I'm working on Standard version of Sharepoint, so no Enterprise webparts are ...
- 4,457
0
votes
1
answer
53
views
Unable to access data from external list by REST API
I'm trying to retrieve items from external list by REST API. The external list displays data from SQL Server view. Unfortunately I always get error saying that the list does not exist. This happens ...
- 2,513
0
votes
1
answer
726
views
Catastrophic failure when crawling BCS data in SharePoint 2013
I am getting error in search crawl Logs when doing a full crawl on a Business Data Connectivity content source. The content source is set up to crawl a SQL BCS entity that has a stream accessor, ...
CommunityBot
- 1
6
votes
2
answers
8k
views
Access Denied while setting Metadata Store Permission
Breaking my head with this issue for the past 2 days!
Received Access Denied error in SPD so tried to set Meta Data permission and get the following error.
I am one of the Admins for BSC service ...
- 9,613
0
votes
1
answer
45
views
InfoPath form not opening in browser while using BCS external content type
I am using external content type in InfoPath form in SharePoint 2016 and the form doesn't open in browser.
How could it be solved?
- 3,964
0
votes
0
answers
234
views
Creating external content type using wcf service for SP Online BCS using SP Designer 2013
I have created WCF Service and I am able to generate WSDL URL and Endpoints when I use SharePoint designer 2013 to Create external content type to connect to SharePoint online BCS It does not show any ...
0
votes
1
answer
678
views
Getting Filtered results by Date column from a list with BCS and SharePoint 2010 JavaScript Client Object Model
I'm trying to get the filtered results by a column type DateTime from a list filled with BCS using JavaScript.
I've tried everything to get those results with query like:
"<Where>" +
"<...
CommunityBot
- 1
0
votes
1
answer
39
views
SharePoint training options
I'm looking for training in the SharePoint 2013/2016/2019 on-premises sphere with specific concentration on BCS solutions developed using JSOM and REST models.
Does anyone have a recommendation they ...
3
votes
1
answer
6k
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 ...
3
votes
3
answers
10k
views
How can I get external content crawled into SharePoint online index
I have SharePoint online and I want to add external content to the index.
So far I have it set up that the external content is put into an external list using BCS. The content passes through a WCF ...
- 11
0
votes
1
answer
331
views
How we can read External SharePoint List data using Rest in SharePoint 2016/2019?
I have a SQL database, I have configured BCS service in my SharePoint, using SharePoint Designer. It's means Now i have External list.
What I want, i want read and insert this external list data ...
- 6,189
2
votes
2
answers
274
views
is it possible to use active directory and bcs both in user profile in sharepoint 2013
hi is it possible to use active directory and BCS both in user profile in sharepoint 2013 for example I want some information like name ,family ,job position ,email and internal number to be filled ...
- 101
1
vote
1
answer
136
views
Microsoft Flow vs BCS/ECT to keep an Azure SQL table in sync with an SPO Modern List?
We worked with BCS (Business Connectivity Services) and ECT (External Content types) a while back and did not like it. Seemed like a lot of overhead maintaining the map. If the goal is to keep a ...
- 1,299
2
votes
1
answer
1k
views
SharePoint 2013 External Content type. Populate secondary fields
I am trying to migrate data to a document library that contains a external content type using the SharePoint 2013 client object model. The external content type is pulling from a sql server 2012 ...
CommunityBot
- 1
0
votes
1
answer
102
views
Access denied when trying to get SPListCollection out of SpWeb in BCS connector
I have a BCS connector.
In a constructor of its service class I want to access a SharePoint list.
using (var site = new SPSite("My site URL")
{
using (var web = site.RootWeb)
{
var ...
- 178
0
votes
1
answer
2k
views
What are the BCS/External List Limitations for ECMA CSOM?
I cannot seem to find any documentation on this topic. Are there any limitations for what I can or cannot do with the JavaScript CSOM in SharePoint Server Standard 2010 External Lists as compared to ...
- 38.5k
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
0
votes
1
answer
59
views
Using the REST API to view an External Column in a list (Not an External List)
I have done some research and it does seem possible to read an External List, but I am trying to read an External Column within a regular list. How can I use the REST API to view an External Column (...
- 109
4
votes
2
answers
3k
views
Problem with limit of Items in External list
My Web part consumes a list that presents this error:
The Database Connector limited the response. The database response contains more than '2000' rows. The maximum number of rows that can be read ...
- 121
0
votes
1
answer
147
views
Copy BCS Field from a list to another list using powershell
My problem is when copying items from a list to another, i can see the BCS field in the Display form(the value of the BCS in the display form is correct) but not in the Edit form(the text box of the ...
- 523
1
vote
1
answer
227
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 ...
- 2,799
1
vote
2
answers
473
views
How is Secure Store Service storing passwords under the hood?
When Business Connectivity Services need to access external data which requires per-user authentication, it uses Secure Store Service to store the user password in order to avoid asking for it again ...
- 2,750
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
116
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
0
votes
0
answers
2k
views
Sharepoint Online External Content Types WCF Service
I have this issue I can't find solution for a couple of days now as I am working on creating External Content Types for Sharepoint Online 2013 (trial period will expire in the next 5 days :( ).
I ...
- 41
0
votes
1
answer
50
views
Backup & Restore SP Site with External Content Type to Another Site - make error
My site includes External Content Type (BCS) on Dev site, with List which of that type - and when
i restore it to Prod server, the connectivity of the list, stay as previous system..!
any way to ...
- 3,530
1
vote
1
answer
868
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?
- 38.5k
0
votes
3
answers
3k
views
Parameters not passed to BCS External List via REST API
I have two external lists connected via external content types which are connected to stored procedures in SQL Server. I believe I have them set up identically (though evidently not because one is not ...
- 171
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 ...
0
votes
3
answers
2k
views
Managed property not showing in Display template
We have a BCS-model which gets data from a database outside of SharePoint.
We make data from the BCS searchable by creating managed properties and then mapping them to the auto generated crawled ...
- 1,331
0
votes
1
answer
243
views
Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information
I am trying to create a new external content type using SharePoint Designer, whenever I am trying to add WCF connection I get an error message as "Unable to load one or more of the requested types. ...
- 2,936
1
vote
1
answer
66
views
How to get data from SQL with Sharepoint and use them in VSTO
I'd like to get some data from my SQL database and use it in my visual studio project. But the problem is I can't use the port number in a connection string like I have to do it normally due to a ...
- 1,292
0
votes
2
answers
49
views
configure the business data connectivity service
I'm getting ready to configure the business data connectivity service on central admin
Question:
Does it matter which existing application pool I choose to use?
I don't have a testing environment, ...
- 3,958