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

Christopher Rogos

- 18/12/2023 15:45:22

Hi,

we are using the ssh tunnel into odoo.sh to download and restore the latest backup located at /backup.daily/*_daily.sql.gz into another Azure Postgres database once a day.

The restore script also creates a readonly user on the odoo database so PowerBI can connect to this Azure Postgres database.

Of course the data is always from yesterday, and when you run the database restore from your odoo.sh instance, it should not take longer than 15 minutes because the ssh connection is terminated after a while.

You also need to ensure that all connections are closed on your target database when restoring the backup.

Best regards,

Christopher

Am Mo., 18. Dez. 2023 um 15:23 Uhr schrieb Frederik Kramer <notifications@odoo-community.org>:

Mehhh, Paul you are right. I missed the Odoo.SH part in my proposal. Again another good reason not to go for Odoo.SH in the first place

Best Frederik

Am 18.12.23 um 15:16 schrieb Paul Catinean:

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,

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

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
-- 
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
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe