Archives
Contributors
Receive and deliver in Packages
"Translating" pictures in website breaks website editor - any workaround?
Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17
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, | |||||||||
 |  |
| |||||||
| |||||||||
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. | |||||||||
by mitesh.jayswal - 02:01 - 18 Dec 2023
Follow-Ups
-
Re: Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17
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,ChristopherAm 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
by Christopher Rogos - 03:46 - 18 Dec 2023 -
Re: Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17
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, 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
_______________________________________________
Mailing-List: https://odoo-community.org/groups/contributors-15
Post to: mailto:contributors@odoo-community.org
Unsubscribe: https://odoo-community.org/groups?unsubscribe
by "Ronald Portier" <rportier@therp.nl> - 03:46 - 18 Dec 2023 -
Re: Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17
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, 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
_______________________________________________
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
by Frederik Kramer - 03:41 - 18 Dec 2023 -
Re: Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17
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, 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
by Tom Blauwendraat - 03:26 - 18 Dec 2023 -
Re: Inquiry on Connecting Odoo.sh with Power BI for Odoo v15, v16 and v17
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
by Frederik Kramer - 03:21 - 18 Dec 2023