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.
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.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 12/3/14, 12:28 PM|
|Seen: 650 times|
|Last updated: 3/16/15, 8:10 AM|