Best Practices for Integrating OFBiz with External Reporting Tools (BI/Dashboards)?

[chartclatter]

Hey everyone,

We're currently running OFBiz for our ERP needs, and while its internal reporting capabilities are good for operational tasks, we're looking to integrate it with more robust external Business Intelligence (BI) tools (e.g., Power BI, Tableau, or custom dashboards) for deeper analytics and executive reporting.

I'm curious to hear about your experiences and recommended best practices for extracting data from OFBiz in a performant and reliable way for such integrations. Specifically, what's your go-to method for:
google baseball
Data Extraction: Are you primarily using direct database queries, entity syncs, REST APIs, or something else entirely? What are the pros and cons you've encountered with each approach in a production environment?
Schema Understanding: Any tips or tools you've found invaluable for navigating OFBiz's extensive and sometimes complex entity model when building external queries?
Performance Considerations: How do you manage the impact of data extraction on OFBiz's operational performance, especially for larger datasets?
Security: Best practices for securing data access for external BI tools without compromising the main OFBiz instance?
Any insights, war stories, or architectural patterns you've found successful would be hugely appreciated! Thanks in advance for your help!