Click Here to Install Silverlight*
United StatesChange|All Microsoft Sites
Microsoft
Download Center 
Search Advanced Search

Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007

Brief Description
Download SQL Server 2005 Data Mining Add-ins for Office 2007. This package includes two add-ins for Microsoft Office Excel 2007 (Table Analysis Tools and Data Mining Client) and one add-in for Microsoft Office Visio 2007 (Data Mining Templates).

On This Page

Quick Details
Version:1.0
Date Published:3/22/2007
Language:English
Download Size:25 KB - 13.8 MB*
*Download size depends on selected download components.
Change Language:
  

Overview

Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007 (Data Mining Add-ins) allow you take advantage of SQL Server 2005 predictive analytics in Office Excel 2007 and Office Visio 2007. The download includes the following components:

  • Table Analysis Tools for Excel: This add-in provides easy-to-use tasks that leverage SQL Server 2005 Data Mining to perform powerful analytics on your spreadsheet data.
  • Data Mining Client for Excel: This add-in allows you to go through the full data mining model development lifecycle within Excel 2007 using either your spreadsheet data or external data accessible through your SQL Server 2005 Analysis Services instance.
  • Data Mining Templates for Visio: This add-in allows you to render and share your mining models as annotatable Visio 2007 drawings.

If you choose, you can install each of these components separately.

Note: If you downloaded and installed this package prior to March 21, you should download it again and follow the steps in the Instructions section on this page to remove the older version and reinstall.

 Top of page

System Requirements

  • Supported Operating Systems: Windows 2000 Service Pack 4; Windows Server 2003 Service Pack 1; Windows Vista; Windows XP Service Pack 2
  • Microsoft .NET Framework 2.0.
  • If installing the Table Analysis Tools or Data Mining Client for Excel, Microsoft Office 2007 with .NET Programmability Support.
    Supported editions of Office 2007 include:
    • Professional
    • Professional Plus
    • Ultimate
    • Enterprise
  • If installing the Data Mining Templates for Visio, Microsoft Viso Professional 2007 with .NET Programmability Support.
  • 40 MB of available hard disk space.
  • Note: If SQL Server 2005 is installed on the computer where you are installing the Data Mining Add-ins, make sure that the version of SQL Server 2005 is a final release version (RTM, SP1, or SP2). The Data Mining Add-ins will not work correctly with Community Technology Preview (CTP) versions of SQL Server 2005 SP2.
  • Note: The Data Mining Add-ins require a connection to one of the following versions of SQL Server 2005 Analysis Services:

 Top of page

Instructions

    Note: If you have an earlier version of the Data Mining Add-ins installed, you must remove it using Add/Remove Programs in Control Panel before installing the latest version. User settings, such as Connections, will not be removed.

    Step 1: Verify that you have Microsoft Office 2007 installed.

    Step 2: If you do not already have Microsoft .NET Framework 2.0, download and install the 32-bit version of Microsoft .NET Framework 2.0.

    Note: If you intend to install the Table Analysis Tools for Excel or the Data Mining Client for Excel, verify that the .NET Programmability Support component is installed under Microsoft Office Excel by running Microsoft Office 2007 Setup from Add/Remove Programs in Control Panel. The default install of Microsoft Office Excel includes this component.

    Note: If you intend to install the Data Mining Templates for Visio, verify that the .NET Programmability Support component is installed under Microsoft Office Visio by running Microsoft Office Visio 2007 Setup from Add/Remove Programs in Control Panel. The default install of Microsoft Office Visio includes this component.

    Step 3: Download the Data Mining Add-ins by clicking the SQLServer2005_DMAddin.msi link later on this page. To start the installation immediately, click Run. To install at a later time, click Save. The license and documentation are installed with the Data Mining Add-ins.

 Top of page

Additional Information


 Top of page

Files in This Download

The links in this section correspond to separate files available in this download. Download the files most appropriate for you.
File Name:File Size

DMAddins_Office2007_Readme.htm

25 KB

SQLServer2005_DMAddin.msi

13.8 MB

 Top of page

 Top of page

 Top of page

 Top of page

© 2009 Microsoft Corporation. All rights reserved. Contact Us |Terms of Use |Trademarks |Privacy Statement