| Name: | Description: | Size: | Format: | |
|---|---|---|---|---|
| 1.7 MB | Adobe PDF |
Authors
Advisor(s)
Abstract(s)
O Tableau é uma ferramenta de Business Intelligence que contém uma extensão denominada Write-Back, criada pela empresa Xpand IT, que permite a escrita dinâmica de conjuntos de dados no Tableau. Com esta dissertação, pretende-se efetuar a migração da aplicação Write-Back, que é uma aplicação on-premise, para um Software as a Service. Esta migração foi feita na plataforma da Microsoft Azure com um Azure App Service, um Azure SQL Database, um Azure Front Door e um Azure Application Insights.
Efetuou-se um estudo da aplicaçãoWrite-Back on-premise atual e sobre Software as a Service (SaaS), verificando-se que são precisos assegurar 3 requisitos principais para construir uma aplicação SaaS, nomeadamente a segurança e multi-tenant, a escalabilidade e a robustez. Seguidamente, foram efetuadas algumas mudanças para assegurar uma arquitetura multi-tenant, como foi o caso da gestão dos tenants de forma dinâmica, a otimização
das queries da base de dados do Write-Back e a garantia da segregação total entre os utilizadores.
Por último, foram efetuados testes de desempenho na aplicação SaaS, tendo-se chegado à conclusão de que com a capacidade e da versão do servidor adquirido, a aplicação conseguirá suportar entre aproximadamente 400 e 600 interações, com um período de crescimento de 0.1 segundos.
Tableau is a Business Intelligence tool that contains an extension calledWrite-Back, created by the company Xpand IT, which allows dynamic writing of datasets in Tableau. With this dissertation, we intend to migrate the Write-Back application, which is an on-premise application, to a Software as a Service. This migration was performed on the Microsoft Azure platform with an Azure App Service, an Azure SQL Database, an Azure Front Door and an Azure Application Insights. A study was carried out on the current on-premiseWrite-Back application and on Software as a Service (SaaS), verifying that it is necessary to ensure 3 main requirements to build a SaaS application, namely security and multi-tenant, scalability and robustness. Then, some changes were made to ensure a multi-tenant architecture, such as the dynamic management of tenants, the optimization of the Write-Back database queries and the guarantee of total segregation between users. Finally, performance tests were carried out on the SaaS application, reaching the conclusion that with the capacity and version of the server purchased, the application will be able to support between approximately 400 and 600 interactions, with a ramp-up period of 0.1 seconds.
Tableau is a Business Intelligence tool that contains an extension calledWrite-Back, created by the company Xpand IT, which allows dynamic writing of datasets in Tableau. With this dissertation, we intend to migrate the Write-Back application, which is an on-premise application, to a Software as a Service. This migration was performed on the Microsoft Azure platform with an Azure App Service, an Azure SQL Database, an Azure Front Door and an Azure Application Insights. A study was carried out on the current on-premiseWrite-Back application and on Software as a Service (SaaS), verifying that it is necessary to ensure 3 main requirements to build a SaaS application, namely security and multi-tenant, scalability and robustness. Then, some changes were made to ensure a multi-tenant architecture, such as the dynamic management of tenants, the optimization of the Write-Back database queries and the guarantee of total segregation between users. Finally, performance tests were carried out on the SaaS application, reaching the conclusion that with the capacity and version of the server purchased, the application will be able to support between approximately 400 and 600 interactions, with a ramp-up period of 0.1 seconds.
Description
Relatório de desenvolvimento do trabalho para obtenção do Grau de Mestre em Engenharia Informática e de Computadores
Keywords
Migração SaaS Computação na nuvem Write-back Tableau Migration SaaS Cloud computing Write-back Tableau
Citation
Guerreiro, Diogo Gomes Pinto - Desenvolvimento de Vertente SaaS para Produto de Submissão de Dados em Plataformas de Business Intelligence. Lisboa: Instituto Superior de Engenharia de Lisboa, 2022. Dissertação de Mestrado.