The Microsoft Analysis Services client libraries encapsulate application programming interfaces (APIs) to authenticate and exchange requests and responses with Microsoft SQL Server Analysis Services 2005 or higher, Microsoft Azure Analysis Services, and Microsoft Power BI.
Microsoft Analysis Services client libraries include the following setup packages: Microsoft Analysis Services ADOMD.NET Microsoft Analysis Services OLE DB Provider (MSOLAP) Microsoft Analysis Management Objects (AMO)
Microsoft SQL Server Backup to Windows Azure Tool enables backup to Windows Azure Blob Storage and encrypts and compresses SQL Server backups stored locally or in the cloud.
The SQL Server Data-tier Application framework (DacFx) is a .NET component that provides application lifecycle services for database development and management and is available in the SqlPackage CLI and as a NuGet package. The Data-tier Application Framework includes TransactSql.ScriptDOM.
SQL Server Management Objects (SMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer SQL Server objects and services.
The SQL Server System CLR Types package contains the components implementing the geometry, geography, and hierarchy ID types in SQL Server. Note: This component also requires Windows Installer 4.5.
The Microsoft Windows PowerShell Extensions for SQL Server include a provider and a set of cmdlets that enable administrators and developers to build PowerShell scripts for managing instances of SQL Server.
The SQL Server Remote Blob Store is a method for storing blobs of unstructured data in an external Content Addressable data store. The component consists of a client-side DLL that is linked into a user application, and a set of stored procedures to be installed on SQL Server.
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.
The Microsoft OLE DB Provider for DB2 v5.0 offers a set of technologies and tools for integrating vital data stored in IBM Db2 databases with new solutions. SQL Server developers and administrators can use the data provider with integration Services, Analysis Services, Replication, Reporting Services, and Distributed Query Processor. Read the Installing Data Provider section of the product documentation, which is available on-line or as a download.
Report Builder provides a productive report-authoring environment for IT professionals and power users. It supports the full operational reporting capabilities of SQL Server Reporting Services.
Reporting Services Add-in for Microsoft SharePoint technologies allows you to integrate Reporting Services features with the collaborative SharePoint experience.
SQL Server Data Tools is a modern development tool for building SQL Server relational databases, Azure SQL databases, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.
Did you know that you can edit SQL content yourself? If you do so, not only do you help improve our documentation, but you also get credited as a contributor to the page.
SQL Server 
Contribute to SQL documentation