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:
- Müşteri İlişkileri Yönetimi
- e-Commerce
- Muhasebe
- Envanter
- PoS
- Project
- MRP
Bu soru işaretlendi
2
Cevaplar
1107
Görünümler
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!
Üye Ol| İlgili Gönderiler | Cevaplar | Görünümler | Aktivite | |
|---|---|---|---|---|
|
1
Ağu 25
|
221 | ||
|
0
Ağu 25
|
384 | ||
|
1
Ağu 25
|
428 | ||
|
0
Ağu 25
|
358 | ||
|
2
Ağu 25
|
339 |
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 ?