Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [bcs]

Business Connectivity Services

0
votes
1answer
13 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 (...
0
votes
1answer
15 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 ...
1
vote
1answer
22 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 ...
1
vote
0answers
20 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; ...
1
vote
1answer
56 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 ...
0
votes
1answer
21 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 ...
1
vote
1answer
102 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?
0
votes
0answers
15 views

Can Sharepoint augment List items with external data fetched using an API using BDC services?

We currently have a case management system built in .net which exposes an API to fetch cases, generate documents, save cases etc. Example get case : http://casemgmt.foo/case/{id} There is a business ...
0
votes
3answers
469 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
vote
1answer
30 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 ...
0
votes
1answer
86 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
vote
1answer
44 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 ...
0
votes
2answers
30 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, ...
1
vote
0answers
20 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 ...
1
vote
0answers
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 ...
3
votes
2answers
229 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 ...
0
votes
1answer
252 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 ...
2
votes
1answer
49 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 ...
1
vote
1answer
185 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 ...
1
vote
1answer
238 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 ...
3
votes
2answers
935 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 ...
1
vote
0answers
43 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 ...
1
vote
1answer
83 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 ...
1
vote
0answers
62 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 ...
1
vote
1answer
28 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 ...
1
vote
4answers
229 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. ...
0
votes
2answers
380 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
1answer
196 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 ...
1
vote
1answer
281 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-...
3
votes
0answers
215 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 ...
2
votes
1answer
1k 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, ...
1
vote
0answers
163 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 ...
2
votes
2answers
131 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 ...
1
vote
2answers
74 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 ...
4
votes
1answer
4k 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
1answer
354 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
3answers
233 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 ...
0
votes
1answer
268 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 ...
0
votes
1answer
70 views

How to create refiner when we have two BCS external content crawled and displayed in Search?

I am using SharePoint 2016 On-Premises Enterprise Search..I have two separate external contents in DB , each of the records having thousands of Data. When the search results displayed I am trying to ...
1
vote
1answer
40 views

How to Parse External content URL in DB connected via BCS Model in On Premises Search?

I have crawled through External content located in DB in which one Column is having links that are all documents either word or ppt or pdf. I am able to display the row data's in Search, Would like ...
1
vote
0answers
62 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 ...
1
vote
0answers
52 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?
4
votes
1answer
706 views

Insert item in an external list via REST API

I'm trying to insert an item in an external list (a SQL server table linked to SP through BCS) via javascript...i thought it was simple but... this is the function for insert this.insertListItem = ...
0
votes
1answer
26 views

How to use xml definition in SharePoint list which is configured using BCS

I have a SQL database server with 3 columns ID, Location, FileType, I have used BCS service to connect SharePoint with this table. Now for example Location field is int type something like 19 means ...
3
votes
1answer
48 views

SQL Data into SP Online and access on mobile

As my title states, I'm looking for some help/resources on how I can pull data from SQL server and display it on SP Online. The added kicker is, we'd like this data to be view-able on mobile devices. ...
0
votes
1answer
883 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 ...
1
vote
0answers
214 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 ...
1
vote
0answers
166 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 ...
0
votes
1answer
707 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 (...
1
vote
0answers
42 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, ...