Microsoft SSRS vs QlikView: What are the differences?

<Microsoft SSRS vs QlikView>

1. **Data Source Connectivity**: Microsoft SSRS supports a wide range of data sources including SQL Server, Oracle, ODBC, OLE DB, and others, while QlikView has a unique associative data model that enables users to easily connect to multiple data sources and create relationships on the fly.
2. **Data Visualization**: SSRS provides basic charting and graphing capabilities, whereas QlikView offers more advanced and interactive data visualization options such as associative selection, dynamic filtering, and drill-down capabilities.
3. **Collaboration and Sharing**: SSRS allows users to share reports via email, SharePoint, and subscriptions, while QlikView offers more collaborative features with its Qlik Sense platform that enables real-time data sharing and commenting on visualizations.
4. **Interactive Analysis**: QlikView allows for more interactive and exploratory analysis with its in-memory technology that allows users to quickly slice and dice data without having to rely on pre-aggregated data sets, while SSRS may require the use of pre-built reports for specific analyses.
5. **Deployment Options and Scalability**: SSRS can be deployed on-premises or in the cloud with Azure, while QlikView offers both on-premises and cloud deployment options, with Qlik Sense offering a more scalable and flexible cloud solution.
6. **Cost and Licensing**: Microsoft SSRS is typically included as part of SQL Server licensing, making it more cost-effective for organizations already using SQL Server, whereas QlikView requires separate licensing and may be more costly for smaller organizations. 

In Summary, Microsoft SSRS and QlikView differ in terms of data source connectivity, data visualization capabilities, collaboration features, interactive analysis options, deployment scalability, and cost considerations.