Clarification on Entra Authentication for PostgresSQL on Azure

KNIME Analytics Platform
1

In KNIME, when connecting to an Azure PostgreSQL DB via the PostgreSQL Connector node, the options seem to be Credentials, UN/PW, or Kerberos (?). UN/PW works fine.

On Azure, the options are:

  • PostgreSQL authentication only (which works for KNIME’s UN/PW)
  • Microsoft Entra authentication only
  • PostgreSQL and Microsoft Entra authentication

image

How can we leverage the 2nd or even 3rd option with KNIME? The process for creating Entra app registrations and obtaining secrets is clear - but I don’t see how a Microsoft Connector node can output into one of the 3 options needed by the PostgreSQL node.

Thanks

2

Friendly nudge up :slight_smile:. Guessing a custom driver might be required to load up into the node?

3

Hi @qdmt -

Let me ask internally and see what I can find out.