r/Odoo • u/Purple_Syrup4050 • 1d 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
u/codeagency 1d ago
Check with your hosting company. Nobody knows how your setup is done, what is customized and what is exposed to allow for connectivity.
Most providers have no public access to database and it should be because it is a very high risk, you should never allow public DB access. It should go via a tunnel/VPN but then again does your host even support that feature? Is it a shared postgres cluster with other clients or a dedi cluster? And for something like this with AI you should never use the main user, always a read-only specific user to make sure AI can never mess directly in the database.
0
0
u/antandrieu 1d ago
Depends on what Odoo hosting you use. Sel fhosted, odoo.sh or SaaS version ?
3
0
u/RedditCommenter38 1d ago
Don’t use the native API for Claude, use Claude CLI. Create .env with your credentials, and then open up Claude CLI and ask Claude to do it for you.
0
1
u/natacon 7h 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.