In this post, I will talk about how to surface the custom SQL view we developed in the previous post through External Content Types and SharePoint Business Connectivity Services (BCS).
Now this isn’t a new topic. The only difference is that we’re using it to surface risk information. For more information on deploying ECT against Project Server, please see one of my older posts.
….and, er….that’s pretty much it. Not sure how much more I can add to that. Once you’ve done that against the new custom SQL view, it will look something like this:
Next up….adding the data to an external list.