Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Avatar

Re: Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17

by "Ronald Portier" <rportier@therp.nl> - 18/12/2023 15:44:05

Hi Everyone,


Anyhow the postgresql database is not supposed to be directly used, because it will ignore all information and structure provided by the ORM. So xml-rpc or json-rpc would be the interface to use for connecting to Odoo data. This is also fully supported by odoo.sh/


Kind regards, Ronald


On 18-12-2023 15:27, Tom Blauwendraat wrote:

Hi everyone,

there's a commercial module from Techneith that can do this also without the SQL connection.

I don't recommend it for various reasons, but it exists, and works. I don't know how it works, because the code is obfuscated.

-Tom

On 12/18/23 15:16, Paul Catinean wrote:
Hi Mitesh,

I might be missing something here but in the case of odoo.sh I think you have 2 or 3 options:

1) Use an ssh tunnel to give access to postgresql (not sure if PowerBI supports this). Also I don't think you can create a new read-only user for this purpose.
2) Use a tunnel at the http layer (HTTP Tunneling ). I've never attempted this so I have no idea if it works.
3) Use the new dedicated odoo.sh instance which provides this feature by default https://www.odoo.sh/faq?q=postgresql#postgresql

These are the only approaches I know of. Would be excited to learn of others if there are any.

Best,
Paul

On Mon, Dec 18, 2023 at 3:01 PM Mitesh Jayswal <notifications@odoo-community.org> wrote:
Dear OCA Team,

We are currently exploring possibilities to connect Odoo.sh with Power BI for odoo versions v15, v16 and v17. I would appreciate it if you could provide insights into the available options and any recommendations for achieving this integration.

Your assistance in this matter is highly valuable. Thank you in advance for your support.


Thanks and Regards,
Logo Logo
Mitesh Jayswal
Team Lead - Open Source (Odoo Certified)
M: +91-7016346545
P: +91-8140810579 / EXTN: 1001
E: mitesh.jayswal@brainvire.com
W: www.brainvire.com
Facebook icon LinkedIn icon Twitter icon Blog
Inc
                                      Magazine Deloitte Silicon Valley's Fastest
                                      Growing Company Reviewed on clutch Great Place to Work

Disclaimer: The information transmitted by this email is intended only for the person or entity to which it is addressed. This email may contain proprietary, business-confidential and/or privileged material. Please consider the environment before printing.


_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe

Reference