ansaurus

Question

Enable ERP application to support multiple clients

Answer 1

A:

You could re-install it on a second server. If you have a license to do that of course. What ERP application is it?

Edit:

For our ERP product, I use a segment of the url to distinguish the database. e.g.

http://myserver.com/company1/customers

versus

http://myserver.com/company2/customers

All urls that are embedded in documents are relative urls so they stay within the same company.

Darrel Miller 2009-05-25 23:41:15

Hi;Pardon my English, I forgot to mention that the application is ours, but the company developed it as a standalone product (i.e. delivered and installed at the client's server) but we want to present it as a hosted service on our servers such as Highcamp.

2009-05-25 23:46:33

I'm thinking that if this is your company's application, and you wrote it, and you have difficulty with this sort of thing, you may have a bit of a problem that really needs an expert consultant for several months, rather than StackOverflow...

Curt Sampson 2009-05-25 23:52:15

Well I know Stackoverflow won't re-write the whole thing, I am just looking for ideas on how to implement this. any ideas?

2009-05-25 23:58:50

@Darrel: So you actually create sub folders on the server and copy the code there or do you use some sort of URL rewriting?

2009-05-26 00:32:22

We have our own REST based framework that handles the URL routing. There is only one set of code that handles all the databases.

Darrel Miller 2009-05-26 00:40:00

Answer 2

+1 A:

It totally depends on the architecture of your application and your DB structure, if the refactor is too hard maybe the solution would be to have multiple instances of the ERP. Also as it is an ERP (with sensitive information of a company) you might have to install the instances in different servers, to ensure your clients won't be storing financial information with other companies in the same machine.

You can have one 'big' server virtualized. I'd suggest you to have a reverse proxy to redirect the requests from multiple subdomains to your virtualized guests. Also you can have a template of a virtualized server with Apache, PHP and your ERP installed ready to be installed in the virtualization host. When a client buy your product you just install and turn on that virtual guest and provide the client access.

victor hugo 2009-05-25 23:56:42

Each instance should have its own copy of the database thus acheiving database separation. But could you ealborate a bit on that idea. Thanks

2009-05-26 00:22:40

ansaurus

tags:

views:

answers:

Enable ERP application to support multiple clients

related questions