Google
 

Thursday, February 14, 2008

K2.net and MOSS Collaboration Distillery: MOSS 2007 Architecture and Performance Considerations

An excellent overview of Sharepoint & reporting/workflow tools and architecture.

After working with Excel Services, it appears to be great for hosting static and formula-driven Excel spreadsheets on the web, however programming it is a different story.  Don't expect it to web-ify your Excel LOB application.  Look for VSTO + VIsual Studio 2008.

I would focus on using Reporting Services + Proclarity + PerformancePoint as a BI solution with a lot of flexibility and room to grow.  Throw in some Analysis Services for some high-performance slicing and dicing.

3.2.1) Excel Services
This is quick overview of excel services however it Excel Services is not a robust tool. After reading the list of Unsupported Features in Excel Services you will find out it may not provide what is needed for Excel power users (macros are not supported). It would not be recommended to use Excel Services as a replacement for enterprise reporting platform while tools such as Performance Point Server are built for this. Understand its limitations before using it.

K2.net and MOSS Collaboration Distillery: MOSS 2007 Architecture and Performance Considerations

No comments: