I want to access postgres database from external reporting tools lets say Tableau or power BI


I want to access my openremote postgres database from external tools (i.e. tableau, crystal report or power BI etc.), currently when I am trying connect with these authentication:

But not able to connect.

Shall I need to do some changes in configuration file of docker compose.

This is the same issue as you described 12 hours ago in this topic:

Indeed, you need to make a change in docker-compose.yml file for the postgres service using ports directive and expose port 5432.

      - "5432:5432"

Is this way is correct?

Looks correct for me.