What is Microsoft SSRS, SSIS and SSAS?

image_pdfimage_print

SQL Server Reporting Services (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. Report Builder and Report Designer are two SSRS components for generating reports. Report Builder is a simple solution for the information worker or business user to create quick reports without the need to understand the core structure of the data. The Report Designer is a tool for developers because it adds complexity to custom reports development. Using this tool requires an understanding of the Business Intelligence Development Studio shell in Visual Studio and the underlying structure of the data. According to Microsoft, the Report Server is the core process engine in SSRS that manages the processing and delivery of reports using processors. The Report Manager is an administrative tool that controls reporting services through a Web interface.

SQL Server Integration Services (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. It provides the vehicle for moving data from different data sources to another and changing the data, if necessary. The three components in the SSIS platform for starting the data integration process are the Import and Export Wizard, SSIS Designer and SSIS API Programming. The Import and Export Wizard simply transfers data from source to destination but does not include data transformation capabilities. The 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 Analysis Services (SSAS)

The SQL Server Analysis Services, or SSAS, is a multidimensional analysis tool that features Online Analytical Processing, powerful data mining capabilities, and deeper dimensions to business information within a relational database. Multidimensional analysis is an OLAP technique that produces the ability to analyze large quantities of data by storing data in axes and cells instead of the traditional relational two-dimensional view in rows and columns. SSAS places predictive analytic capabilities in the hands of information workers by creating an instant connection to backend data using familiar applications such as Microsoft Excel and SharePoint for analysis, visual presentation and collaboration.

Hassle-free Email Migration & Conversion

image_pdfimage_print

This useful program solves a problem most of us have often wrestled with: If you’re moving to a new e-mail client, how can you get all your old e-mails into your new software? It solves the problem neatly by taking you through a few simple steps. It will convert your old mail to your new client’s format, and you can then import the mail using the new client’s normal import routine.

The program makes it simple to export e-mail messages. Tell it which e-mail client you use, and it will automatically find the proper location for your folders, then give you a choice of which folders you want to export. Then choose the e-mail client to which you’re going to export your mail, and it does the trick. One caveat: If you want to use Microsoft Outlook, you must have that program installed.

Aid4Mail-From-Thunderbird

more information: Aid4Mail