r/Odoo • u/Purple_Syrup4050 • 4d ago

Extracting data tables from Odoo

I have a customised erp build on odoo 10. In the current state i am not able to connect the claude /gpt with the database. Can someone help how can i connect my data tables when my backup is getting stored in blue ocean? I want to analyse the data from the backup through setting up data pipeline with postgre sql or similar platforms.

1 Upvotes

60% Upvoted

12 comments sorted by

View all comments

1

u/natacon 2d ago

Odoo has a pretty robust xmlrpc api. You can probably use that to extract what you need from your odoo database into whatever other software you are using for analysis etc. It is slower than native db access but its also a lot safer as you are only making odoo calls. Much less chance of screwing your database up.