One of Poland’s most popular and preferred sports betting companies that kickstarted operations in 2019
The client wanted an efficient reporting system on Microsoft Azure ecosystem to support their rapidly expanding business.
- 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
Would You Like Us To Contact You?