Q

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 first published in July 2007

Dig deeper on Database Management Products and Solutions

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

MicroscopeUK

SearchCloudProvider

SearchSecurity

SearchStorage

SearchNetworking

SearchCloudComputing

SearchConsumerization

SearchDataManagement

SearchBusinessAnalytics

Close