Skip to Content
This question has been flagged
1 Reply
10279 Views
Avatar
aro odoo

Hello,

I am in the process of familiarizing myself with the development of modules on Odoo 14, for the moment I only handle the local database. So I would like to know how I could link or call an external or local database (whether on Postgresql or Mysql) to my module?

My goal is to retrieve the list of customers for example and put a selection field that retrieves its values ​​from this base.

I found the External Database Sources module, but it is compatible that on Odoo 8/7, by installing it on the 14 I get a python error "argument of type 'bool' is not iterable" when I test the connection with any other base.

If you have any ideas or suggestions do not hesitate
I thank you in advance.

Avatar
Discard
aro odoo
Author

Thanks Sudhir Arya 

Avatar
Sudhir Arya (ERP Harbor Consulting Services)
Best Answer

Using XML-RPC you can connect external Odoo server or using psycopg you can connect the external postgresql database.

You can also use mysql connector to connect mysql database using python.
Try anyone of these and let us know at which point you are stuck.


Avatar
Discard
Wasnik Malla

I tried to connect with odoo postgres database in server using python in local computer, i just could not establish connections, it throws an error , upon contacting hosting provider they say odoo has restricted their database for public access .