Sharepoint 2007 - Office 2007 & The Big Picture
February 22nd, 2008I just returned from the 1st ever Microsoft Office Devloper Conference in San JoseLes jeux sur notre poker en ligne virtuel n’ont rien à prétendre à leurs modèles réels. held 2/10 - 2/13/2008. My reasons for going were to find out how some of the newest Microsoft platform components all fit into the big picture, since my role at work is to define and implement our IT strategies. I am always looking outward at the 3 - 5 year timeframe, trying to anticipate the changes that may take hold and impact our IT world in a meaningful way.
Our department is largely based on Microsoft technologies. We use Server 2003 (now Server 2008 is getting ready to ship), SQL Server 2000 and 2005 (SQL Server 2008 is in beta), Microsoft Exchange 2003 and ISA Server 2004. The office workers all use Office 2003 (Office 2008 is out), we use Actuate 8 & 9 for reporting and Proclarity for BI (Microsoft bought Proclarity several months ago and it is coming out as Microsoft PerformancePoint Server 2008). We tried using Sharepoint 2003 and ran into problems we could not solve to our satisfaction so we tabled it for a while and now Sharepoint 2007 is out.
So why have a conference on MS Office development? Don’t we all know that MS Office uses VBA and it is a good but limited platform? And, why all of the radical changes to the Office 2008 user interface? Well, I am a software technology change tracker who has made a career out of anticipating where the next big thing might be and I had some serious “suspicions” that this conference was going to be a lot more than what it seemed. One would have to ask why Bill Gates would be doing the keynote session for such an inauspicious platform as Office? Several of the Microsoft Product VP’s would also be speaking. There was more to this than was obvious.
Well, I was right. This conference was the “coming out” party for a significant shift in how application developers will do their work in the future, if they live in a Microsoft-based world. Here are some of the highlights:
- компютри втора употреба
- All Microsoft Office 2008 products can now be customized through Visual Studio 2005 and Visual Studio 2008, using the .Net framework. This means an Office application can serve as the “host” to custom applications and workflows that are embedded into it. The implication is that we can make our users more productive by keeping them in applications that they already know and use every day. For example, I spend most of my day in Outlook. If I want to send an e-mail to one of our customers who is not already in my personal Outlook contacts, I have leave Outlook, log into our ERP or CRM system, find the customer contact information, copy the e-mail address to the clipboard, leave the ERP or CRM, go back to Outlook, open a new mail message and paste in the adress. Obviously, this is not hard for a skilled office worker to do, but it is a lot of steps. Why can’t I have a custom Outlook contact list be dynamically populated in Outlook from my ERP or CRM automatically? Well, because this used to be a hard thing to do. Not any more.
- MS Office 2008 documents are now all stored in an open xml format. This means they are all searchable, if you think about it. So entrprise search for content becomes much easier. It means also that these documents can be created by programs other than Microsoft Office, like a server-side process. A program running on a server could create an Excel spreadsheet without having to have Office installed on the server. Maybe its a SQL Server job that runs during the night and updates some sort of Excel workbook.
- Sharepoint 2007 now supports Business Data Catalogs. This allows easy access to almost any data from a web part that you can build in Visual Studio and deploy in a MS Office Business Application (OBA) or in a SharePoint web portal. This enables businesses to leverage the business knowledge that is locked up inside their SQL stored procedures and views.
- While PerformancePoint does not yet offer the full functionality of Proclarity, it is all based upon building web parts that can also be used inside an OBA or Sharepoint portal. This allows you to more tightly integrate your key performance indicators with other data components used to manage and monitor your enterprise. Again, this is pretty easy to do in the new Visual Studio platform.
I guess the whole point for me is that Microsoft is finally delivering a robust toolset and platform suite that will allow me to decide how and when I want to use all of my company’s data, letting me decide where I want to have the data accessible to my users and still make this a straightforward process in terms oif application development. It will be interesting to observe how well this plays out in corporate America. I predict it will be a huge success, however I won’t say how long it will take for widespread adoption because that always takes longer than we expect.