Migrating the SQL Server Reporting Services Platform to Amazon QuickSight for Cloud-Native Business Intelligence
Blog
This article explains how customers can migrate their Microsoft SQL Server Reporting Services (SSRS) platform to Amazon QuickSight, a cloud-native business intelligence (BI) solution on AWS. It highlights the benefits of QuickSight over SSRS, such as interactive visuals, charts, and natural language query capabilities.
Specifically, the article covers:
- The recommended architecture for SSRS migration to a data lake on AWS using services like AWS Lake Formation, AWS Glue, Amazon Athena, and QuickSight
- Best practices for SSRS migration, including converting SSRS queries to AWS Glue jobs, implementing row-level security in QuickSight, and enhancing reports with visuals and ML capabilities
- A tool developed by IPsense, an AWS Partner, that automates the conversion of SSRS reports into SQL queries for building QuickSight datasets
- The benefits of using Amazon QuickSight with a data lake, such as faster performance, reliability, scalability, and secure sharing of dashboards
- Conclusion highlighting IPsense's expertise in implementing data lakes and reporting solutions on AWS, and its tool's ability to streamline SSRS report conversions to QuickSight
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.