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)
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.
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 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.
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.