1. Mailing Lists
  2. Contributors
  3. Re: Inquiry on Preferred BI Tools and Connection Methods for Odoo

Contributors mailing list archives

contributors@odoo-community.org

Browse archives

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

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

Avatar

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

by
kon.tsagari
- 17/01/2024 12:58:04

Hi Rafael,

Here the tools we are using in my cooperative, I hope it is helpful.

  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?
    We are using Apache Superset, for us, it is the powerfulest open source BI tool and has a good community behind.
    It has a lot of different charts, including maps.

  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?
    We make queries directly from database.
    We are useing Postgres Foreign Datawrapper in order to map all odoo, and any other source, incuding flat files, in other postgres instance and then we build datasets in order to make charts in superset.
    We also use DBT if we need to persist any query for performance purposes.
    With this solution we can show the informations in our dashboards in real time.


  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.
    We have some financial dashboards (mis reports extended, profit and loss, balance situation) in superset.
    We also have dashboards for companies like Som Conexió (telecomunications), Som Mobilitat (carsharing) that takes some information from Odoo and information from other datasources.
    We can mount dashboards for any model in Odoo, and if it's necessary, joining the data with other datasources with foreign data wrapper.


Regards,
Konstantina Tsagkari
coopdevs.coop

On 9/1/24 16:47, Rafael Blasco 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

--
Coopdevs. Software lliure per a l'economia social Konstantina Tsagkari
kon.tsagari@coopdevs.org Visit our web coopdevs.org

AVÍS LEGAL:Aquest missatge i els seus arxius adjunts van dirigits exclusivament al seu destinatari, i poden contenir informació confidencial sotmesa a secret professional. No n’és permesa la comunicació, reproducció o distribució sense l’autorització expressa de COOPDEVS TREBALL S.C.C.L.. Si no en sou el destinatari final, si us plau, elimineu-lo i informeu-nos-en per aquesta via.

PROTECCIÓ DE DADES: De conformitat amb el que estableix el Reglament (UE) 2016/679, de 27 d’abril (GDPR), i la Llei Orgànica 3/2018, de 5 de desembre (LOPDGDD), l’informem que les dades personals i adreça de correu electrònic de l’interessat es tractaran sota la responsabilitat de COOPDEVS TREBALL S.C.C.L. per un interès legítim i per enviar comunicacions sobre els nostres productes i serveis, i es conservaran mentre cap de les parts s’hi oposi. No es comunicaran les dades a tercers, tret que sigui obligació legal. Us informem que podeu exercir els drets d’accés, rectificació, portabilitat i supressió de les vostres dades i els de limitació i oposició al seu tractament tot adreçant-vos a Can Batlló Bloc 8 Constitució 19-25, - 08014 Barcelona (Barcelona). E-mail: info@coopdevs.org. Si considereu que el tractament no s’ajusta a la normativa vigent, podeu presentar una reclamació davant l’autoritat de control a www.aepd.es.

Reference