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

[faraz003]

Hi,

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.

[martin.peeters]

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

How to access postgres database for outside of the OR manager

HI, How can I access postgres database from outside of OR manager (i.e pgadmin etc), do I need to add host during docker compose up? Currently my docker compose file is following: # OpenRemote v3 # # Profile that runs the stack by default on https://localhost using a self-signed SSL certificate, # but optionally on https://$OR_HOSTNAME with an auto generated SSL certificate from Letsencrypt. # # It is configured to use the AWS logging driver. # version: ‘2.4’ volumes: proxy-data: manager-data:…

[michal]

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

...
services:
  postgres:
    ...
    ports:
      - "5432:5432"

[faraz003]

Is this way is correct?

[michal]

Looks correct for me.