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 ?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
3
Replies
1974
Views
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.
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
2
Dec 25
|
1391 | ||
|
2
Dec 25
|
417 | ||
|
3
Dec 25
|
1569 | ||
|
0
Dec 25
|
4 | ||
|
1
Dec 25
|
1306 |
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.