how to implement multi-company architecture (multi-database)?

Asked by Cuong

Hi,

Currently OpenERP uses shared database for multi-company configuration. I'd like to have a database per company.

Please give me some suggestion on how to implement this? When implementing this, it's sure that the whole data model will be re-written.

Thanks,

Question information

Language:
English Edit question
Status:
Answered
For:
Odoo Server (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Nhomar - Vauxoo (nhomar) said :
#1

Hello

You will need install multi_company module, add multi company access to admin, and explore demo data in the begining,

You will no ever need multi dbs

Revision history for this message
Cuong (bhcuong2008) said :
#2

Hi,

I need isolated database solution. I know this module. Isolated database, separate scheme, and shared database-shared schema, 3 of these have their own pros and cons. As an ERP software, I think isolated database is suitable so I want to implement this topology.

Thanks,

Revision history for this message
Christophe Combelles (ccomb) said :
#3

Why don't you just create different databases? They are isolated by default, it's the easiest thing to do...

Revision history for this message
Cuong (bhcuong2008) said :
#4

Hi Christophe,

multi-company is related. They may share many things. Also it needs to be controlled centrally for more data processing.

Revision history for this message
ViktorNagy (viktor-nagy) said :
#5

e.g. postgresql does not allow cross-db queries, but allows cross-schema
queries

On Tue, Oct 11, 2011 at 11:50 AM, Christophe Combelles <
<email address hidden>> wrote:

> Question #173893 on OpenERP Server changed:
> https://answers.launchpad.net/openobject-server/+question/173893
>
> Christophe Combelles posted a new comment:
> Why don't you just create different databases? They are isolated by
> default, it's the easiest thing to do...
>
> --
> You received this question notification because you are a member of
> OpenERP Framework Experts, which is an answer contact for OpenERP
> Server.
>

Revision history for this message
Numérigraphe (numerigraphe) said :
#6

I think you should check the upcoming v6.1: the new EDI features could make this very much easier:
https://docs.google.com/a/openerp.com/document/d/1OfJzGUsw6fV9Z0uThx1aANC1coN7yuIaBNjFKBdaaCA/edit?hl=en_US&ndplr=1&pli=1#bookmark=id.b291e1a17994
Lionel Sausin.

Revision history for this message
Cuong (bhcuong2008) said :
#7

Thank you for your sharing this document. It's really interesting. Waiting for new 6.1 release :)

I dont understand how EDI feature related to multi-company database configuration.

Revision history for this message
Numérigraphe (numerigraphe) said :
#8

Well I guess it will let you create 1 database per company and automate inter-company processes.
Lionel.

Can you help with this problem?

Provide an answer of your own, or ask Cuong for more information if necessary.

To post a message you must log in.