Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [multitenancy]

The tag has no usage guidance.

-1
votes
0answers
15 views

Implement Multi-Tenant application with Umbraco

I am using Umbraco 7.8.1. I need to develop an application with multi-tenancy where there are multiple communities/sites. Here I have explained my whole scenario and we have decided to go with ...
0
votes
1answer
54 views

Where to apply multi-tenant logic (ASP.Net Core)?

I'm developing a multi-teant SaaS application in ASP.NET core mvc and I was wondering what the general approach is to applying tenant logic in a shared database scenario (TenantId for each entity). ...
6
votes
2answers
439 views

Scalability: Millions of tables vs one big master table and millions of views

We have to migrate an old (million LOC) system from SAP ADS (formerly Sybase) ISAM based (so called free tables) based system to a PostgreSQL database. The system implements kind of multitenancy ...
1
vote
4answers
241 views

How to handle common data in multi-tenant applications

I am designing a multi-tenant application which will use the same database schema for a separate DB instance per-tenant (i.e. every time I get a new customer, I create a new database for them). This ...
2
votes
3answers
461 views

Logical separation of database content

Background I have an application which stores a lot of entities in a classical relational database (Microsoft SQL Server) and I use an ORM (Entity Framework) to query data from it. This database has ...
1
vote
3answers
484 views

Database per tenant approach, single or multiple database server(s)?

I'm tasked with investigating the different approaches for multitenancy. Currently I'm expanding my demo application to use the database per tenant approach. Now where I'm getting unsure is that in a ...
1
vote
1answer
104 views

Determining tenant for anonymous multi tenant api endpoint

I'm in the process of building a new api that needs to support multi tenancy. I can figure out how to implement reading and writing the data securly without having to worry about clients being able ...
0
votes
1answer
291 views

API design for multi-tenant web app - how to identify users from another system?

I have a multi-tenant web application that allows authenticated users to make changes to their application instance - making comments as an example. I'd like to build an API that allows a user of any ...
4
votes
2answers
220 views

How to properly use a database containing common tables in a multi-application system?

I'm trying to determine the best application and database architecture for a project I am working on. The idea is that there will be multiple, separate applications that will all share a few tables ...
-3
votes
1answer
121 views

Best way of authenticating users using multi-tenant application

I have been asked to develop a multitenant application where, Company/Users can log in, a user can belong to a company, but I has been asked specifically that they don't want to be inviting users to ...
0
votes
1answer
158 views

Can we use shared schema multi tenancy(using tenant_id column to scope) combined with seperate schema approach

I am working on a ruby on rails learner project that uses multi tenancy. This project has states(tenant) and cities(sub-tenants). User can only belong to one city. For first level i.e for states I ...
-1
votes
1answer
113 views

Connect to different database based on URL

I am developing a SAAS application where : A single web application is hosted in IIS which will serve to multiple companies and each company will have its own database. The web application and ...
1
vote
0answers
1k views

Using import.sql vs persisting JPA entities

In Hibernate ORM & Spring Boot, during the SessionFactory creation, SQL DML statements can be executed to create tables and/or insert data via files such as import.sql defined in the javax....
2
votes
1answer
2k views

Designing a multi-tenant single page application for the web

I'm looking at designing a multi-tenant application (well I believe it is multi-tenant). We have a single page application, an API and common database. We have groups of users, each with their own ...
3
votes
2answers
6k views

What exactly is a multi-tenant application?

According to the definition available online is "Multi-tenancy is an architecture in which a single instance of a software application serves multiple customers". It meann I have a Restaurant or ...
2
votes
2answers
710 views

Techniques for efficiently partitioning data in a shared multi-tenant database

I work for a franchise and am beginning the complete redesign of the application that each franchise uses to manage its daily operations. It functions as a point of sale and scheduling application. ...
1
vote
1answer
209 views

How to decide level of Single Tenancy vs Multi Tenancy for application

How would one implement a multi tenancy application structure with the following technologies: Multiple SQL Server Databases (One per tenant) Asp.Net Entity Framework Active Directory and possibly ...
17
votes
2answers
13k views

Do multi-tenant DBs have multiple databases or shared tables?

Is a multi-tenant database: A DB server that has a different (identical) database/schema for each customer/tenant?; or A DB server that has a database/schema where customers/tenants share records ...
2
votes
1answer
411 views

Multi-tenant cloud application and user credentials

I'm building a multi-tenant cloud application and actually I need a bit of help to solve a situation about the login. My app is a webscheduler, this allow to each customer to have a certain location ...
0
votes
1answer
138 views

How should multi-tenancy be implemented for child resources in a SaaS database design?

In SaaS multi-tenant database design, do you think it is sufficient to include the tenant id only in top-level resources, knowing that child resources will always be parent-scoped, or should every ...
7
votes
2answers
363 views

Composite-keys in multi-tenancy application for administrative actions

I've designed a single-instance database for a multi-tenant application which uses composite-keys to enforce tenant-segregation at the database-layer (thus preventing incorrect 3rd-degree relations). ...
1
vote
3answers
154 views

Multi-tenancy…as opposed to what?

In the last several years I keep hearing the term multi-tenancy being thrown around, and each time I Google its meaning it leaves me confused: (Wikipedia) : The term "software multitenancy" refers ...
3
votes
4answers
553 views

Multitenant app or separate instance for every customer

Suppose you are selling a web app. There is no data or operation that involves more than 1 customer. Each customer is totally separate. How would you prefer to make the deployments? 1) Deploy one ...
0
votes
1answer
43 views

