Hot answers tagged

9 votes
Accepted

BCS in Sharepoint Online

Limitations include: There are no profile pages for external content types There is no offline availability or rich client integration There is no search integration. You will get some good ...
Dikesh Gandhi's user avatar
7 votes
Accepted

Problem with limit of Items in External list

Unfortunately, it's one of the main limitations of SharePoint External List! In External List, If the number of retrieving items is more than 2000 items, the external list will not working ...
Mohamed El-Qassas MVP's user avatar
5 votes

is it possible to use active directory and bcs both in user profile in sharepoint 2013

It's definitely doable. On European SharePoint Conference 2015 in Stockholm, Patrick Curran showed us in a demo how this worked. From an architectural viewpoint this is how it works with the new ...
Benny Skogberg's user avatar
  • 25.5k
5 votes
Accepted

Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’ in BCS

This problem might occur because of the connections authentication mode is not assigned to BDC Identity. Below Connection properties -> Select Client -> Below Secure Store Application ID -> Select ...
Jihan's user avatar
  • 136
4 votes

Store 2,500,000 records SharePoint

If you intend to use the BCS External List to fetch data you should be aware of this important point If the retrieving items from the LOB database are more than 2000 items You will face performance ...
Mohamed El-Qassas MVP's user avatar
4 votes
Accepted

Create External Content Type in SharePoint 2016

Is the recommendation to still use SPD 2013? As a short answer Yes, you can continue use SharePoint Designer 2013 to create External content type for Sharepoint 2016. For more details check my ...
Mohamed El-Qassas MVP's user avatar
3 votes

Alternative to BCS in SharePoint 2013

Based on your question and comments, your issue is represented in creating an External Content Type without using SharePoint Designer because it's disabled in your organization for security reasons. ...
Mohamed El-Qassas MVP's user avatar
3 votes

Parameters not passed to BCS External List via REST API

Like Melanie Culver alluded to a CAML query can be used to pass the parameters directly to the stored procedure. My external content type has an input parameter like this and I can specify my input ...
Brad's user avatar
  • 141
3 votes
Accepted

Insert item in an external list via REST API

ok...first version of the script (with $.ajax) is the regular way to execute CRUD operations on items in lists (external and internal)..unfortunately it works only for internal list (by my experience)....
teoooo78's user avatar
3 votes

Store 2,500,000 records SharePoint

Storing this much data is not an issue with SharePoint. But actual problem is presenting the data( reporting). In SharePoint their is thing called "List View Threshold" which had limit of 5000 items ...
Waqas Sarwar MVP's user avatar
3 votes
Accepted

BCS, can I connect a result of SQL query to external database in SharePoint list?

I would also like to add that you can also accomplish this with SQL Table Views. So if you create a custom view within your SQL DB, you can connect to it in BCS using SP Designer as if it was a ...
David Drever's user avatar
2 votes
Accepted

How to add External Content type To custom SharePoint list?

Please find the steps to be followed in SharePoint Designer to achieve your desired result. SharePoint 2013: BDC Configuration And Creating External Content Type and External List UPDATED ...
Hardik's user avatar
  • 7,733
2 votes

SQL Data into SP Online and access on mobile

IMO, BCS and ECT would be the simplest, easiest no-code solution for your requirement to pull data from SQL. This BCS should ideally be used in conjunction with Secure Store for security purposes for ...
Gautam Sheth's user avatar
  • 30.9k
2 votes
Accepted

What is SecurityDescriptor format?

That field is the name of a property of your entity, which returns a byte-encoded (byte[]) representation of the encoded claims. Here's a great example: https://blogs.msdn.microsoft.com/...
Wictor Wilen MCA MCM MVP's user avatar
2 votes

is it possible to use active directory and bcs both in user profile in sharepoint 2013

You will need to first sync User profile Service Application with Active directory and then sync it with BCS. Link below gives step by step method to configure that. BCS part is "Phase 3". Synchronize ...
Alok Kumar Gupta's user avatar
2 votes

Alternative to BCS in SharePoint 2013

@M.Qassas solution is the best one. However if you are looking for an alternative solution to BCS and SSIS, you can create a console app. Add your data sync logic between SharePoint and external ...
Ahmad Zia's user avatar
  • 1,276
2 votes

Display a standard grid for a external list connected through BCS

You shouldn't use an add-in. You should use Sharepoint's designer and create external type and external list. Found answer here - http://www.fabiangwilliams.com/2013/10/14/blog-update-on-sharepoint-...
Mark Twain's user avatar
2 votes

Microsoft Flow vs BCS/ECT to keep an Azure SQL table in sync with an SPO Modern List?

Microsoft Flow could be a good tool to export information from multiple sources like an Azure SQL database. But you should check Azure Functions and Office Graph API as well. This couldn't be a ...
jaloplo's user avatar
  • 789
1 vote

Crawling data from external database

Have a look here Increasing throttle limits would degrade the query performance. As advice, try to design your BDC models with different finders according to your business requirements and use them ...
Vladimir Herrlein's user avatar
1 vote

Combining BCS content source with people result source into everything tab in SharePoint 2013

The “Local SharePoint Results” result source includes the all items from the local SharePoint search index except People items. If you want to display the people result source and Local SharePoint ...
Amy_MSFT's user avatar
  • 2,956
1 vote

Alternative to BCS in SharePoint 2013

It's simple, but if you're not looking so much to integrate the data into SharePoint as you are just displaying it, you could use a page viewer webpart and/or iframe in a content editor webpart to ...
Matt Jimison's user avatar
1 vote

Alternative to BCS in SharePoint 2013

It's possible to consume your data using an add-in-scoped external content type by creating an add-in project and an oData ASP.NET Web API proxy service. You could also build the CRUD operations ...
dallasg's user avatar
  • 31
1 vote
Accepted

BCS Incremental crawl running longer than full crawl in SharePoint 2016

You have to create supply the LastModifiedTimeStampField property on the Finder Method Instance and point it at the property of you External Content Type's last modified timestamp field. This will be ...
Matthew McDermott's user avatar
1 vote

Error with Create Method on External Content Type

Use Business connectivity service in the SPD. Its straightforward
Mathew's user avatar
  • 1,386
1 vote
Accepted

Still getting Odata Service Connector Throttle Error - Already tried Set-SPBusinessDataCatalogThrottleConfig

Looks like you cannot use Scope Database, and ThrottleType Items. You need to use Scope OData, and ThrottleType Size. Scope : OData ThrottleType : Size Enforced : False Default : ...
user5579208's user avatar
1 vote

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

Your external content type has to return the document to the crawler. Alternatively you could just crawl the location where the files are stored.
Matthew McDermott's user avatar
1 vote

Parameters not passed to BCS External List via REST API

I had the exact same challenge yesterday and found a solution. I came across this blog post: https://blogs.msdn.microsoft.com/chjain/2013/03/01/getting-data-from-large-external-lists/ One problem I ...
Melanie Culver's user avatar
1 vote
Accepted

BCS connecting to Oracle Database with BDC Model

Take note of this crucial point. If the retrieving items from the Oracle database are more than 2000 items You will face performance issues so I advise you to check External List Limitation before ...
Mohamed El-Qassas MVP's user avatar
1 vote
Accepted

use external liste error :Oracle database TNS The value's length for key 'data source' exceeds it's limit of '128'

Here is the answer: BCS UserProfile Sync to Oracle not working after upgrade from Oracle 10 to Oracle 11 You have to take care for type of field.
Imen Turki's user avatar
  • 2,183

Only top scored, non community-wiki answers of a minimum length are eligible