In a video tutorial titled Advanced Options for External Content Types, Raymond Mitchell presents some additional configuration options afforded to users who avail of SharePoint Designer 2010. The opening example in this 8 minute video demonstrates how to use SharePoint Designer 2010 to control the resource usage demand on external data sources.
As Raymond Mitchell notes, the standard SharePoint method for offering a range of data views, etc, for external content types avails of SharePoint as the configuration method. In other words, any opportunity to limit the resource demand on an external data source like SQL Server R2, or 2012, is lost through this method. In contrast, by using SharePoint Designer 2010, in “Operations Design View”, it is possible for users to avail of no more than a series of clicks of a mouse to limit data source elements, views, and more, to specifically the data required to support external content types exposed through SharePoint 2010.
The tool of choice for specifying data, and, thereby, controlling resource demands on external data sources is to configure “filters” with SharePoint Designer 2010. As Raymond demonstrates through a series of examples, carefully configured filters (meaning filters that establish limits on any planned SharePoint operations that depend upon external content types) can be used, successfully, to deliver the same information, albeit at a much lower level of demand on external data sources, as would be the case by merely using the browser to do the same in SharePoint 2010.
For SharePoint stakeholders intending to hasten user adoption of the platform for daily computing tasks, opting to control demand on external data sources in the manner demonstrated by this video course makes a lot of sense. Resources from external data sources, which are usually intended for the exclusive use of specific Line of Business (LOB) groups end up costing money, regardless of whether that cost is articulated in a pronounced slow down in computer processing time, or actual hard collars where SQL Server 2008 R2, or 2012 is provisioned to an enterprise as a managed service from a third party provider. In either case, creating accurate, useful data discovery tools with SharePoint Designer 2010 with the intention of substantially reducing and then managing the cost of supporting processes that expose this internal data within a SharePoint 2010 computing environment makes a lot of sense.
The design approach that supports the techniques demonstrated in this video amount to offloading non core processes from SharePoint 2010 to the external data sources, themselves. This approach actually lowers demands on these data sources and provides users a highly useful method of managing usage as the processes are used to support daily computing requirements.
© IMB Enterprises, Inc. & Ira Michael Blonder, 2012 All Rights Reserved
on behalf of Rehmani Consulting, Inc.