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

The Microsoft SQL Server 2016 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft SQL Server.

The Microsoft SQL Server 2016 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft SQL Server. It includes the latest versions of:

• Tool and components for Microsoft® SQL Server 2016.
• Add-on providers for Microsoft SQL Server 2016

Files

Status: Deleted This download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to April 2023.

Files
AttunityOracleCdcDesigner.msi
AttunityOracleCdcDesigner.msi
AttunityOracleCdcService.msi
AttunityOracleCdcService.msi
MasterDataServicesExcelAddin.msi
MasterDataServicesExcelAddin.msi
ReportBuilder3.msi
rsSharePoint.msi
SapBI.msi
SapBI.msi
spPowerPivot.msi
spPowerPivot16.msi
SQL_AS_ADOMD.msi
SQL_AS_ADOMD.msi
SQL_AS_AMO.msi
SQL_AS_AMO.msi
SQL_AS_OLEDB.msi
SQL_AS_OLEDB.msi
SsisAzureFeaturePack_2016_x64.msi
SsisAzureFeaturePack_2016_x86.msi

System requirements vary among the install packages included in the Feature Pack.
Note: When an MSI package is redistributed it must not be renamed, otherwise you may see failures if updates are installed for that package.

The Master Data Services Add-in for Excel gives multiple users the ability to update master data in a familiar tool without compromising the data’s integrity in MDS. From within the Add-in, users can publish data to the MDS database with the click of a button. Administrators can use the Add-in to create new model objects and load data without ever launching any administrative tools, helping to speed deployment. With the Master Data Services Add-in for Excel, all master data remains centrally managed in MDS, while the ability to read or update the data is distributed to those who need it.

The Master Data Services (MDS) Add-in for Microsoft Excel is a data management tool that delivers a multitude of master data management capabilities with ease and efficiency. Manage MDS data within an interface you already know and love Microsoft Excel. Leverage existing Excel functionality to share your managed lists with others, knowing these lists can be secured and monitored with all of the features provided by Master Data Services.

Microsoft Change Data Capture Designer and Service for Oracle by Attunity allow you to continually copy data from Oracle to SQL Server. This can be useful in both migration and data warehouse scenarios by allowing you to both; synchronize critical tables throughout the migration timeframe by copying changes made to the Oracle tables into the SQL Server tables as well as capture changes from your Oracle database and send them to SQL Server databases to keep data warehouses in sync.

Filename (X86 and X64 Package)(AttunityOraleCdcService.msi)
Filename (X86 and X64 Package)(AttunityOraleCdcDesigner.msi)

The Microsoft Connector for SAP BW is a set of managed components for transferring data to or from an SAP NetWeaver BW version 7.0 system. The component is designed to be used with SQL Server Integration Services. To install the component, run the platform-specific installer for x86 or x64 respectively. For more information see the Readme and the installation topic in the Help file.

Filename: X86 and x64 Package(SAPBI.msi)

ADOMD.NET is a Microsoft .NET Framework object model that enables software developers to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2016 Analysis Services. ADOMD.NET is a Microsoft ADO.NET provider with enhancements for online analytical processing (OLAP) and data mining.

Note:The English ADOMD.NET setup package installs support for all SQL Server 2016 languages.

Filename: X86 and x64 Package(SQL_AS_ADOMD.msi)

The Analysis Services OLE DB Provider is a COM component that software developers can use to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2016 Analysis Services. This provider implements both the OLE DB specification and the specification’s extensions for online analytical processing (OLAP) and data mining.

Note: Microsoft Analysis Services OLE DB Provider requires Microsoft Core XML Services (MSXML) 6.0

Filename: X86 and x64 Package(SQL_AS_OLEDB.msi)

Analysis Management Objects (AMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer Analysis Services objects.

Filename: X86 and x64 Package(SQL_AS_AMO.msi)

Report Builder provides a productive report-authoring environment for IT professionals and power users. It supports the full operational reporting capabilities of SQL Server 2016 Reporting Services. The download provides a stand-alone installer for Report Builder.

Reporting Services Add-in for Microsoft SharePoint technologies allows you to integrate Reporting Services features with the collaborative SharePoint experience.

Microsoft SQL Server 2016 PowerPivot for SharePoint 2013 extends SharePoint Server 2013 to add server-side data refresh processing, collaboration, and management support for PowerPivot workbooks.

Microsoft SQL Server 2016 PowerPivot for SharePoint 2016 extends SharePoint Server 2016 to add server-side data refresh processing, collaboration, and management support for PowerPivot workbooks.

The Microsoft JDBC Driver for SQL Server provides access to SQL Server from any Java application, application server, or Java-enabled applet.

The Microsoft ODBC Drivers for SQL Server provides native connectivity from Windows and Unix to Microsoft SQL Server and Microsoft Azure SQL Database.

• Microsoft® ODBC Driver 11 for SQL Server® - Windows
• Microsoft® ODBC Driver 13 (Preview) for SQL Server® – Windows
• Microsoft® ODBC Driver 13 (Preview) and 11 for SQL Server® – RedHat Linux
• Microsoft® ODBC Driver 13 (Preview) and 11 for SQL Server® – SUSE Linux
• Microsoft® ODBC Driver 13 (Preview) for SQL Server ® – Ubuntu Linux

The Microsoft Drivers for PHP for SQL Server are PHP 5 extensions that allows for the reading and writing of SQL Server data from within PHP scripts. The SQLSRV extension provides a procedural interface while the PDO_SQLSRV extension implements PDO for accessing data in all editions of SQL Server 2005 and later.