More capacity and flexibility
To address its capacity issues, JOT analyzed several competitive cloud solutions. “None offered the combination of throughput, processing power, and analytical quality of Synapse Analytics,” says Perales. “Plus, since we were already using SQL Server on-premises, moving to Synapse Analytics was a natural transition.”
As Elias Badenes, JOT Media Big Data Lead, adds, “We saw that Azure Synapse Analytics had both the capacity and tools to help us implement the calculations and KPIs we needed.”
The JOT team was immediately impressed with the flexibility of the solution. “Because we only pay for what we need, we were able to plan our architecture without having to commit right away to those projected needs,” Perales notes. “This allowed us to build our ideal architecture, then fine-tune the system as we went along to achieve the best balance of efficiency and cost.”
The team started with the migration of over 7 terabytes (TB) of historical data stored on-premises to Azure Synapse Analytics. Ongoing campaign statistics are loaded into Azure Synapse Analytics, which generates KPIs based on recommendations from JOT. Azure Data Factory is used to automate all processes. This includes importing and historicizing of data using PolyBase technology, in addition to execution of all procedures necessary for generating reports.