What is the difference between SSIS, SSRS and SSAS?


SSIS:

SQL Server Integration Services (SSIS) is a platform for building high performance data integration solutions, including the extraction, transformation, and loading (ETL) of packages for data warehousing. SSIS is the new name assigned to the component formerly branded as Data Transformation Services (DTS).

SSIS (SQL Server Integration Services) is an upgrade of DTS (Data Transformation Services), which is a feature of the previous version of SQL Server. SSIS packages can be created in BIDS (Business Intelligence Development Studio). These can be used to merge data from heterogeneous data sources into SQL Server. They can also be used to populate data warehouses, to clean and standardize data, and to automate administrative tasks.

SSRS:

It creates and manages Web-enabled reporting services. It is used to create and generate reports, to retrieve data from various data sources, and to publish reports in various formats.

SQL Server Reporting Services provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend and customize your reporting functionality.

With Reporting Services, you can create interactive, tabular, graphical, or free-form reports from relational, multidimensional, or XML-based data sources. You can publish reports, schedule report processing, or access reports on-demand. Reporting Services also enables you to create ad hoc reports based on predefined models, and to interactively explore data within the model. You can select from a variety of viewing formats, export reports to other applications, and subscribe to published reports. The reports that you create can be viewed over a Web-based connection or as part of a Microsoft Windows application or SharePoint site. Reporting Services provides the key to your business data.

SSAS:

SQL Server Analysis Services (SSAS) enables BI (Business Intelligence) workers to work on multi-dimensional data in SQL Server which can be gathered from different kinds of resources like flat files to relational databases.
SSAS (SQL Server Analysis Services) has the ability to analyse data grouped and aggregated into different formats and views like the faces of a cube.
A SSAS application adds the value of data analysis and represents the data in the format of OLAP cubes, OLAP reporting or data mining features.

Keep Teaching!

Leave a comment

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.