In order to deploy to Azure, the following services should be provisioned.

Database

Nathean Analytics requires access to 3 separate SQL Azure databases as a default

Solution Database This contains all of the datasets definitions, report definitions and security configuration. It doesn’t contain any data.

Audit Database This will contain all the audit activities from the users and server activity.

Data Mart Database This will contain generated datasets which are created by the reporting platform.

Nathean Analytics can also be deployed using less databases and instead using one or two databases using schemas. if using schemas , they should be named as follows:

  • lgx for the Solution Database
  • lgxaudit for the Audit Database

Other databases can use any schema name.

A user login for each database/schema with dbo permissions should be set up and supplied to the individual deploying the software.

It is recommended that the lgx schema is kept separate from the lgxaudit and data mart schemas as it can impact the responsiveness of the environment.

If using schemas, users in each schema should be separated each other by way of grant permissions.

Here is a sample script for creating three schema within two database.

The Nathean Schedule Service which is deployed as a Windows Service on an on premise deployed can be deployed in Azure as embedded or as a stand alone App service. If background report scheduling and delivery is a large requirement, it is recommended to deploy a separate App Service.

So, specifically the following Azure services should be provisioned all in the same region for performance purposes (but not a requirement). Use a single resource group for easier management.

TEST/UAT Instance Example Scaling

2 x Azure SQL Database is a general-purpose relational database-as-a-service (DBaaS) based on the latest stable version of Microsoft SQL Server Database Engine
Solution Database
Audit Database
Datamart Database
Standard S2, 50 DTUs, 250 GB storage

Azure App Service enables you to build and host web apps, mobile back ends, and RESTful APIs in the programming language of your choice without managing infrastructure
Nathean Analytics Web Site
optional Nathean Schedule Service App Service
Standard B3, 400 total ACU, 7 GB memory, A-Series compute equivalent

Production Instance Example Scaling

3 x Azure SQL Database is a general-purpose relational database-as-a-service (DBaaS) based on the latest stable version of Microsoft SQL Server Database Engine
Solution Database
Audit Database
Datamart Database
Standard S3, 100 DTUs, 250 GB storage

Azure App Service enables you to build and host web apps, mobile back ends, and RESTful APIs in the programming language of your choice without managing infrastructure
Nathean Analytics Web Site
optional Nathean Schedule Service App Service
_P2V2, 420 total ACU, Dv2-Series compute equivalent

Azure Relay enables you to securely expose services that run in your corporate network to the public cloud. You can do so without opening a port on your firewall, or making intrusive changes to your corporate network infrastructure.

Of course these can be scaled up and down depending on usage and requirements.

The following Microsoft article describes using alternate URL to the standard xxxx.azurewebsites.net address

https://docs.microsoft.com/en-us/azure/app-service/app-service-web-tutorial-custom-domain

Revision: 9
Last modified: Nov 08, 2019

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment