The Business Intelligence (BI) platform has been changing with each new version of SQL.
In the beginning, it was part of the SQL Server setup.
Since SQL Server 2014 BI platform started to be distributed separately.
The name of this tool and its installation method started to vary from version to version of Visual Studio (VS).
To install the SQL Server Data Tools 2017, you just need to download and execute. However, process has changed in the 2019 version.
I will show you all the processes of installing and configuring the SQL Server 2019 Business Intelligence development environment.
Download and install Visual Studio 2019
The first step is to download the Visual Studio 2019 Community from here: Download Visual Studio Tools.
Start the installation process.
Chose Data storage and processing
Select SQL Server Data Tools. Here is a quick video:
When the installation is complete, download the VS extensions. Three services – SSIS, SSRS, and SSAS – have been moved out of the standalone SSDT and introduced as extensions.
Add new extensions to Visual Studio
- Open the Visual Studio
- click on Continue without code
- go to Extensions
- then Manage Extensions
In the search bar of the opened window, type “SSDT” to locate all the SSDT extensions. From the list that appears, select one and click Download.
After downloading the extension, close the Visual Studio and execute the downloaded .exe file.
Follow the steps, and repeat for each service you need to install (SSIS, SSRS, and SSAS).
When the setup is completed, you can open the VS again.
Creating a new project in Visual Studio
In Visual Studio, choose Create a new project search for the type (e.g. Integration Services Project), and click on it, as shown below:
Your development environment is now set up!
Now you can create reports in Reporting Services (SSRS), load data using Integration Services (SSIS), and develop and deploy models in Visual Studio with Analysis Services (SSAS) projects.
Speak with a SQL Expert
In just 30 minutes, we will show you how we can eliminate your SQL Server headaches and provide operational peace of mind
