You must Sign In to post a response.
  • Category: SQL Server

    What are the Difference between SSRS,SSIS,SSAS ?


    Are you looking for a way to know about Difference between SSRS,SSIS,SSAS ? then read this thread to know more about it



    Dear All,

    Kinldy clarify me what is the excat difference between SSIS,SSRS,SSAS. If u have any example for differencing that, Kindly share with me.
  • #756335
    SQL is handling more other addon rather than database only, with the help of SQL we can do data integration, reporting and analysis like things.
    SSRS :
    The SQL Server Reporting Services (SSRS) is 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 concise interactive reporting solutions in print or Web format
    SSIS :
    The SQL Server Integration Services (SSIS) is the data-warehousing arm of the SQL Server 2008 R2 suite -- equipped with superior Extract, Transform and Load (ETL) capabilities

    Thanks
    Koolprasd2003
    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]

  • #756342
    SQL Server Integration Services (SSIS) is a component of SQL Server which can be used to perform a wide range of Data Migration and ETL operations. SSIS is a component in MSBI process of SQL Server.
    This is a platform for Integration and Workflow applications. It is known for a fast and flexible OLTP and OLAP extensions used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and multidimensional data sets.


    SQL Server Reporting Services (SSRS) provides the ability to create highly formatted, print-ready and interactive reports and dashboards. SSRS offers a powerful style of reporting that graphically depicts performances measures with intuitive and interactive displays. SSRS is known for its user friendly visualization components such as gauges, sliders and maps, and KPIs that are required for any business.


    SQL Server Analysis Services (SSAS) provides interactive data visualization and search-based data discovery solutions with local and geo-spatial inlligence. Paired with KPIs and indicators, SSAS offers us embedded mining and businessforecasting solutions. SSAS Online Analytical Processing (OLAP) offers Cube Design, Hosting, Deployment, Management, End User usage and enrichjed security features at granular levels.

  • #756355
    SSRS stands for SQL Server Reporting Services. SSRS is used to create and manage Web-enabled reporting service. It is used to create and generate reports, to retrieve data from various data sources, and to publish reports in various formats.

    SSIS stands for SQL Server Integration Services. SSIS has the ability to gather data from various resources in different kinds of formats, process this data, transform data and convert the processed data into any shape that you can use in your daily business as well as for data-mining and data warehouse applications.

    SSAS stands for SQL Server Analysis Services. It stores, processes and secures data. It delivers OLAP (Online Analytical Processing) and data mining functionalities for applications. It is used to design, create and manage multi-dimensional structures that contain data aggregated from other data sources.

  • #756361
    Dear All,

    Thank you for sharing the Difference between SSIS,SSRS,SSAS. I'm also got few difference regarding that. Am also sharing with you..

    Difference between SSIS, SSRS and SSAS
    SSIS: SQL Server Intergration services:
    1. We can process the data from various locationsĀ and various formats (source locations) and save the data into a centralized repository as a Data Warehouse/Data Mart (destination).
    2. It is a data warehousing tool Used for ETL.(Extraction, Transformation, and Loading)...

    SSRS: SQl Server reporting services:
    1. It is a framework of reporting mechanism such as the Report Builder, Report Designer, Report Manager and Report Server that work together through a web interface to enable the development of concise interactive reporting solutions in print or web format.
    2. To achieve Web-enabled and Enterprise reporting functionality we are using this..


    SSAS: SQL Server Analysis services:
    1. It is a multidimensional analysis tool that features Online Analytical Processing, Powerful data mining capabilities and deeper dimensions to business information within a relational database.
    2. Multidimensional analysis is OLAP techniques that produce the ability to analyze large quantities of data by storing data.
    3. It is for Data warehousing and Business Intelligence..Features are OLAP and Data mining...


  • Sign In to post your comments