Skip to Content
Вам необхідно зареєструватися, щоб взаємодіяти зі спільнотою.
All Posts Люди Значки
Мітки (View all)
odoo accounting v14 pos v15
Про цей форум
Це запитання позначене
1 Відповісти
11626 Переглядів
Аватар
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.

Аватар
Відмінити
aro odoo
Автор

Thanks Sudhir Arya 

Аватар
Sudhir Arya (ERP Harbor Consulting Services)
Найкраща відповідь

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.


Аватар
Відмінити
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 .