web service that can run in both Cloud and Standalone configurations [closed]

My company develops technology for visitor management. We currently have 2 solutions, one that is in the field, running on on-site hardware. The other is cloud, running on the cloud and processing all ...
0
votes
2answers
160 views

How to manage context objects in a multi tenant application?

I'm building a Web API that interfaces SharePoint (an external web service). To get at connection to the external service I need to create instances of ClientContext with some kind of token. For this ...
0
votes
1answer
929 views

Single Database Vs Multiple Database on SQL Server

we have web application which stores information in backend SQL 2014. currently the way is set up that central database stores all key information for the customers and then we have seperate database ...
2
votes
1answer
538 views

Is Multi-Tenancy a viable option in any Java RAD Frameworks?

I've worked as a Full Stack Java Web Developer for many years now and of all the projects I have worked on two things are true of all of them: They were all Multi-Tenant applications with one ...
6
votes
2answers
3k views

What are the advantages of using multi-tenant architecture with separate db schemas per customer?

I have a client that wants me to build a SaaS application with a multi-tenant architecture, where different clients will go in a separate schema on the same db server. I have seen this architecture ...
2
votes
1answer
2k views

How to handle db authentication in multi tenant application with separate databases?

In a multi tenant application with separated databases for each tenant, what would be the best way to authenticate connection to each of these separate databases. My goal is to: Main security ...
8
votes
2answers
4k views

Multi tenancy or multi instance?

I'm trying to build a web-based SaaS solution, and I hit a road where I'm not sure to use multi tenancy or multi instance. I will try to describe what I'm trying to achieve, and each approach ...
0
votes
1answer
476 views

Patterns for migration to multi-tenant application [duplicate]

I have a complex web application that manages stores and their customers. The application follows a basic MVC architecture and I should migrate it to a multi-tenant application: - I should go from ...
1
vote
1answer
1k views

Multi-tenant database design

My boss is currently working on a database design for a multi-tenant capable ERP/CRM system, which will have a Sql Server backend. Some key points of the design: A server instance will host a "...
2
votes
0answers
268 views

Global Accounts in Multi-Tenant Authorization System

Our system is fundamentally a multi-tenant setup, where each client maintains a separate database with its own data and users. The authentication system on login issues an authentication token which ...
2
votes
1answer
453 views

Use of tenant_id in multi-tenant database

We are building a SASS web application where every company will be using its own database schema. Using postgresql, there is a table 'companies' in the public schema that holds the name of the company ...
1
vote
1answer
1k views

Symfony 2 Multi tenancy architecture, data loaded form front controller/kernel based on subdomain

Hello fellow programmers, (a bit of background)I'm building a Symfony 2 application for university Student accommodation, when our clients from the university side register with their details a ...
2
votes
0answers
216 views

Active Directory Federation for multi tenant application

For AD Federation in a multi-tenant environment- My research so far with Azure, tells me that the onpremise AD needs to be integrated with the cloud AD. Are there any cons/ security concerns with ...
1
vote
1answer
261 views

Multitenancy and nested set trees

The application I work on utilizes nested sets1 to represent tree structures within our database. We need to expand a particular area of access control to support multiple clients who should not be ...
0
votes
0answers
55 views

Authorizing view content

Let's say I have a view which should change it's content based on the user resp. on the users permission. After some research I basically found 2 types of authorization. Role-Based and Activity-Based ...
1
vote
2answers
309 views

Design for a shared checkout

I am currently working on a ecommerce system that is slightly different in structure to a typical ecommerce system in that you have multiple stores, accessing the same database from different URLs. ...
2
votes
2answers
3k views

in multi-tenant systems what is the correct practice for segregating each tenants data from each other?

I am a first-time azure developer and I am taking over a single-tenant cloud system and have been tasked with converting the system to multi-tenant. What is the correct practice to separate each ...
3
votes
0answers
371 views

How to deal with runtime changes to tenant-location in a clustered, multitenant web application with app-managed datasources?

I have a Java web application that supports multi-tenancy to keep customer data separate. Connection pools to each customer database are created at runtime. The details of each customer shard (...
2
votes
1answer
547 views

Design for migrating to Multitenant architecture

We are in a process of redesigning our product code in such a way so as to support multitenancy. Currently the implementation is such that one product deployment caters to only one customer. Thus ...
3
votes
2answers
589 views

multitenancy with some data sharing

I'm in the planning stages of a new webapp, and I am leaning strongly toward a multitenancy model. The app has a file storage function, where the user can upload (and operate on) files. I would like ...
19
votes
5answers
22k views

Multi-tenancy - single database vs multiple database

We have a number of clients, whose systems share some functionality, but also have quite a degree of diversity. The number of clients is growing - always a healthy thing! - and the diversity between ...
7
votes
1answer
749 views

If multitenancy is a priority, should I store site content in the database?

I have a multi tenant ASP.NET MVC website and all client specific text is stored in resource files. Every time someone wants to change text I have to jump through hoops and fill out forms and let ...
10
votes
3answers
2k views

Supporting multitenancy

What are the typical challenges that arise when converting a single-tenant app into a multitenant app? Security and data isolation strike me as the most significant. What are some others? I'm one of ...
30
votes
6answers
33k views

Should I use one database per application or share a single database amongst multiple applications [closed]

I have multiple applications some that use data from the same sources. Is it best practice (or what are the pros/cons) to: leave the data in databases shared by multiple applications saves space as ...