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

Integrating Microsoft Office with SQL Server

Deciding whether to integrate Microsoft Office with SQL Server depends on your customers' server environment.

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 July 2007

Dig Deeper on Database software management

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.