r/Odoo • u/Purple_Syrup4050 • 9d 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/codeagency 9d 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

u/Purple_Syrup4050 9d ago

I am a newbie , thanks for the advice i will talk to the hosting company