How i can get data from external database and use it for my module. Example i have db with table product. How to get all data from that table and put it in openerp module. How to connect on that database and get data? All examples are welcome.
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
1
Reply
5365
Views
Well, there are many ways to do that... but you need to develop modules to do that. One way of solving your problem would be to develop a module that extends X model creating calculated fields, and those fields are populated with data pulled from external databases. There are many ways to pull data from other DBs in Python, you can do that with different libraries such as pymysql (for MySQL databases) or with ORM like SQLAlchemy.
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 | |
|---|---|---|---|---|
|
0
Jul 25
|
2369 | ||
|
2
Nov 24
|
8711 | ||
|
2
Oct 24
|
5079 | ||
|
2
Aug 24
|
2793 | ||
|
3
Jul 24
|
9360 |
