Connect to and manages an Azure Database for PostgreSQL in Microsoft Purview
Article
This article outlines how to register an Azure Database for PostgreSQL deployed with single server deployment option, and how to authenticate and interact with an Azure Database for PostgreSQL in Microsoft Purview. For more information about Microsoft Purview, read the introductory article.
You'll need to be a Data Source Administrator and Data Reader to register a source and manage it in the Microsoft Purview governance portal. See our Microsoft Purview Permissions page for details.
Currently, to be able to manage and interact with an Azure Database for PostgreSQL single server, only SQL Authentication is supported.
SQL Authentication
Connecting to an Azure Database for PostgreSQL database requires the fully qualified server name and login credentials. You can follow the instructions in CONNECT AND QUERY to create a login for your Azure Database for PostgreSQL if you don't have this available. You'll need username and password for the next steps.
On Register sources, select Azure Database for PostgreSQL. Select Continue.
On the Register sources Azure Database for PostgreSQL screen, do the following:
Enter a Name for your data source. This will be the display name for this data source in your Catalog.
Select From Azure subscription, select the appropriate subscription from the Azure subscription drop-down box and the appropriate server from the Server name drop-down box.
Select Register to register the data source.
Scan
Follow the steps below to scan an Azure Database for PostgreSQL database to automatically identify assets and classify your data. For more information about scanning in general, see our introduction to scans and ingestion
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.