Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


How to adapt OpenERP to oracle 11g?

nana charly
on 2/9/13, 8:09 PM 4,237 views

I've been working with OpenERP for 5 years now.

This time, i have a customer that want it to function with oracle. I started to work on that and i'm facing some difficulties. I made some progress by the way. I'm still unable to login but tables are automatically created in database.

To go further or speedier, i would like to know if someone has a documentation on the relation and the function of the classes composing openerp's ORM.

Also, with openerp 5 there was a project to make it function with mysql. I saw that the project was based on sqlalchemy if someone has docs on this project, it will help me for sure.

My work will be distributed freely so any help will be appreciated.

PS : if you want to access to my sources let me know. i will send you a link by email.

The mysql port has been financed by Sun but aborted when Oracle decided to buy Sun. It was working, but far from being useable in production (mainly for performance issues)

Fabien Pinckaers (fp)
on 2/10/13, 5:40 AM

Fabien, thanks for your reply. Do you have some docs on how openerp's ORM function ?

nana charly
on 2/11/13, 4:26 AM

The ORM is based on PostgreSQL and a lot of SQL queries in the modules use the PostgreSQL dialect. The answer is No.


+1 @Charly: Don't do it. In the long run you'll be doing a bad service for your customer porting OpenERP to Oracle.

Daniel Reis
on 2/20/13, 9:26 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)


Asked: 2/9/13, 8:09 PM
Seen: 4237 times
Last updated: 3/16/15, 8:10 AM