Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
People, is possible to have a Replica DB and run Pentaho Reports on the Slave(ReadOnly)?
We try this but is not working, we setup odoo in both Master/Slave, Pentaho just in the slave because we want to move our report DB load to the slave. Went we run any reports we detect that Odoo want to update records(our reports are sql consult only select), but this affect and none of our reports run in the slave. The master no problem because can write to the DB, but odoo or pentaho run update records for session or internal info they manage.
Our plan is to move our reports to other server with a DB in sync with the master.
Any recommendation in how to attack this plan?
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 platform 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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 8/23/16, 1:22 PM|
|Seen: 217 times|
|Last updated: 8/23/16, 5:43 PM|