se puede acceder a la base de datos en odoo 16 a traves de sql? requiere permiso especial, cuales serian los pasos?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Akuntansi
- Inventaris
- PoS
- Project
- MRP
Pertanyaan ini telah diberikan tanda
1
Balas
1129
Tampilan
Hi,
Yes, You can access the Odoo 16 PostgreSQL database using SQL if you're hosting on Odoo.sh or on-premise. Odoo Online (SaaS) does not provide SQL access for security and data integrity reasons.
Access requires valid PostgreSQL credentials and network permission to connect to the server. You can use tools like pgAdmin, DBeaver, or the psql command-line utility to explore the database. On Odoo.sh, database access is available through an SSH tunnel provided by the platform.
Direct SQL changes bypass Odoo's ORM layer, meaning computed fields, workflows, and constraints won't trigger. This can result in data corruption, broken relationships, or inconsistent system behavior. Read-only SQL queries for reporting or BI tools are generally safe if no data is written or updated. Directly altering table structures or records may cause issues during upgrades or module installations. It's strongly recommended to use Odoo’s standard models or Studio tools for all business logic and data updates.
Hope it helps.
Menikmati diskusi? Jangan hanya membaca, ikuti!
Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!
Daftar