I have a server with odoo sh and an external one, I need to connect to the external db, I tried it with the postgresql dblink package, psql but it doesn't allow me to create the extension. ERROR: permission denied to create extension "dblink" How could I connect to the other db?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Buchhaltung
- Lager
- PoS
- Project
- MRP
Diese Frage wurde gekennzeichnet
1
Antworten
5849
Ansichten
Hi,
You can connect two odoo database using the xmlrpc ,
import xmlrpclib
url = 'http://0.0.0.0:8012'
db = 'db_name'
username = 'admin'
password = 'admin'
common = xmlrpclib.ServerProxy('{}/xmlrpc/2/common'.format(url))
uid = common.authenticate(db, username, password, {})
models = xmlrpclib.ServerProxy('{}/xmlrpc/2/object'.format(url))
Also see this video, showing how the data is transferred between two database using xmlrpc :- Transfer Data Between Databases Using XMLRPC In Odoo : Database Migration
Odoo Doc : https://www.odoo.com/documentation/13.0/webservices/odoo.html
Thanks
Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!
Erstellen Sie heute ein Konto, um exklusive Funktionen zu nutzen und mit unserer tollen Community zu interagieren!
RegistrierenVerknüpfte Beiträge | Antworten | Ansichten | Aktivität | |
---|---|---|---|---|
|
7
Juli 25
|
50541 | ||
|
0
Feb. 25
|
1813 | ||
|
2
Jan. 25
|
8490 | ||
|
0
Dez. 24
|
1344 | ||
ODOO.sh
Gelöst
|
|
2
Okt. 24
|
13269 |