microsoft/wingtipticketssaas-dbpertenant

A sample multitenant SaaS application using a database per tenant model, built on Azure SQL Database. Includes management scripts for a range of scenarios.

Wingtip Tickets SaaS - Database per Tenant

Sample multi-tenant SaaS application and management scripts built on SQL Database using a database-per-tenant model.

Looking for one of the other SaaS app patterns? Learn more about the Standalone application and Sharded multi-tenant versions.

Wingtip Tickets SaaS app

The Wingtip Tickets app is a simple event listing and ticketing SaaS app, where each venue is a tenant with events, ticket prices, customers, and ticket sales. The app, together with the management scripts and tutorials, showcases an end-to-end SaaS scenario. This includes provisioning tenants, monitoring and managing performance, schema management and cross-tenant reporting and analytics, all at scale. This application is functionally identical across all three versions repositories.

Database per tenant SaaS pattern

This project showcases the database per tenant model. This model is effective for service providers that are concerned with tenant isolation and want to run a centralized service that allows cost-efficient use of shared resources. A database is created for each venue, or tenant, and all the databases are centrally managed. They can be hosted in elastic pools to provide cost-efficient and easy performance management, which leverages the unpredictable usage patterns of the tenants. A catalog database holds the mapping between tenants and their databases. This mapping is managed using the shard map management features of the Elastic Database Client Library, which also provides efficient connection management to the application.

Get started - Deploy sample app

NOTE: If you install the application, you will be charged for the Azure resources created. Actual costs incurred are based on your subscription offer type but are nominal if the application is not scaled up unreasonably and is deleted promptly after you have finished exploring the tutorials.

The basic application, which includes three sample databases for three venues, installs in your Azure subscription under a single ARM resource group. To uninstall the application, delete the resource group from the Azure Portal.

To deploy the app to Azure, click the link below. Deploy the app in a new resource group, and provide a short user value that is appended to resource names to make them globally unique. Your initials and a number is a good pattern to use.

After deployment completes, launch the app by browsing to http://events.wingtip-dpt.USER.trafficmanager.net in a web browser, substituting USER with the value you set during deployment.

Get started - Run management scripts and tutorials

IMPORTANT: If you download and extract the repo or Learning Modules from a zip file, make sure you unblock the .zip file before extracting. Executable contents (scripts, dlls) may be blocked by Windows when zip files are downloaded from an external source and extracted.

To avoid scripts from being blocked by Windows:

1. Right click the zip file and select Properties.
2. On the General tab, select Unblock and select OK.

You will find management scripts in the repo that allow you to explore many SaaS management scenarios, including provisioning tenants and monitoring performance, managing database schema, analytics, and more. You can find the tutorials associated with these scripts in Azure SQL database documentation.

Also available in the Documentation folder in this repo is an overview presentation that provides background, explores alternative database models, and walks through several of the SaaS patterns at a high level. There is also a demo script you can use with the presentation to give others a guided tour of the app and several of the patterns.

License

Microsoft Wingtip SaaS sample application and tutorials are licensed under the MIT license. See the LICENSE file for more details.

Contributing

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.

wingtipticketssaas-dbpertenant's Issues

Single tenant sharding pattern

It is mentioned in this stackoverflow article that data dependancy routing is an overkill when it comes to single tenant sharding pattern. Can someone please explain on this?

https://stackoverflow.com/questions/50781540/azure-elastic-scale-database-per-tenant-how-to-implement-data-dependent-routing#

Change "wtp" to "wingtip-dpt"

https://github.com/Microsoft/WingtipTicketsSaaS-DbPerTenant/blob/89d9fdee6980b2a3a04fe561afc02214d97760ab/Learning%20Modules/Provision%20and%20Catalog/Demo-ProvisionAndCatalog.ps1#L63

App's URL returns 404

Accessing the app's URL about 25 minutes after deployment completion returns the result below.

I've tried twice - the second time using a 'random' username in case duplication was the issue.

Demo-ProvisionAndCatalog.ps1 Fails

This Powershell file fails looking for a Resolve-DnsName cmdlet in Get-ServerNameFromAlias on line 41:
$serverName = Get-ServerNameFromAlias $newTenantAlias

That cmdlet is also used in several other Powershell files and will probably fail there.
Here's the exact error message:

Get-ServerNameFromAlias : The term 'Resolve-DnsName' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was
included, verify that the path is correct and try again.
At C:\Users\pkandra.ATLANTA\Downloads\WingtipTicketsSaaS-DbPerTenant-master\WingtipTicketsSaaS-DbPerTenant-master\Learning Modules\Provision and Catalog\Demo-ProvisionAndCatalog.ps1:41
char:19

• $serverName = Get-ServerNameFromAlias $newTenantAlias
  

•               ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  

  • CategoryInfo : ObjectNotFound: (Resolve-DnsName:String) [Get-ServerNameFromAlias], CommandNotFoundException
  • FullyQualifiedErrorId : CommandNotFoundException,Get-ServerNameFromAlias

Find-AzureRmResource not recognized

cd WingtipTicketsSaaS-DbPerTenant\Learning Modules\Provision and Catalog> .\Demo-ProvisionAndCatalog.ps1

After selecting the subscription I'm getting this:

WingtipTicketsSaaS-DbPerTenant\Learning Modules\Provision and Catalog\Demo-ProvisionAndCatalog.ps1 : The term 'Find-AzureRmResource' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the 
name, or if a path was included, verify that the path is correct and try again.
At line:1 char:1
+ .\Demo-ProvisionAndCatalog.ps1
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Demo-ProvisionAndCatalog.ps1

Looks like the script could do with an update, https://docs.microsoft.com/en-us/troubleshoot/azure/general/find-azurermresource-fails

This repo is missing important files

There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

How to provision databases in advance without knowing the tenant name?

Is it possible to have tenant databases in sequential numbers like tenantdb0000001 and incrementing and have the tenant names mapped to it so that we can provision databses in advance and assign them to new tenant as they signup/

update to 5.0 ef6

Getting the wrong URL Which does not exist

while visiting the tenant i m getting the https://events-wingtip-dpt-cr4.eastus2.....
Why i m getting cr4 in the location since my location is only eastus2.
when i m removing that cr4 portion then the url is working.
And how can i remove "cr4"

Resolve-DnsName : catalog-patrickg.database.windows.net : DNS name does not exist

It looks like there is an issue in .\Learning Modules\Common\CatalogAndDatabaseManagement.psm1:987 char:34 The path is returning catalog-patrickg.database.windows.net when it should be returning catalog-dpt-patrickg.database.windows.net

I got this error running Demo-LoadGenerator.ps1

Support for latest Az commands

[Questions] Support REporting Services / Analisis Services

Today I work on a product where we are using:
sql server
reporting services
analisis services
All these product are installed per user in most of the cases and we are looking work with multitenant arch.

I am looking forward your github repo& docs I would like to know if you have more materials related with:
Reporting services working with multitenant
Analysis services working with multitenant
Thanks in advance.

Does not build

Does not build. After i download and restore I get below error every time i try to build :(

Error CS0017 Program has more than one entry point defined. Compile with /main to specify the type that contains the entry point. Events-TenantUserApp D:\VSRubbishProjects\WingtipTicketsSaaS-DbPerTenant-master\App\src\Events-TenantUserApp\Program.cs

I am using the most up to date vs 2017 as of this post

Updating to NET5

Hi there!
Thank you for all useful information in your repo and ms docs page!
Today I tried to get the latest of your repo and I can see that the solution is not compatible with Vs2019.- Any idea if you are going to migrate the code to latest version ?