Odoo Help


How to search for products from an external database?

michel Guénard
on 12/3/14, 12:28 PM 877 views

A large part of the products which we can purchase and sell are present into an external database with more than 600 000 skus.

We can access to the database (located on our local infrastructure) only with user rights (login and password)

How would it be possible to search for products in this local database from our Odoo instance (Saas from Odoo)?

for instance before creating a new product in Odoo.





| 5 3 6
Jakarta, Indonesia
On 12/3/14, 8:29 PM

I haven't tried this personally, but here is what I would try if I need to include foreign database into Odoo.  PostgreSQL has an extension called Foreign-Data Wrapper (http://www.postgresql.org/docs/9.3/static/postgres-fdw.html)  which essentially allows you to connect to remote server and create a link to a remote table.  With that you should be able to do query to that table using cr.execute.  If you want to use ORM, then you might need to create a View on top of that table and add and emulate the necessary columns (notably id) so that the ORM model can be created.

Now, having said that I don't have exeperience in Odoo's SaaS as well.  So I'm not sure whether it would allow you to install the extension, connect to remote database, etc.

Thanks for this guidance which I will consider if I can get access privileges to the tables of the foreign database. Right now I can only access it thru a proprietary application.

AD LIBITOM, michel Guénard
on 12/4/14, 4:35 AM

Looks like you need to resort to export import since you mentioned that it is only accessible through proprietary application. That is if there is such a tools (or report) in that application that can be used to dump the data. If you are really desperate to get it in automatic way, you might want to consider screen scrapping.

on 12/4/14, 5:19 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 12/3/14, 12:28 PM
Seen: 877 times
Last updated: 3/16/15, 8:10 AM