Microsoft® SQL Server® 2012 Data Mining Add-ins for Microsoft® Office® 2010

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

• Table Analysis Tools for Excel: This add-in provides easy-to-use tasks that leverage SQL Server 2012 data mining models within Excel 2010 using either your spreadsheet data or external data accessible through your SQL Server 2012 Analysis Services instance.
• Data Mining Client for Excel: By using this add-in, you can create, test, explore, and manage data mining models within Excel 2010 using either your spreadsheet data or external data accessible through your SQL Server 2012 Analysis Services instance.
• Data Mining Templates for Visio: This add-in enables you to render and share your mining models as annotatable Visio 2010 drawings.

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

Supported Operating Systems

Windows 7, Windows Server 2008 R2, Windows Server 2008 Service Pack 2, Windows Vista Service Pack 2

• Microsoft .NET Framework 4.0.
• If installing the Table Analysis Tools or Data Mining Client for Excel, Microsoft Office 2010 with .NET Programmability Support. Supported editions of Office 2010 include:


• Professional
• Professional Plus
• Ultimate
• Enterprise

• If installing the Data Mining Templates for Visio, Microsoft Visio Professional 2010 with .NET Programmability Support.
• 40 MB of available hard disk space.
• Note: The Data Mining Add-ins require a connection to one of the following editions of SQL Server 2012 Analysis Services:
• Enterprise
• Business Intelligence
• Standard

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 2010 installed.

Step 2: If you do not already have Microsoft .NET Framework 4.0, download and install the Microsoft .NET Framework 4.0 that matches the machine architecture (32-bit or 64-bit) of your Office 2010 installation.

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 2010 Setup from Add/Remove Programs in Control Panel.

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 2010 Setup from Add/Remove Programs in Control Panel.

Step 3: Download the appropriate version of the Data Mining Add-ins that matches the machine architecture (32-bit or 64-bit) of your Office 2010 installation by clicking the download 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.

If you have questions about SQL Server 2012, please visit the SQL Server 2012 forums on MSDN. Your feedback is important. Help improve SQL Server 2012' by submitting bugs to Microsoft Connect.