• <1 minute

How Catania secures public data with Azure SQL Data Warehouse

Digital transformation is a key theme for public sector today. Government organizations big and small, want to leverage cloud technologies to deliver improved citizen services while keeping costs under control. However, security and compliance especially when dealing with a large amount of citizen data is crucial.

Digital transformation is a key theme for public sector today. Government organizations big and small, want to leverage cloud technologies to deliver improved citizen services while keeping costs under control. However, security and compliance especially when dealing with a large amount of citizen data is crucial.

The municipality of Catania in Italy, that serves over a million people, wanted to build a streamlined management and storage of public service operations data. They also wanted to safeguard against any potential damage to their physical datacenter and ensure service continuity.

Azure came to the rescue. Working with our partner Softjam, Commune di Catania built a hybrid solution that uses SQL Server and Azure Data Warehouse (Azure SQL DW) to build a flexible data warehouse for all their reporting needs, backed by automatic recovery and site-to-site recovery.

Security is embedded into Azure and we want our customers to own and control their data in the cloud. Microsoft has been leading the industry in establishing clear privacy requirements and then consistently meeting these requirements. Azure meets a broad set of international and industry-specific compliance standards, such as ISO 27001, HIPAA, FedRAMP, SOC 1 and SOC 2, as well as country-specific standards like Australia IRAP, UK G-Cloud, and Singapore MTCS. Rigorous third-party audits, such as by the British Standards Institute, verify Azure’s adherence to the strict security controls these standards mandate.

As the IT Manager for the municipality, Maurizio Consoli states, “We used Azure SQL Data Warehouse to create business continuity for our public records applications, with minimal maintenance, high reliability, and reduced total cost of ownership compared to an on-premises solution.”

Azure SQL DW’s advanced security features like VNET service endpoints, advanced threat detection, always-on encryption, audit, and managed access through Azure Active Directory gives our customers peace of mind. With a hybrid approach, customers get an extra layer of control over what they want to take the cloud and what they want to keep close to them.

Find out more about this solution. Click on the webpages to learn about latest security features of Microsoft SQL Server 2017 and Azure SQL Data Warehouse.

Find out why Gartner sees Microsoft as a leader for Database Management for Analytics Solutions and read the Forrester Consulting Total Economic Impact (TEI) study to discover how your enterprise can benefit from a cloud based modern data warehouse.