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

Microsoft SQL Server 2012 SP1 Data Mining Add-ins for Microsoft Office helps you take advantage of SQL Server predictive analytics in Office Excel and Office Visio. 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 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 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 drawings.

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

Supported Operating Systems

Windows 7, Windows 8, Windows Server 2003 Service Pack 2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Vista Service Pack 2

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


• Professional
• Professional Plus
• Ultimate
• Enterprise

• If installing the Data Mining Templates for Visio, Microsoft Visio Professional 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 or 2013 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 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 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.


The new version (11.0.3129.0) of these msi's have been released to address the issue mentioned in KB2793634