SSRS, SSIS, and SSAS are all products/services offered by Microsoft. Different services comes in different editions.

SQL Server Reporting Services (SSRS)

Provide a framework of reporting mechanisms such as the Report Builder, Report Designer, Report Manager, and Report Server that work together through a web interface to enable the development of interactive reporting solutions. Report Builder and Report Designers are components used for creating and generating reports. Report Server is the core process engine. Report Manager is the admin tools used to control reporting through a web interface.

SQL Server Integration Services (SSIS)

Equipped with Extract, Transform and Load (ETL) capabilities. Provides a way to move data from different data sources to another and changing of the data if necessary. There are 3 components: Import/Export Wizard, SSIS Designer, and SSIS API Programming module. Import/Export Wizard simply transfer data from source to destination. SSIS Designer is an integrated component of the Business Intelligence Development Studio used for the development and maintenance of integration services packages. SSIS API Programming module allows you to code SSIS packages using any number of programming languages.

SQL Server Analytic Services (SSAS)

SSAS is a multidimensional analysis tool that features powerful data mining capabilities. Provides online analytic processing of data from disparate data sources. SSAS enables the discovery of data patterns that may not be immediately apparent through the data mining features built into the product. Use of cubes and dimensions to help make sense and organize data. Gives the ability to analyze large quantities of data by storing data in axes and cells instead of the traditional relational two-dimensional views. Integrate with Microsoft Excel and SharePoint to analysis and visual presentation.


Last modified: March 22, 2019



Write a Reply or Comment