1. Mailing Lists
  2. Contributors
  3. Re: Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

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

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

Avatar

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

by
InitOS GmbH, Frederik Kramer
- 18/12/2023 15:37:48

Hi Tom

That being said "the code ist obfuscated" is already enough not to feed such a modul with credentials to the database. I wouldn't need an argument other than this to avoid using it ;-)

Best Frederik

Am 18.12.23 um 15:27 schrieb Tom Blauwendraat:

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

-- 
Dr.-Ing. Frederik Kramer
Geschäftsführer

initOS GmbH
Innungsstraße 7
21244 Buchholz i.d.N.

Tel:   +49 (0) 4181 13503 12
Fax:   +49 (0) 4181 13503 10
Mobil: +49 (0) 179 3901819

Email: frederik.kramer@initos.com
Internet: www.initos.com

Geschäftsführung:
Dr.-Ing. Frederik Kramer & Dipl.-Ing. (FH) Torsten Francke

Sitz der Gesellschaft: Buchholz i.d.N.
Amtsgericht Tostedt, HRB 205226
USt-IdNr.: DE815580155
Steuer-Nr: 15/200/53247

Reference