Problem solve Get help with specific problems with your technologies, process and projects.

SQL Server 2005 business suite and Microsoft Office integration

Integrating SQL Server 2005 business intelligence suite with Microsoft Office can increase database productivity.

Should I integrate Microsoft Office with SQL Server in customer shops?

The SQL Server 2005 BI suite has deep integration with Office 2003 and Office 2007. If your customers are using the BI tools, they should be using Office. If they are using SQL Server 2005 Analysis Services, they should be running Office 2007. SQL's new version of SQL Server, Katmai, has a BI suite with an even deeper integration into Office 2007 and SharePoint 2007. While OpenOffice might be an appropriate low end user substitute for a desktop productivity suite, Office is required if you want to integrate with SQL Server 2005's BI suite.

This was last published in May 2007

Dig Deeper on Database Management Products and Solutions

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.