Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
1 Odpowiedz
11545 Widoki
Awatar
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.

Awatar
Odrzuć
aro odoo
Autor

Thanks Sudhir Arya 

Awatar
Sudhir Arya (ERP Harbor Consulting Services)
Najlepsza odpowiedź

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.


Awatar
Odrzuć
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 .