The Challenge
A multinational company wanted to benefit from using data warehouse services, advanced analytics, data mining, and reporting, by migrating from an on-premise Oracle-based platform into a scalable cloud data warehouse solution. The solution to be migrated had two terabytes-sized Oracle databases. Advanced analytics queries were in many cases timing out and underlying infrastructure had to be optimized for OLAP rather than OLTP.
How It Was Solved
Azure Synapse platform was used as a data warehouse solution for OLAP. Oracle data was moved using Azure Data Factory workbooks. All OLTP-specific workloads were migrated to Azure SQL Managed Instance.
The Results
The final solution provided unparalleled scalability and improved performance running advanced queries using MPP capabilities of Azure Synapse. The performance of OLTP operations was greatly improved by using SQL Managed Instance capabilities. Data Warehouse and Operational Database were tightly integrated and synchronized using ETL capabilities of Azure Data Factory.
Interest-Centric UI is revolutionizing the way small businesses in the US manage 401k plans for their employees. One of our clients needed to improve their user experience in a new mobile interface adapted to support a variety of devices. This required a mobile-friendly application that would support and enhance credibility with customers, clients, and influencers. They wanted to improve the existing web application with a new look and feel that could scale efficiently on across mobile devices. The challenge for Intellinez was to provide an exceptionally immersive experience while driving additional data and analytics, resulting in a higher rate of user engagement.
A multinational company wanted to benefit from using data warehouse services, advanced analytics, data mining, and reporting, by migrating from an on-premise Oracle-based platform into a scalable cloud data warehouse solution. The solution to be migrated had two terabytes-sized Oracle databases. Advanced analytics queries were in many cases timing out and underlying infrastructure had to be optimized for OLAP rather than OLTP.