Correcting Impersonated Custom Identity in SharePoint Designer

Recently, I have done a lot of work with SharePoint Designer 2013 and External Content Types (ECT).  In a previous blog, SharePoint Online to Azure SQL Database: Part 1, I covered how to work with ECTs.  Since, writing that blog, I ran into an unexpected issue that caught me by surprise.  I was adding a data source for my ECTs in a new environment and made a mistake when entering the credentials for the Secure Store Application ID.  This blog is not meant to be long or mind blowing.  It is meant to save you some time.  The following is what to do if you enter the wrong credentials for the Secure Store Application ID in SharePoint Designer 2013. What…

Lessons Learned: Improving Business Connectivity Services Performance

by John Bonfardeci Are you developing a client-side JavaScript application on the SharePoint platform? Is your data in an external database such as Azure or SQL Server? Are you using views and/or stored procedures to join two or more tables? If you’ve answered “yes” to these questions, this lessons learned article is for you. It’s relatively simple to create external content types in SharePoint Designer via Business Connectivity Services (BCS) and many articles have been published covering the steps. Furthermore, you can filter data with the REST `$filter` parameter. However, SQL server will return all the data in a view or table and only then will SharePoint filter the results. For example, if a view returns 10,000 rows and you…