We're building about 10 ASP.NET MVC sites which have a common set of features (and corresponding URLs, Routes, Controllers, Actions, and Views). The sites will also all share a base set of domain objects (e.g. users, companies) and base attributes on those objects (e.g. name, address, etc.). But each site will also be highly customize...
Having a single persistence-unit defined in a persistence.xml with all entity specifications, does anyone knows how to make eclipselink load different EntityManagerFactory for different databases in the same running application? Thanks in advance. ...
I have a simple ASP.NET MVC + OpenID + NHibernate app (on top of MSSQL Server DB). The app is strictly single tenant and supports multiple users with only 2 roles (Admin and User). I would like to convert this app into a multi-tenant app. My requirements are limited: I just need to introduce the notion of Accounts, each account having i...
I would like to setup a multi-tenant ASP.NET MVC app. Ideally, this app would have a route with {tenant}/{controller}/{action}/{id}, each tenant representing an logical instance of the app (simply independent multi-user accounts) The fine grained details how do that are still quite unclear to me. Any guide available to setup such multi-...
Basically something that handles the low-level "plumbing" code for a subscription-based service. I see a lot of things dealing with basic membership, but nothing that handles the subscription aspect (recurring billing, automated jobs for setting up billing, notification for billing, etc). This might be the one thing that keeps me from ...
Every tutorial I've seen about Multitenant database models tells you to put the TenantID in every single table: zoos ------- id zoo_name tenant_id animals ------- id zoo_id animal_name tenant_id However, this seems redundant to me. Why not add the tenant_id column to just the zoos table and exploit the foreign key relationship betwee...
Hello! I'm writing an application that that I'm going to provide as a service and also as a standalone application. It's written in Zend Framework and uses MySQL. When providing it as a service I want users to register on my site and have subdomains like customer1.mysite.com, customer2.mysite.com. I want to have everything in one datab...
Hi! I'm working on multi-tenant application in Zend Framework which gets it's tenantID from the subdomain name (mod_rewrite -> index.php -> matches it against the database). My question is - how do I set this variable (tenant id) to be available for every Controller? Leonti ...
This question is different from the others because all of the questions I've seen so far are talking about the database. I understand the database side of multitenacy, but I'm not 100% sure on the way to do the front end. I'm working on the design for a product that will basically be a hosted service for customers. As far as the multite...
Hi there, My app needs to support multiple customers at run time. They will all be displaying the same data, using the same controllers, services but with different layouts, css and images. My basic idea is as follows: 1) Have a filter to authenticate and set a config value in the session 2) My controller code will call something alo...
Our requirement is something like this. We are building a multi-tenant website in ASP.NET MVC, and each customer should be able to create their own users as per predefined user roles. We are thinking about to create a schema for few tables which would be common for customers. So customer can login to system according to their schema lo...
HI There, i have to make my application SAAS compliant .For achieving multi tenancy , i was thing of partitioning the data , and each partition will be for a tenant. and this partitioning will be done dynamically . has anybody done something like this ? what do you think the better approach be ? i am using SQL 2005 Regards DEE ...
I'm working on a multi-tenant rails application using PostgreSQL schemas for different clients. Rails migrations don't work with multiple schemas out of the box, so I made the following rake task to migrate all schemas and it seems to work. My question is if others have implemented better and more elegant solutions. I would also be reall...
I have a multitenant application in ASP.NET MVC. The instance of the application that will be served is function of the hostname alone (something along the lines of stackexchange, I suppose). Each instance of the application might have a different culture setting (even "auto", to read the browser's language and try to use it), and will ...
Yet another multi tenancy post im afraid. I just cant find a good solution to my problem, I have read all the great posts on multi tenancy for ASP MVC but I still need some good advice. Im going to create a corporate presence for one of my customers. Their company structure is like a main company (ex. Acme Group Ltd.) which own several ...
Hi, i am working on a project that you can subscribe with your company name and you can use all features of site specificly to your company. for example company abcd can get its own url from our website like www.test.com/abcd/productlist.aspx company efgh can also login with its own url and see its product list. www.test.com/efgh/pro...
I ahve a multi tenant Django database. All my multi tenant enabled models import from a class AccountSpecificModel, which as a FK to a class Account. Now I have some unique=True and unqiue_together in Meta, which do not specify account. In my scenario, for AccountSpecificModel uniqueness has no menaing unless it takes care of account, w...
Sorry for the confusing title. I tried to make it less verbose, but... What I'm wondering is: Does Django's new row level permissions (a) fix the design problem that comes with multi-tenant applications (I don't mean multiple users, but rather multiple instances working with the same db/db schema), or is it (b) just a more complex versi...
We have a multi-tenant website where we use a wildcard SSL cert to give people a subdomain to our site. Some of our customers would like to use their own domain, but I'm concerned about how we would manage each customer's certificate as our business grows. Currently the certificate resides on the web server, which means loading all of th...
Our software currently runs on MySQL. The data of all tenants is stored in the same schema. Since we are using Ruby on Rails we can easily determine which data belongs to which tenant. However there are some companies of course who fear that their data might be compromised, so we are evaluating other solutions. So far I have seen three ...