Best way to export Odoo.sh data into a datawarehouse

Question

Hi,
I would like to be able to export periodically and automatically, my whole Odoo database to put it in a datawarehouse. What is the best way to do that ?
On Odoo online i could use the saas_worker/dump route, but it seems like it is not available on odoo.sh
Regards,

Chandan · Answer

You can use direct connector for Odoo and BigQuery to make Data Warehouse at Google Cloud
"https://techfinna.com/guides/how-to-connect-google-bigquery-with-odoo"
Link to Connector  https://apps.odoo.com/apps/modules/17.0/bigquery_techfinna/ [1]

[1] https://apps.odoo.com/apps/modules/17.0/bigquery_techfinna/

CandidRoot Solutions · Answer

Hello
I would recommend you to use following module to take auto back up of database and store it into cloud space via SFTP.
https://apps.odoo.com/apps/modules/15.0/auto_backup/ [1]

Thanks & Regards,
​ [2]

CandidRoot Solutions Pvt. Ltd. Mobile: (+91) 8849036209
Email:  info@candidroot.com [3]
Skype: live:candidroot
Web:  https://www.candidroot.com [4]
Address: 1229-1230, Iconic Shyamal, Near Shyamal Cross Road, Ahmedabad, Gujarat 380015
None [5]   None [6]   None [7]   None [8]

[1] https://

Related Posts	ตอบกลับ	มุมมอง
Odoo Data to Data Warehouse google databases analytics DataWarehouse	3 ก.ค. 24	8953
Can i use the same Database for a company with different Department databases	2 พ.ค. 26	1214
{(LATAM&24/7->telefono)}:¿Cómo se llama LATAM en Chile? databases	0 เม.ย. 26	34
Migration from Odoo Online to Odoo.sh แก้ไขแล้ว odoo.sh	1 พ.ค. 26	2349
Built an odoo.sh alternative, would love your feedback odoo.sh	0 พ.ย. 25	18

คำถามนี้ถูกตั้งค่าสถานะ

CandidRoot Solutions Pvt. Ltd.

สนุกกับการพูดคุยนี้ใช่ไหม? เข้าร่วมเลย!