Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

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).

• 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.

Files

Status: Live This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

File	Size
DMAddins_Office2007_Readme.htm SHA1: d3c32a016df96cdb7727279a539fce1d944de526	5 KB
SQLServer2005_DMAddin.msi SHA1: d2da69781e7fd395f416dacbf177e93bd12b9b02	13.06 MB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

• • 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:
  • Enterprise Edition (RTM, SP1 or SP2)
  • Standard Edition (SP2) with cumulative hotfix package build 3152 applied
  
  

• 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.