Solution Idea
If you'd like to see us expand this article with more information, such as potential use cases, alternative services, implementation considerations, or pricing guidance, let us know with GitHub Feedback!
As more of your organization's data is loaded into Azure, the need to properly govern and manage that data across all your data sources and data consumers grows.
Without high-quality data in your Azure SQL estate, the business value can be diminished. The solution is to build a foundation for data governance and management that can produce and deliver trustworthy high-quality data.
Data needs to be managed at scale across on-premises, cloud, and multi-cloud storage. This management ensures compliance requirements are met around security, privacy, and usage. Well-managed data can also improve self-discovery, data sharing, and quality—improving the use of data in applications and analytics.
With Azure Purview, you can:
- Ensure that definitions, classifications, and governance processes are applied uniformly for your data.
- Provide a central platform where you can apply definitions and ownership to your data.
- With a single view on reports and insights, you can generate data standards that should be imposed on your data.
- Focus on governance to find, classify, define, and enforce policies and standards across data.
- CRISP DETAIL, CLEAR DISPLAY: Enjoy binge-watching...
- PRO SHOTS WITH EASE: Brilliant sunrises, awesome...
- CHARGE UP AND CHARGE ON: Always be ready for an...
- POWERFUL 5G PERFORMANCE: Do what you love most —...
- NEW LOOK, ADDED DURABILITY: Galaxy A54 5G is...
- Free 6 months of Google One and 3 months of...
- Pure Performance: The OnePlus 12 is powered by the...
- Brilliant Display: The OnePlus 12 has a stunning...
- Powered by Trinity Engine: The OnePlus 12's...
- Powerful, Versatile Camera: Explore the new 4th...
Last update on 2024-04-05 / Affiliate links / Images from Amazon Product Advertising API
Azure Purview can automatically discover, catalog, classify, and manage data across Microsoft SQL offerings, whether on-premises or in Azure. To take advantage of Azure Purview, use these Microsoft SQL services together:
- On-premises SQL Server
- Azure SQL
- SQL Server Managed Instance
- Power BI
Potential use cases
The solution described here is appropriate for organizations that would benefit from the following outcomes of well-governed data:
- Automatic discovery of data in the organization to accelerate cloud adoption.
- Secure data for compliance with data laws and regulations.
- Improved access, discovery, and quality of managed data to enhance analytics.
Architecture
Download a PowerPoint file of this architecture.
Dataflow
The next four scenarios show the options available to you, to connect to Azure Purview securely.
- Connect Azure Purview to on-premises SQL via Self-Hosted Integration Run time by Private Endpoint.
- Connect Azure Purview to Azure SQL via Managed Virtual Network by Managed Private Endpoint.
- Connect Azure Purview to Azure SQL Managed Instance via Self-Hosted Integration run time by Private Endpoint.
- Connect Azure Purview natively to Power BI.
Note
The information transferred from the sources to Azure Purview is metadata describing the data within the scanned sources. No actual data is transferred from the SQL sources to Azure Purview.
Capabilities
- Catalog. Azure Purview data catalog can automatically capture and describe core characteristics of data at the source. The characteristics include schema, technical properties, and location. Azure Purview glossary allows a business-friendly definition of data to be layered on top to improve search and discovery.
- Classification. Azure Purview automatically classifies datasets and data elements with over 100 predefined sensitive-data classifications. It also allows users to define their own custom classification schemes that can be applied manually and automatically.
- Ownership. Azure Purview allows data ownership and stewardship to be applied to data assets and glossary items within the catalog.
- Insights. Insights in Azure Purview provide multiple pre-defined reports to help CDOs, data professionals, and data governance professionals gain a detailed understanding of the data.
Components
- 【Octa-Core CPU + 128GB Expandable TF Card】...
- 【6.8 HD+ Android 13.0】 This is an Android Cell...
- 【Dual SIM and Global Band 5G Phone】The machine...
- 【6800mAh Long lasting battery】With the 6800mAh...
- 【Business Services】The main additional...
- 【Dimensity 9000 CPU + 128GB Expandable TF...
- 【6.8 HD+ Android 13.0】 This is an Android Cell...
- 【Dual SIM and Global Band 5G Phone】Dual SIM &...
- 【6800mAh Long lasting battery】The I15 Pro MAX...
- 【Business Services】The main additional...
- 🥇【6.8" HD Unlocked Android Phones】Please...
- 💗【Octa-Core CPU+ 256GB Storage】U24 Ultra...
- 💗【Support Global Band 5G Dual SIM】U24 Ultra...
- 💗【80MP Professional Photography】The U24...
- 💗【6800mAh Long Lasting Battery】With the...
Last update on 2024-04-05 / Affiliate links / Images from Amazon Product Advertising API
The solution uses the following components:
- Azure Purview is a unified data catalog that manages on-premises, multi-cloud, and software as a service (SaaS) data. This data governance service maintains data landscape maps. Features include automated data discovery, sensitive-data classification, and data lineage.
- Microsoft SQL Server is a family of relational database management systems, or RDBMS. The servers are deployed and managed by your organization.
- Azure SQL Database is a fully managed SQL database built for the cloud with automatic updates, provisioning, scaling, and backups.
- Azure SQL Managed Instance is a cloud database service that provides all the features of SQL Server with added protection, connectivity, and automatic updates.
- Power BI is a collection of software services and apps. These services create and share reports that connect and visualize sources of data. When you use Power BI with Azure Purview, it can be cataloged, classified, and have granular lineage illustrated end to end.
- Azure Private Link provides private connectivity from a virtual network to Azure platform as a service (PaaS), services that you own, or Microsoft partner services.
- Azure Key Vault stores and controls access to secrets such as tokens, passwords, and API keys. Key Vault also creates and controls encryption keys and manages security certificates.
- Azure AD offers cloud-based identity and access management services. These features provide a way for users to sign in and access resources.
- Azure Monitor collects and analyzes data on environments and Azure resources. This data includes app telemetry, such as performance metrics and activity logs.