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
- Kế toán
- Tồn kho
- PoS
- Project
- MRP
Câu hỏi này đã bị gắn cờ
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.
Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!
Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!
Đăng ký