AnsweredAssumed Answered

Hosting sales solution for multiple clients - how to handle versioning?

Question asked by on Feb 2, 2014
Latest reply on Feb 6, 2014 by Malcolm

I have a CRM written for my industry that I would like to rent to others on a SAAS basis.

Of course, everything between client companies must be kept separate.


  1. Do I need to install completely separate databases for each client, or can I separate the data and logic layers so that all I need to do is point to each client's data tables, respectively?
  2. If just data tables, what is the best way to handle that? On the web, I'd use cookies listing the DSN (datasource) but I'm not sure with Filemaker to to both keep it secure and reliable
  3. If separate databases entirely, what is the best way to handle upgrades/versioning? I'd really NOT like opening 100 or 100s of client program to make one or a few tweaks at a time


Thanks in advance for any help.