SQL Server Data Tools for Business Intelligence

The tools previously known as Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDT) have been replaced in SQL Server 2014 by SQL Server Data Tools for BI (SSDT BI). SSDT BI is used to create SQL Server Analysis Services (SSAS) models, SQL Server Reporting Services (SSRS) reports, and SQL Server Integration Services (SSIS) packages. SSDT BI is based on Microsoft Visual Studio 2012 and supports SSAS and SSRS for SQL Server 2014 and earlier, but SSIS projects are limited to SQL Server 2014. However, SSDT BI cannot be installed using the SQL Server 2014 Setup. Instead, you must download it separately from the Microsoft Download Center. The SQL Server Installation Center provides ...

Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.