|Microsoft's Azure Synapse Analytics can query relational and non-relational data / Photo Credit: VDB Photos (via Shutterstock)|
Microsoft Ignite kicked off in Orlando, Florida, with the tech giant unveiling its new cloud-hosted AI, data analytics, and managed database services, as well as announcing updates to existing offerings such as Azure SQL Database Edge, according to Kyle Wiggers of technology news source Venture Beat. The headliner is Microsoft’s Azure Synapse Analytics, a service that utilizes “on-demand and provisioned resources” to collect, manage, prepare, and serve data for AI apps and business intelligence.
Azure Synapse Analytics is the evolution of Azure SQL Data Warehouse, and aggregates insights from data warehouses and big data analytics systems across organizations. Azure Data corporate vice president Rohan Kumar wrote that businesses nowadays are forced to maintain both data warehouses and data lakes. “Data warehouses provide critical insights on business health. wrote, Data lakes can uncover important signals on customers, products, employees, and processes,” he stated.
Directed by lines of SQL, the former can query relational and non-relational data. Azure Synapse features intelligent workload management, workload isolation, and limitless concurrency that help optimize the performance of queries in real-time. Deep integration with Azure Machine Learning and Power AI is another feature of the Azure Synapse, which “simplifies the sharing of cleansed and processed data.”
The Azure Synapse studio is a unified workspace that provides tools for data management, data prep, data warehousing, big data, and AI tasks. Moreover, the workspace allows users to manage data pipelines and realize proofs of concept. These tasks can be done while the user securely accesses data sets and custom control interfaces.
As for security, Azure Synapse employs automated threat detection and always-on data encryption. Aside from dynamic data masking, it also offers column-and-row-level security and fine-grained access controls. Kumar explained, businesses can benefit from Azure Synapse’s capabilities by continuing to run their existing data in the system. Hence, they can put their data to work faster and more productively, enabling them to draw insights from all data warehouses, big data analytics systems, and data sources, he added.