Multiple Databases or not
Currently I am developing a report solution so customers can login and see reports regarding his stores (one or multiple). and I want to use the best approach.
- We will upload the same tables to ZOHO from multiple locations
- A customer can have one or multiple stores that needs to see on ZOHO.
What will be the best approach.
1) Have only one database receiving data from all customer/stores with a UniqueID and filter by SQL statement (maybe UserId) for the reports.
2) Create multiple databases (one per customer) receiving data from only the customer stores.
Thanks!