Updated: 3/16/2007

The SQL Server documentation team welcomes your documentation feedback. We view and investigate all documentation issues but do not answer technical support questions here. For help with technical issues not related to documentation, see Getting Assistance with SQL Server.

If it is possible, submit feedback to us in English.

1.0 Introduction to the Data Mining Add-Ins for Office 2007

The Microsoft® SQL Server™ Data Mining Add-Ins for Office 2007 help you derive patterns and trends that exist in complex data, visualize those patterns in charts and interactive viewers, and then generate rich, colorful summaries for presentation and for business analytics. This document describes how to obtain and install the Data Mining Add-Ins for Office 2007. The Data Mining Add-Ins for Office 2007 must be used with Microsoft Office Excel 2007 and Microsoft Office Visio 2007.

Important:
The Data Mining Add-Ins for Office 2007 require a connection to an instance of Microsoft SQL Server 2005 Analysis Services. These add-ins cannot be used with SQL Server 2000 Analysis Services, because it requires the algorithms and other data mining services provided in SQL Server 2005 Analysis Services.

After you have downloaded the add-ins, you can find additional information about how to use the Data Mining Add-ins for Office 2007 in the Help that has been provided in the installation package. If you installed the add-ins in the default location, the path of the Help file is as follows:

c:\Program Files\Microsoft SQL Server 2005 DM add-Ins\DMAddins_Office2007.chm

For more information about getting started, see Data Mining Tools Overview (Data Mining Add-Ins for Office 2007).

[Top]

1.1 Installation Requirements

The Data Mining Add-Ins require a connection to an instance of SQL Server 2005 Analysis Services. This instance must be on a computer that is running any of the following versions of SQL Server 2005:

  • SQL Server 2005 Enterprise Edition

  • SQL Server 2005 Enterprise Edition Service Pack 1 (SP1)

  • SQL Server 2005 Enterprise Edition Service Pack 2 (SP2)

  • SQL Server 2005 Standard Edition SP2, with the cumulative hotfix package (build 3152) installed. For more information about this hotfix, see the Knowledge Base article, Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2.

For more information about installation requirements, see the Microsoft SQL Server 2005 Data Mining Add-ins for Office 2007 page on the Microsoft Download Center.

Disk Space Requirements

During installation, you can select the add-ins to install, including an Excel worksheet containing sample data that might be useful in constructing different types of data mining models.

The following table describes the disk space required to install the Data Mining Add-Ins for Office 2007:

Disk space required (MB) Add-in name Installation

4

Table Analysis Tools for Excel

Default

30

Data Mining Client for Excel

Optional

2

Data Mining Templates for Visio

Optional

1

Server Configuration Utility

Default

1

Documentation

Default

2

Sample data

Default

System Requirements

Your computer must meet the following requirements to successfully install the add-ins.

  • Supported Operating Systems: Windows 2000 Service Pack 4; Windows Server 2003 Service Pack 1; Windows Vista; Windows XP Service Pack 2.

  • The Microsoft .NET Framework 2.0.

  • 40 MB of available hard disk space.

  • Microsoft Office Excel 2007, with .NET Programmability Support, in any of the following editions:

    • Microsoft Office Professional 2007

    • Microsoft Office Professional Plus 2007

    • Microsoft Office Ultimate 2007

    • Microsoft Office Enterprise 2007

  • Visio Professional 2007

Note:
If you install the Table Analysis Tools for Excel or the Data Mining Client for Excel, verify that the .NET Programmability Support component is installed. The default install of Microsoft Office Excel includes this component.

Note:
If you install the Data Mining Templates for Visio, verify that the .NET Programmability Support component is installed under Microsoft Office Visio. The default install of Microsoft Office Visio includes this component.

[Top]

1.2 Uninstalling or Modifying the Add-ins

To remove the add-ins
  1. In Control Panel, click Add or Remove Programs.

  2. Select Microsoft SQL Server 2005 Data Mining Add-Ins for Office 2007.

  3. Click Remove.

After installation, you can change the installed options, to add or remove add-ins. The Table Analysis Tools for Excel are installed by default, but you can add the Data Mining Client for Excel, or the Data Mining Templates for Visio.

To modify the add-ins
  1. In Control Panel, click Add or Remove Programs.

  2. Select Microsoft SQL Server 2005 Data Mining Add-Ins for Office 2007.

  3. Select the add-ins you want to add or modify, and click Next.

1.2 Additional Configuration

The first time that you open one of the Data Mining Add-Ins for Office 2007, the Getting Started utility opens and guides you through the process of configuring the add-in to connect to an instance of SQL Server Analysis Services. The utility also assists you in downloading an evaluation version of SQL Server 2005 if you do not have access to an existing instance.

If the utility does not start automatically, you can run it by doing the following:

To run the Getting Started utility
  • Click Start, point to Microsoft SQL Server 2005 DM Add-ins, and then select Getting Started.

If you already have access to an existing instance of SQL Server 2005 Analysis Services, you can configure the server to allow data mining by using the Server Configuration Utility. This utility is available as part of configuration when you run Getting Started, but you can also start it at any time by doing the following:

To run the Server Configuration Utility
  • Click Start, point to Microsoft SQL Server 2005 DM Add-ins, and then select Server Configuration Utility.

For more information about the Getting Started utility and the Server Configuration utility, see Setup and Configuration (Data Mining Add-ins for Office 2007).

[Top]

2.0 Updated Information

For more information about the Data Mining Add-Ins for Office 2007, or new data mining features, see the Microsoft SQL Server Data Mining Web site.

For more information about each of the add-ins, see the white paper, "Microsoft SQL Server 2005 - Interoperability with the 2007 Microsoft Office System," on the Analysis Services Web site.

For access to video tutorials, webcasts, and other resources to help you get started, see the Data Mining for Add-ins for Office 2007 page on the Microsoft Web site.

[Top]

3.0 Obtaining the Data Mining Add-Ins for Office 2007

To obtain the Data Mining Add-Ins for Office 2007, see the Microsoft SQL Server 2005 Data Mining Add-ins for Office 2007 page on the Microsoft Download Center.

[Top]