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
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 ...
- 11
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 ...
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 ...
- 1
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 ...
- 307
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 ...
- 307
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?
- 1
0
votes
0
answers
235
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
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 ...
- 25
0
votes
1
answer
333
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 ...
- 435
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
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
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
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
228
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
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
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 ...
- 11
1
vote
1
answer
873
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
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
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 ...
- 236
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. ...
- 1
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 ...
- 77
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, ...
- 442
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 ...
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
0
votes
1
answer
1k
views
How to remove SPEnterpriseSearchMetadataCrawledProperty in SharePoint 2016
We have Business Data service in SharePoint 2016 Search Application. Recently I've been trying to remove crawled properties.
I followed this blog. But I get an error in PS console as
"Cannot ...
- 347
2
votes
1
answer
72
views
Display a standard grid for a external list connected through BCS
Environment
Sharepoint 2016.
Visual Studio 2017.
Sharepoint Add-In in a hosted environment.
Requirements
Display an external list connected through BCS in a standard grid view with possibility of ...
- 141
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
1
answer
410
views
Crawling data from external database
I need to crawl data from SQL Server Database. For this, I created an external list using Business Connectivity Services.
However, I encountered a limit on the number of requested rows: my table ...
- 191
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 ...
- 157
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
1
answer
199
views
Combining BCS content source with people result source into everything tab in SharePoint 2013
I want to display the people result source along with other different results source including local SharePoint Results and some BCS connection content source in Everything tab.
Please suggest if ...
- 31
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
1
answer
31
views
Storing >10K rows in Sharepoint or in SQL server
I have a requirement from a client who want to store info about engineering diagrams(its location and the scanned copy(pdf)).
They also want SharePoint users to be able to perform searches on the ...
- 111
1
vote
4
answers
394
views
Alternative to BCS in SharePoint 2013
My requirements is to consume external data in SharePoint 2013. One of the option I know is SSIS, this is a lot of work. I wanted to know if you've achieved something similar using other methods.
...
- 240
0
votes
2
answers
661
views
How to populate external data columns in a custom SharePoint 2010 list
Hello fellow SharePointer's.
I am currently working on converting a custom solution to a more out of the box solution. I need to populate a SharePoint list with data from a SQL table which meets a ...
2
votes
1
answer
270
views
BCS Incremental crawl running longer than full crawl in SharePoint 2016
We have configured BCS search in SharePoint 2016. Created External content type with Sharepoint Designer and created Content Source using with External content type.(Source in Documentum).
While run ...
- 347
2
votes
1
answer
699
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
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
1
answer
2k
views
Create External Content Type in SharePoint 2016
I would like to crawl (Search) a custom database/table using SharePoint 2016. I know this is possible and doable using SharePoint Designer.
What I am wondering is since Microsoft has discontinued, ...
- 795
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
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 ...
- 205
1
vote
2
answers
89
views
Error with Create Method on External Content Type
SharePoint 2013
I have an External Content Type (ECT) defined for a table in a SQL Server database. I also have the usual CRUD methods defined for the ECT. The table has over 50 fields, but there is ...
- 61
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.
- 83
0
votes
1
answer
718
views
BCS search issue in SharePoint 2016 - Error while crawling LOB contents
We have configured BCS search in SharePoint 2016. We have got "Error while crawling LOB contents" while crawling BCS content source in search service application.
**Error**
Error while crawling LOB ...
0
votes
3
answers
373
views
Still getting Odata Service Connector Throttle Error - Already tried Set-SPBusinessDataCatalogThrottleConfig
I've already tried powershell to reset the throttle value as well as disabled it completely:
This disables a throttling rule.
Set-SPBusinessDataCatalogThrottleConfig -Identity $dbRule -Enforced:$false
...
- 95
0
votes
1
answer
469
views
BCS external content type ReadList fails with InvalidMetadataObjectException
I have create a BDC model with a .Net assembly linking to a LOB system. Checking the model in Visual Studio is all good. I upload the solution to SharePoint 2013 Enterprise and create a new external ...
- 162