I am a new user on Odoo system.
My new account staff used Jet reports for many years, he did not use Odoo report before.
I can get API key and URL (come from PowerBI connection before ) Would it be ok to make connection for Jet report ?
Se marcó esta pregunta
3
Respuestas
2361
Vistas
Hi,
Please refer to the links:
1. https://www.cybrosys.com/blog/business-intelligence-reporting-in-odoo
2. https://www.cybrosys.com/blog/how-to-create-interactive-dashboards-in-power-bi
Hope it helps.
Would PowerBI and other reports tools could query on Odoo Database (Accounting) fields?
'And other' is quite a vast question, but, in general yes, but it depends on your hosting environment. Self-hosted Odoo or hosting via odoo.sh on a dedicated server (shared odoo.sh hostings do NOT provide this option!), will allow you to access your database by the means of SQL from outside. The 'how', especially on self-hosted setups will require different steps based on your current network setup.
Also, utilizing 3rd-party modules or external connectors (i.e. for Odoo Online instances) are an option. See for example these posts related to Power BI
We understand that your team has been using Jet Reports extensively in the past, and you are now transitioning to Odoo for your business operations. It’s great to hear that you already have access to the API URL and key, which opens up possibilities for integrating external tools.
Regarding your question about using Jet Reports with Odoo, while Jet Reports is primarily designed to work with Microsoft Dynamics products, we can help explore alternative solutions to achieve similar reporting capabilities using your Odoo data.
¿Le interesa esta conversación? ¡Participe en ella!
Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.
Registrarse| Publicaciones relacionadas | Respuestas | Vistas | Actividad | |
|---|---|---|---|---|
|
Using Model 180
Resuelto
|
|
1
may 26
|
1372 | |
|
0
may 26
|
74 | ||
|
0
may 26
|
3 | ||
|
1
may 26
|
417 | ||
|
0
may 26
|
138 |
Thank you for reply. After further chatted with account staff, Let me use Jet report "term" to express data fields: 1. Department Code (Dimension 1), 2 Budget Code (Dimension 2), Party Code (Dimension 3). to generate reports. Would PowerBI and other reports tools could query on Odoo Database (Accounting) fields ?
What exactly are those alternatives?
We use Dynamics NAV and we have a large number of Jet Reports.