Connect to another database odoo sh

Question

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?

Niyas Raphy (Walnut Software Solutions) · Accepted Answer

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 Mi

İlgili Gönderiler	Cevaplar	Görünümler
AttributeError: module 'lib' has no attribute 'X509_V_FLAG_CB_ISSUER_CHECK' when creating new staging branch Çözüldü odoosh	7 Tem 25	50522
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released postgresql	0 Şub 25	1799
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied postgresql	2 Oca 25	8470
Workflow for Pushing Changes from Odoo.sh to GitHub Without Merging to the Main Branch odoosh	0 Ara 24	1337
ODOO.sh Çözüldü odoosh	2 Eki 24	13250

Bu soru işaretlendi

Enjoying the discussion? Don't just read, join in!