An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
Hi Mythili Velliangiri
This is expected behavior.
At the moment, on-premises PostgreSQL scanning via Self-Hosted Integration Runtime (SHIR) is not supported in Microsoft Purview. Because of this limitation, the scan fails with:
Error (3803): Linked service type not supported by DataScan
This is not related to network connectivity, credentials, or SHIR health. Even with a correctly configured and healthy SHIR, Purview does not support DataScan for PostgreSQL when accessed through SHIR.
This also explains why the same setup works when using Azure Integration Runtime but fails when switched to SHIR.
There are no additional configuration steps or prerequisites that can enable this scenario today.
If scanning must be done via SHIR, you would need to wait for product support to be added. Otherwise, continue using Azure Integration Runtime where supported, or log a support ticket / feature request for tracking.
Hope this helps clarify.