Contributors

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

  Good luck Rafael and thanks to share your first decision.
  

  		Bruno Joliveau Architecte solutions - Président +1 514-317-7944

  Nouveau Suivez les publications des Numigiens 👀

  Découvrir

  
  

  
  

  Le mer. 17 janv. 2024 à 14:02, Rafael Blasco <notifications@odoo-community.org> a écrit :
  

  Hello all!

   

  Thank you for all your answers.

   

  We decided to go for PowerBI using this connector:

   

  https://github.com/tmijail/Odoo-Power-BI-Connector

   

  The time Will show us if this solution fits or not depending the volume of data and the size of reports.

   

  😊

   

  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
  

  ---

  by Bruno Joliveau - 08:36 - 17 Jan 2024

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

  Hello all!

   

  Thank you for all your answers.

   

  We decided to go for PowerBI using this connector:

   

  https://github.com/tmijail/Odoo-Power-BI-Connector

   

  The time Will show us if this solution fits or not depending the volume of data and the size of reports.

   

  😊

   

  Best regards,

  Rafael Blasco

  Moduon

   

  ---

  by Rafael Blasco (Moduon) - 08:00 - 17 Jan 2024

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

  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
  

  --
  

  Konstantina Tsagkari kon.tsagari@coopdevs.org 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.

  ---

  by Konstantina Tsagkari - 01:00 - 17 Jan 2024

  1 attachments 1 attachments

  CfgSPCVIWZesqLGC.png

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

  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
  

  ---

  by caleb - 08:45 - 9 Jan 2024

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

  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
  

  ---

  by "Diogo Duarte" <dduarte@erpgap.com> - 08:02 - 9 Jan 2024

3 more replies