Since it is not possible to connect to an Odoo.sh postgresql database, because the Odoo hosting platforms do not expose the postgresql clusters to the internet, in order to communicate with a third party system/application (E-commerce, BI reporting, ...), wel need to setup the integration at the http layer.
I wonder if anyone knows how to connect a BI reporting software using the http layer?

Thanks for your help!