Clarification on Entra Authentication for PostgresSQL on Azure
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
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