Lawrence Avery
asked on
SSIS SSAS and SSRS
I loaded SQL Server 2014 for Developers and I see the following services running:
SSIS
SSAS
SSRS
How do I connect to them? In other words, I guess I need an IDE or interface. I am trying to learn Business Intelligence.
SSIS
SSAS
SSRS
How do I connect to them? In other words, I guess I need an IDE or interface. I am trying to learn Business Intelligence.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I am confused. What is the difference between SSDT and SSDT-BI ?
SSDT – for building databases
SSDTBI – for building SSIS/SSAS/SSRS solutions
SSDTBI – for building SSIS/SSAS/SSRS solutions
ASKER
Did Arif really mean SSDT-BI? I downloaded SSDT for Visual Studio 2013.
I do not have Visual Studio 2013 but it says for SQL Server 2014 use SSDT for Visual Studio 2013.
I get the VS 2013 Shell ( integrated) IDE. It has the following project types:
Analysis Services Multidimensional and Data Mining Wizard.
Integration Service Project
Report Server Project
Report Server Project Wizard
Analysis Tabular Service Project
Am I on the correct IDE? I am using SQL Server 2014 for my database work.
I do not have Visual Studio 2013 but it says for SQL Server 2014 use SSDT for Visual Studio 2013.
I get the VS 2013 Shell ( integrated) IDE. It has the following project types:
Analysis Services Multidimensional and Data Mining Wizard.
Integration Service Project
Report Server Project
Report Server Project Wizard
Analysis Tabular Service Project
Am I on the correct IDE? I am using SQL Server 2014 for my database work.
ASKER
great
But SSDT is backwards compatible.
Here is the official MS link.
Download SQL Server Data Tools (SSDT)