The Business Intelligence platform has been changing on each new version.
In the beginning, it was part of the SQL Server setup, and then since SQL Server 2014 started to be distributed separately.
Also, the name of this tool and its installation method started to vary from version to version of Visual Studio (VS).
For installing the SQL Server Data Tools 2017, you need only download and execute. However, everything has changed in the 2019 version.
This post aims to show all the processes of installing and configuring the SQL Server 2019 Business Intelligence development environment.
Download and install the Visual Studio 2019
The first step is to download the Visual Studio 2019 Community:
During the installation process of Visual Studio 2019, select “SQL Server Data Tools” under Data Storage and processing, as shown below:
When the installation is complete, you will need to download VS extensions since all three services ( SSIS, SSRS, and SSAS) have been moved out of standalone SSDT and merged (introduced) with extensions.
Add new extensions to VS
Open the Visual Studio and click on “Continue without code”, go to Extensions -> Manage Extensions;
In the search bar of the opened window, type “SSDT” to easily locate all the SSDT extensions. From the appeared list, choose one and press “Download”.
After download the extension, close the visual studio and execute the downloaded .exe file.
Fallow the simple steps, repeat the process for all the services that you need install (SSIS, SSRS, and SSAS).
When the setup is completed, you can open the VS again.
Creating a new project
In Visual Studio, choose “Create a new project” and search for the type (e.g. Integration Services Project) and click on it, as show below:
It`s ready! Your development environment is complete.
Now you can create reports on Reporting Services, load data using Integration Services, and develop and deploy models with Visual Studio with Analysis Services projects.