Beta Customer
How a multi-jurisdictional organization migrated 190+ SSRS paginated reports from SQL Server to PostgreSQL and Domo — with 97% automated conversion and zero report redesign.
Organization Profile
The Challenge
The organization operates across 25+ regional offices with complex regulatory and compliance reporting requirements. Over the years, their teams had built a library of 190+ paginated SSRS reports — encoding jurisdictional compliance logic, operational forms, and business process knowledge that could not simply be recreated in a dashboard tool.
Microsoft confirmed that SSRS will not receive new versions. SQL Server 2025 replaces SSRS with Power BI Report Server. The organization needed to decommission SSRS and SQL Server simultaneously while preserving every report layout and migrating to PostgreSQL on AWS — their strategic data platform.
Rebuilding 190+ paginated reports in Domo or another BI tool was estimated at 12-18 months and carried significant risk of formatting regressions in regulated output. The Power BI path would have preserved Microsoft lock-in and introduced Azure dependencies incompatible with their AWS-first strategy.
The team evaluated seven migration paths in a rigorous internal assessment. They needed a solution that could achieve four goals simultaneously: eliminate SSRS, eliminate SQL Server, stay on AWS, and consolidate reporting inside Domo — their existing analytics platform.
The Solution
ReportBridge — Domo + ReportBridge Report Server on AWS — ranked #1 of the seven options evaluated. It is the only path that preserves existing RDL layouts, eliminates all Microsoft dependencies, runs entirely on AWS, and delivers reports through Domo as a unified analytics platform.
AI-Powered SQL Conversion
Anthropic Claude via AWS Bedrock converts T-SQL to PostgreSQL with schema-aware context. Each query is validated against the live database with an automated test/fix loop — up to 5 iterations per report.
Shared Data Sources
4 shared data sources on the report server replaced inline credentials across 164 reports. Zero passwords stored in report files. Credentials managed centrally in AWS Secrets Manager.
Group-Based Access Control
Domo groups map directly to report visibility. Server-side enforcement ensures users only see authorized reports — fail-closed security with no client-side bypasses.
Dual-Source Viewer
The viewer renders both SQL Server and PostgreSQL reports side by side during migration. Teams validate fidelity before decommissioning SQL Server — no big-bang cutover required.
Enterprise Security
VPC-isolated Lambda functions, parameterized SQL queries, DDL/DML blocking, HMAC-signed viewer tokens, API Gateway throttling, and CloudWatch monitoring with SNS alerting.
Batch Operations
Multi-select and bulk publish from the Admin library. Full audit log tracks every conversion, publish, and configuration change. Config backup and restore with JSON export/import.
Results
190+
SSRS reports in scope
97%
automated conversion rate
167
reports live on PostgreSQL
16
unsupported (VB.NET custom code)
What was eliminated
- SQL Server licensing costs across the reporting layer
- Windows Server dependency for report rendering
- SSRS operational burden (patching, configuration, IIS)
- Redundant AWS account (~$53/month infrastructure savings from 3-to-2 account consolidation)
What was preserved
- 100% layout fidelity — pixel-perfect pagination, headers, footers, groupings, and page breaks
- Parameterized reports — the report server renders parameters natively
- Existing Domo group-based access control model
- Regulatory and compliance formatting requirements across 25+ regional offices
Timeline
Migration options assessment
Evaluated 7 migration paths. Option 7 (Domo + ReportBridge Report Server on AWS) ranked #1 — the only path that eliminates SSRS, SQL Server, and Windows dependencies simultaneously.
Proof of concept validated
4 representative reports (simple, grouped, sub-report, matrix/chart) rendered with full fidelity on the report server. Embedding inside Domo Pro Code confirmed.
AI conversion pipeline operational
Batch T-SQL to PostgreSQL conversion with automated test/fix loop. 164 of 169 applicable reports passed automated validation — 97% pass rate.
Infrastructure consolidated
Migrated from a 3-account AWS architecture to a streamlined 2-account model — customer data in one account, SaaS platform in the other. Eliminated ~$53/month in redundant infrastructure.
Production-ready
167 PostgreSQL reports and 11 demo reports live. Admin v1.5.0 with 10-step setup wizard, AI model configuration, and org-level access control. Viewer v2.3.0 with category navigation and deep linking.
“190+ SSRS reports migrated to PostgreSQL in under 8 weeks with a 97% automated conversion rate — zero report redesign required.”
— ReportBridge Beta Program, 2026
Facing the Same Challenge?
Whether you have 50 reports or 500+, ReportBridge migrates your SSRS library to PostgreSQL and Domo with AI-powered automation and zero report redesign.