Getting Started with BCS


1.       Create an External Content Type Based on a SQL Server Table
http://msdn.microsoft.com/en-us/library/ee557243.aspx

2.       Create External Lists in SharePoint
http://msdn.microsoft.com/en-us/library/ee558778.aspx

3.       After that you will couple of issues such as
3.1   Access denied by business data connectivity. Correlation id. Follow steps from here http://blogs.msdn.com/b/ericwhite/archive/2010/06/11/access-denied-by-business-data-connectivity.aspx
3.2   BCS External List Error: Unable to display this webpart.
Solution is easy, Start -> All Programs -> Microsoft SharePoint 2010 Products -> SharePoint 2010 Management Shell
Then adjust your throttling Default and Maximum parameters, here is an example :
PS Y:\> $proxy=Get-SPServiceApplicationProxy | where {$_ -match "Business data Connectivity Service"}

PS Y:\> Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items -ServiceApplicationProxy $proxy

Scope        : Database
ThrottleType : Items
Enforced     : True
Default      : 2000
Max          : 1000000

PS Y:\> $defaultThrottleConfig = Get-SPBusinessDataCatalogThrottleConfig -Scope database -throttleType items        -ServiceApplicationProxy $proxy
PS Y:\> $defaultThrottleConfig

Scope        : Database
ThrottleType : Items
Enforced     : True
Default      : 2000
Max          : 1000000


PS Y:\> Set-SPBusinessDataCatalogThrottleConfig -Default 40000 -Identity  $defaultThrottleConfig -Maximum 1000000

PS Y:\> $customThrottleConfig = Get-SPBusinessDataCatalogThrottleConfig -Scope database -ThrottleType items      -ServiceApplicationProxy $proxy

PS Y:\> $customThrottleConfig

Scope        : Database
ThrottleType : Items
Enforced     : True
Default      : 40000
Max          : 1000000

4.       Reset IIS

Comments

Post a Comment

Popular posts from this blog

Auto-Generating Filenames for InfoPath Forms

Image
Auto-Generating Filenames for InfoPath Forms – I see this topic come up a LOT on forums all over the place, so instead of continuing to answer the question time and time again, I am going to post a quick blog entry showing the steps.  I think this stuff is fairly simple, but it just doesn’t pop into your head initially.  Once you see it and understand it, you’ll think it’s simple, too.  Keep in mind that I focus entirely on SharePoint-based InfoPath forms and for the most part BROWSER-ENABLED forms.  So, it’s possible and likely that all concepts explained here will work for non-browser forms and non-SharePoint forms, but just remember that my perspective is mostly browser-enabled.  The basis for this topic is that the standard method for submitting InfoPath browser-enabled forms is for the user to click Save at which point the user is prompted to give a filename along with choosing to allow overwrite.  I really dislike this feature, because users have no ...
Read more

Creating Three-state workflow in SharePoint 2010

Image
The Three-state workflow tracks the 3 states in a list to manage the business processes. Example Three states for Issue List could be Open, Resolved and Closed. Three state workflow supports to track the list item or issue through states. The workflow assigns a task to a person and sends an email to that person. When workflow is completed it updates the status of the item or issue. By default Three-state workflow works with the Issue Tracking list template. To use the Three-state workflow, you must define a list to use the workflow and it must contain some items. Two options to use the 3 state workflow Create a Issue-Tracking list which is having 3 state workflow Create a custom list to use the workflow Creating an Issue-Tracking list with 3 state workflow 1. In Team site, All site content page , click create 2. In the create dialogue, click Issue-Tracking and type a name for the list 3. Enter the description for the list as shown below Create a custom list and add a...
Read more

SharePoint 2013 Installation steps

Image
The next version of SharePoint introduces new ways to share your work and work with others, organize your projects and teams and discover people and information. So many organisations moving to SharePoint 2013. For detail hardware & software requirement please refer to this  Microsoft site Software Download SharePoint 2013 setup Please note that there are two versions to download(180 days free trail): SharePoint Server 2013 SharePoint Foundation 2013 with SP1 All Cumulative upgrades can be found below June 2014 update SharePoint Foundation 2013 KB 2881063 SharePoint Server 2013 KB 2881061 May 2014 update SharePoint Foundation 2013 KB 2863892 SharePoint Server 2013 KB 2878240 April 2014 update (Includes Service Pack 1) SharePoint Foundation 2013 KB 2880551 (SP1) SharePoint Server 2013 KB 2880552 (SP1) December 2013 update SharePoint Foundation 2013 KB 2849961 SharePoint S...
Read more