How can we connect on-prem java application to Azure Database for PostgreSQL - Flexible Server using access token( managed identity or entra id)

Kanhaiya Sharma 20

i have a Azure Database for PostgreSQL - Flexible Server.

my azure webapp connects to database using system assigned managed identity.

how can we connect one of my on prem java application to database using managed identity or entra id?

How the authentication will work? As if application is azure web app we assign identity to our database. but how will we assign identity for on prem application to database?

Vijayalaxmi Kattimani 1,720 Reputation points Microsoft External Staff

2025-03-12T13:19:35.49+00:00
Hi Kanhaiya Sharma,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

As we understand that, you are trying to connect your on-prem Java application to an Azure Database for PostgreSQL - Flexible Server using managed identity or Entra ID.

We would like to inform you that, you can use both system-assigned and user-assigned managed identities to authenticate to Azure Database for PostgreSQL flexible server. Managed Identities are automatically managed by Azure and enable you to authenticate to services that support Microsoft Entra authentication without needing to insert credentials into your code. Please refer to this document. https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-connect-with-managed-identity

Using Entra ID:

Create an Admin User in Entra ID: Set this user as the Active Directory admin for the PostgreSQL service.

Log in to the PostgreSQL Service Using the Admin User: Create a role for the managed identity with the client ID as the password.

Retrieve the Access Token: On your VM, get an access token for the managed identity from the local endpoint (similar to the managed identity steps).

Use the Access Token to Connect to the PostgreSQL Service: Use the retrieved access token as the password to connect to the PostgreSQL service using the managed identity role.

Please refer to the below mentioned links form more information.

https://learn.microsoft.com/en-us/azure/app-service/tutorial-java-tomcat-connect-managed-identity-postgresql-database

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/connect-java?tabs=passwordless

I hope this information helps. Please do let us know if you have any further queries.

Share via

How can we connect on-prem java application to Azure Database for PostgreSQL - Flexible Server using access token( managed identity or entra id)

Your answer