Contributors mailing list archives

contributors@odoo-community.org

Browse archives

Avatar

Re: Inquiry on Preferred BI Tools and Connection Methods for Odoo

by
caleb
- 09/01/2024 20:43:07
We're using Google Datastream to get near real time replication of our postgres database from oDoo 16 CV to BigQuery.

On Tue, Jan 9, 2024, 1:02 PM Diogo Duarte <notifications@odoo-community.org> wrote:
Hi Rafael,

We've been using Apache Superset because it's well supported and offers the possibility to use SSH Tunnel using RSA keys for direct connection to Postgresql (using a READ ONLY user).
This way you don't need a bastion host. If you ussing Odoo.sh you can always use a small server and script a restore from Odoo.sh (using ssh again)
It's a simple and powerful solution and allows direct SQL which is universal.

Best regards,

_Diogo Duarte
ERPGAP





On Tue, Jan 9, 2024 at 3:47 PM Rafael Blasco <notifications@odoo-community.org> wrote:

Dear OCA Contributors,

I hope this message finds you well. I am reaching out to the knowledgeable and experienced members of the Odoo Community Association to gather insights on a topic that is of growing importance in our field - the integration of Business Intelligence (BI) tools with Odoo.

As we continuously strive to improve our business processes and data analysis capabilities, understanding the most effective tools and techniques for integrating BI solutions with Odoo is crucial. Therefore, I would be immensely grateful if you could share your experiences and preferences in this area. Specifically, I am interested in the following questions:

  1. Preferred BI Tools: Which BI tools have you found most effective or user-friendly when integrated with Odoo? Any par ticular reasons for your preference, such as ease of use, comprehensive features, or compatibility?
  2. Connection Method: What type of connection method do you commonly use for integrating BI tools with Odoo? Have you predominantly been using XML-RPC, or are there other methods that you find more efficient or reliable?
  3. Experiences and Recommendations: Any specific experiences, challenges, or success stories you can share about integrating BI tools with Odoo? Your insights could be incredibly valuable for others in the community who are navigating similar decisions.

Your feedback and insights will not only assist me in making informed decisions for my current projects but will al so benefit the broader OCA community as we all work towards optimizing our use of Odoo in various business scenarios.

Thank you in advance for taking the time to share your knowledge and experiences. I look forward to your valuable responses.

Best regards,

Rafael Blasco

Moduon

_______________________________________________
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