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
- Boekhouding
- Voorraad
- PoS
- Project
- MRP
Deze vraag is gerapporteerd
1
Beantwoorden
5814
Weergaven
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
Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!
Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!
AanmeldenGerelateerde posts | Antwoorden | Weergaven | Activiteit | |
---|---|---|---|---|
|
7
jul. 25
|
50519 | ||
|
0
feb. 25
|
1798 | ||
|
2
jan. 25
|
8467 | ||
|
0
dec. 24
|
1337 | ||
ODOO.sh
Opgelost
|
|
2
okt. 24
|
13248 |