Azure Purview expands relational database support - IBM DB2, MySQL and PostgreSQL
Azure Purview is a unified data governance service that enables organizations to easily create a holistic, up-to-date map of your data landscape across on-premises, multi-cloud, and SaaS applications with automated data discovery. Now Purview adds IBM DB2, MySQL and PostgreSQL to its growing fleet of data source support to further expand coverage of various types of relational databases. You can scan your databases, then manage and govern your data in Azure Purview.
Register and scan
Azure Purview data source administrators can start by registering a DB2, MySQL or PostgreSQL source under the data map, and set up reoccurring or one-time scan. You can choose to scan the entire database(s) or only the selective schemas with interest. During scan, Purview extracts metadata including the server, databases, schemas, tables, views, table/view columns, etc., and fetches lineage on assets relationships among tables and views.
Learn more about the prerequisites and step-by-step instruction to register and scan DB2, MySQL and PostgreSQL in Azure Purview.
Search and browse assets
Once the scan completes, you can discover assets via search or browse.
Search for the assets by keyword, and narrow down results by using the facet filters.
To browse, click on the “Browse assets” tile on the Purview home page, navigate to the “By source type” tab and select the data source type. You can then see the list of assets brought in by the scan.
View and manage metadata
Click into the asset to view details including the properties, schema, lineage, and more. You can also add business metadata like descriptions, glossary terms, contacts, and manually classify the data assets to further manage and govern your data in Purview.
Get started today!
- Quickly and easily create an Azure Preview account to try the features.
- Learn more about Connect to and manage DB2 in Azure Purview.
- Learn more about Connect to and manage MySQL in Azure Purview.
- Learn more about Connect to and manage PostgreSQL in Azure Purview.
- See the full list of Azure Purview supported sources.
Published on:
Learn moreRelated posts
Microsoft Purview compliance portal: Information Protection – MIP auto-labeling for Azure SQL & Storage
Microsoft's Purview compliance portal has added a new feature that enables users to extend sensitivity labels to specific or all subscriptions...
Optimizing Azure Container App Deployments: Best Practices for Pipelines & Security
In this post, we take Azure Container App deployments to the next level with best practices for optimizing pipelines and securing sensitive d...
Seamless Updates, Zero Downtime: Master Continuous Deployment in Azure Container Apps
In this fifth part of our Azure Container Apps series, we dive into the world of Continuous Deployment. Learn how to automate your deployment ...
This Month in Azure Static Web Apps | 09/2024
We are back with another edition of the Azure Static Web Apps Community! :party_popper: September was yet another month ...
IPv6 Adoption: Enhancing Azure WAF on Front Door
The transition to IPv6 is a significant step for enterprise corporations, reflecting the evolution of internet technology and the need for a l...
Introducing the Data-Bound Reference Layer in Azure Maps Visual for Power BI
Imagine managing a nationwide sales team and needing to understand how your sales align with factors like population density, competitor locat...