Connecting Odoo.sh to a php server
We have a php based freight reporting system that runs on a separate php server and reads data from Odoo and other tables to provide a quick searchable summary of inwards and outwards goods. I am looking for a method to connect our php server to read the tables which are now housed on Odoo.sh.
The Postgres connection I have been using will not work because Odoo.sh will only allow a connection through a SSH tunnel. Has anyone else came across this issue? Did you manage to resolve it?
(Our php server is running on an Ubuntu/Linux system.)