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.
Visual Studio 2017: It is an integrated development environment (IDE) which allows us to develop various project types in different programing languages. SQL Server Data Tools: It is also known as SSDT, another required tool to develop SQL unit testing projects. SSDT allows us to develop SQL Server database projects and it also provides. SQL Server Data Tools (SSDT) is a Microsoft Visual Studio environment for creating business intelligence solutions. SSDT features the Report Designer authoring environment, where you can open, modify, preview, save, and deploy Reporting Services paginated report definitions, shared data sources, shared datasets, and report parts.
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:
https://visualstudio.microsoft.com/downloads/
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.
Ssdt In Visual Studio 2015
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.
How To Use Ssdt In Visual Studio
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:
Ssdt In Visual Studio 2012
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.