Azure Enablement in Aptify

Introduction

 Microsoft Azure is a tool that allows businesses to manage their cloud computing and storage accounts with ease. With Microsoft Azure one can manage virtual machines, databases, storage, networking etcetera across multiple subscriptions and locations.

 Aptify release 7.0 provides Azure native support that allows the Aptify applications to run on Azure native constructs. This release enables Aptify to run all of the major application components using Azure platform as a service (PaaS) cloud computing model.

 Azure Enablement activity will be carried out in phases. Release 7.0 introduces phase I activities that targets re-hosting of following Aptify application components:

AptifySA user support

Aptify release 7.0 enables clients to host Aptify database into cloud managed database offerings such as Azure Managed SQL Instance. The cloud services do not grant access to the SA login account provided by Microsoft. By default, the SA user is the only user granted administrative permissions when Aptify is installed. SA user can perform tasks like running license import wizards for newly restored database, and other tasks which requires elevated permissions.

To address the restrictions on SA user in cloud managed database offerings, a new user termed as AptifySA needs to be created and granted same level of roles and permissions as that of the SA user. For more information see AptifySA user support for Azure Enablement.

Setting Network, Security & Monitoring on Azure

As a part of Azure enablement initiative, this release provides directions to set Network Security Rule, Virtual Network, Dedicated subnet for each Azure PaaS services, Firewall, Key Vault, network security and monitoring, and App Insight. See Configuring Network Security Group Structure document for more information.

Hosting SQL Database to Azure SQL Managed Instance

Release 7.0 enables clients to host Aptify database into cloud managed database offerings such as Azure Managed SQL Instance. Azure SQL Managed Instance is the intelligent, scalable cloud database service that combines the broadest SQL Server database engine compatibility with all the benefits of a fully managed and evergreen platform as a service. See Migrating Aptify database on Azure SQL Managed Instance document to learn more about the topic.

Hosting Web Application to Azure App Service

Azure App Service is an HTTP-based service for hosting web applications. App Service not only adds the power of Microsoft Azure to your application, such as security, load balancing, autoscaling, and automated management but also you can take advantage of its DevOps capabilities.

Release 7.0 enables hosting of all the Web applications namely Aptify Web, e-Business 6, classic e-Business (CMS & Non-CMS) websites on Azure App Service.

Refer to documents Migrating e-Business Classic (Non-CMS) to Azure, Migrating e-Business Classic (CMS) to Azure, Migrating e-Business 7.0 to Azure App Service, and Migrating Aptify Web to Azure App Service to know more about the topic.

Moving Aptify Application Server Schedule Jobs to Azure Web Jobs

Web Jobs is a feature of Azure App Services that runs a program or script in the same instance as a web app, API app, or mobile app.

Release 7.0 enables moving Aptify Application Server schedule jobs to run as an Azure WebJobs for managing the scheduled asynchronous jobs. Web Jobs is a feature of Azure App Services that runs a program or script in the same instance as a web app, API app, or mobile app. To know more about this implementation, refer Azure WebJobs for schedule tasks, and Process flow run WebJobs documents.

Hosting Desktop Application on Azure Virtual Machines

With Azure enablement in 7.0, it is possible to host Aptify Smart Client (Desktop) application on an Azure Virtual Machines and connect the client to the database hosted on Azure SQL Managed Instance. See Installing Aptify Smart Client (Desktop) application on Azure Virtual Machine for more details. 

Hosting SSRS Reports on Azure Virtual Machines

Release 7.0 enables Aptify SSRS Reporting services for Aptify Smart Client (Desktop) and Aptify web to be hosted on Azure Virtual machine.  Refer to Hosting SSRS Reports on Azure Virtual Machine for more details.

Deploying Crystal Reports on Azure Virtual Machines

Release 7.0 enables Aptify Crystal Reporting services for Aptify Smart Client (Desktop) and Aptify web to be hosted on different Azure Virtual machine.  Refer to Deploying Crystal Report on Client System for more details.

Azure BLOB storage for Uploading/Downloading the Attachments

Azure BLOB storage is Microsoft’s object storage solution for the cloud.

Aptify 7.0 enables the users to store attachments on Azure BLOB storage instead of the database. As part of Azure enablement for Aptify, the users will now be able to upload and download the attachments on Azure BLOB storage. A utility has been provided to migrate existing attachments from database to BLOB storage.

Release 7.0 also provides facilities for on-premises customers to leverage attachment storage in Azure Blob.

To use cloud service for BLOB storage attachments in Aptify Web, refer to Configuring and Uploading Attachments on Azure BLOB Storage.

Migrating Attachments from SQL Database to Azure BLOB storage

In Aptify, attachments are stored in database.

To support Azure BLOB storage, Release 7.0 provides a utility to migrate the existing attachments from database to BLOB storage. See document Migrating Aptify Attachments to Azure Blob Storage for instructions on how to perform the migration. 

Authentication using Azure Active Directory on Aptify Web

Azure Active Directory is an enterprise identity service that provides single sign-on, multifactor authentication, and conditional access to guard against cybersecurity attacks.

Release 7.0 uses Azure AD as the authentication mechanism for the users to access Aptify Web, once the applications are hosted on Azure.

For more details on how Azure AD can be configured in Aptify refer to Authentication Using Azure Active Directory for Aptify Web document.

Serilog Integration with Azure Application Insight

With release 7.0, Aptify Web and Smart Client can be configured to use Serilog and Application Insights to log application related information such as errors, warning messages etcetera to text file and to Azure Application Insights. Refer Configuring Serilog with Azure Application Insights to know more.

Azure Deployment

Release 7.0 provides standard Infrastructure-as-Code (IaC) templates which are code-based template for automating the provisioning of cloud resources and configurations for Aptify. These templates can be used by development teams to quickly and easily configure and deploy Cloud resources more efficiently.

Once the resources are deployed on Azure using the template, the hosting of the Aptify database, Web application, desktop application, Reports can be done using the migration instructions given in Deploying Aptify 7.0 on Azure document.