Business Intelligence in SQL Server 2014 - SQL Server Data Tools (SSDT)

 

Updates to Design Tool installation


 

SQL Server Data Tools for Business Intelligence (SSDT BI), previously known as Business Intelligence Development Studio (BIDS), is used to create Analysis Services models, Reporting Services reports, and Integration Services packages. In this pre-release version of SQL Server 2014, SQL Server Setup no longer installs SSDT BI. The Visual Studio 2012 version of SSDT BI is now available as a web download from the Microsoft Download center.

If you have a prior version of SSDT BI or BIDS installed on your computer, the newer version is installed side-by-side with the previous version. It's common to run newer and older versions of the design tools on a single workstation so that you can modify projects and solutions tied to specific versions of the server.

New Project templates in SSDT

See more information here: https://msdn.microsoft.com/en-us/library/bb522628(v=sql.120).aspx

   - Ninja Ed