Loading...

Azure Purview expands relational database support - IBM DB2, MySQL and PostgreSQL

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.

Linda_Wang_1-1640152434321.png

 

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.

Linda_Wang_1-1640150033649.png

 

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.

Linda_Wang_2-1640150033661.png

 

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.

Linda_Wang_3-1640150033674.png

 

Linda_Wang_0-1640152155902.png

 

Get started today!

Published on:

Learn more
Azure Purview Blog articles
Azure Purview Blog articles

Azure Purview Blog articles

Share post:

Related posts

Microsoft Azure: You’re not eligible for an Azure free account

Got the below message, while trying to setup the Microsoft Azure Trial for 30 days. You’re not eligible for an Azure free account Don...

2 days ago

How to create Microsoft Azure 30 days trial?

Microsoft Azure is a comprehensive cloud computing platform developed by Microsoft. It provides a wide range of cloud services, including comp...

3 days ago

Azure SDK Release (April 2025)

Azure SDK releases every month. In this post, you find this month's highlights and release notes. The post Azure SDK Release (April 2025) appe...

3 days ago

Getting Started with Azure Cosmos DB Using the Python SDK

If you’re new to Azure Cosmos DB and looking to build applications with Python, you’re in the right place. I’ve created a four-par...

3 days ago

Fast, Accurate, and Affordable: Sharded DiskANN for Multitenant Vector Search in Azure Cosmos DB

Introduction Azure Cosmos DB now includes Sharded DiskANN, a powerful capability that optimized for large-scale multitenant apps by splitting ...

4 days ago

Azure Developer CLI (azd) in a real-life scenario

This post shares some useful tips and lessons learned while using azd during a migration. The post Azure Developer CLI (azd) in a real-life sc...

4 days ago

Webinar: Translate Dynamics 365 Data in Real-Time using Azure AI Translator with our New App!

Is your business operating across multiple regions? Managing multilingual CRM data in Microsoft Dynamics 365 can lead to communication gaps, d...

5 days ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy