You are currently viewing 5.1 SSIS SSAS SSRS

5.1 SSIS SSAS SSRS

What is SSIS?

SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data.

SSIS – SQL Server Integration Services

http://technet.microsoft.com/en-us/library/ms141026.aspx

What is SSAS?

SQL Server Analysis Services (SSAS) is the technology from the Microsoft Business Intelligence stack, to develop Online Analytical Processing (OLAP) solutions. In simple terms, you can use SSAS to create cubes using data from data marts / data warehouse for deeper and faster data analysis.

 

What is SSRS?

SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. It is part of suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services).

Extras:

SSRS SQL Server Reporting Services – An add on – In order to apply the concepts in this article, you will need SQL Server 2008 with Reporting Services installed. In addition, you will need either Visual Studio 2008 or 2010 with either ASP.NET MVC 1.0 or 2.0 installed.

http://nileshpupadhyay.blogspot.com/2008/05/simple-steps-for-developing-ssrs-report.html

http://www.codemag.com/Article/1009061