locked
External Content Type : Real world usage ?! RRS feed

 , 
 , 
 , 
 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I understand there is a 2000 row limit when using an external content type, for very sensible reasons, and I know you can extend this limit.

    BUT, if I wanted an ECT to return a Customer list from our Sales system, which has 10000+ customers it doesn't seem like a sensible thing to do.

    It appears to me that this ECT hookup to Line of Business applications has limited real world application with companies of any meaningful size as we are only really able to reference small datasets from external systems!?

    The only way round this as I can see is to refine the Customer list to say ' Recent customers' but then the lookups would be missing an 'old' customer should we need to reference them!

    Am I missing the point! please correct me if so!

    Cheers

    Russ

    Monday, November 5, 2012 2:02 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    For database connections that have more than 2000 rows, Business Data Connectivity (BDC) service throttles the results and therefore will fail to return any data from the external system. If you must return more than 2000 rows, then an administrator must increase the default throttling numbers on the server. You can use powershell to chang the limit:

    $wthbcs = Get-SPServiceApplicationProxy | where{$_.GetType().FullName -eq (‘Microsoft.SharePoint.BusinessData.SharedService.’ + ‘BdcServiceApplicationProxy’)}

    $BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $wthbcs

    $BCSThrottle

    Set-SPBusinessDataCatalogThrottleConfig -Identity $BCSThrottle -Maximum 1000000 -Default 20000

    For more informtion, you can refer to:http://akanoongo.blogspot.com/2011/02/how-to-resolve-2000-items-resolution-in.html

    Xue-mei Chang

    TechNet Community Support

    Tuesday, November 6, 2012 8:04 AM
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    For database connections that have more than 2000 rows, Business Data Connectivity (BDC) service throttles the results and therefore will fail to return any data from the external system. If you must return more than 2000 rows, then an administrator must increase the default throttling numbers on the server. You can use powershell to chang the limit:

    $wthbcs = Get-SPServiceApplicationProxy | where{$_.GetType().FullName -eq (‘Microsoft.SharePoint.BusinessData.SharedService.’ + ‘BdcServiceApplicationProxy’)}

    $BCSThrottle = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $wthbcs

    $BCSThrottle

    Set-SPBusinessDataCatalogThrottleConfig -Identity $BCSThrottle -Maximum 1000000 -Default 20000

    For more informtion, you can refer to:http://akanoongo.blogspot.com/2011/02/how-to-resolve-2000-items-resolution-in.html

    Xue-mei Chang

    TechNet Community Support

    Tuesday, November 6, 2012 8:04 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Xue-Mei,

    thanks for the answer, yes that's technically correct, but I was more after a discussion on how people are actually using ECTs in real applications... I believe the 2000 or 5000 items in External list OR ECT lookups are not really partical..... Is that what other people are discovering?

    Cheers

    Russ

    Tuesday, November 6, 2012 8:31 AM