About Client
One of Poland’s most popular and preferred sports betting companies that kickstarted operations in 2019
Challenge
The client wanted an efficient reporting system on Microsoft Azure ecosystem to support their rapidly expanding business.
Our Solution
The client was using PostgreSQL which was primarily designed as a row-based RDBMS which would inevitably affect the performance and scalability of the database. Hence, data was replicated from PostgreSQL to Azure SQL using Azure Data Factory.
An Enterprise Data Warehouse was built using Azure SQL Server configured with continuous refresh for shorter latency (near real-time updates as new data becomes available)
Reports were made available instantly for the end users using SSRS for visual reporting
An additional capability of Auto Reset was included within the architecture to ensure the client’s development team could be more focussed on other core activities. The auto rest feature instantly notifies the team incase of any failure of Azure Jobs.
-
Azure SQL: A scalable, reliable and high performance RDBMS solution
-
Azure Data Factory: A data integration tool that is used for orchestrating data integration and transformation workflows
-
Azure SQL Server: A data warehousing solution known for its security and hybrid cloud capabilities
-
SSRS: Widely used Microsoft tool for its powerful and flexible reporting solutions
Outcome
Would You Like Us To Contact You?