Ferramenta para otimizar a importação dos dados de novos clientes do sistema Flowup

Abstract

The data migration between systems is still a complex task for software developers today. This has a considerable contribution from the various types of databases that exist and the lack of standard in the construction of projects. This same difficulty is perceived for online business management systems, known as Cloud ERP (Cloud Enterprise Resource Planning). These online systems can integrate all areas of the company on a single platform. And if there is a problem, be it a failure in some functionality, inconsistent data, or even a failure in the connection with the server, a great loss can be generated to the company that hired the system. In these cases, the contracting company is totally dependent on the system with its supplier company. In this context, the problem can be solved by changing the Cloud ERP system. With the aim to facilitate, streamlining and making flexible the import of data from a spreadsheet into a Cloud ERP system, it is proposed in this work the Migrup tool. In this way, the contracting company of another system will be able to export the data from its system to a spreadsheet; with that, the company will have the possibility to migrate to Flowup using Migrup to import its data. Migrup was developed using the Design Thinking methodology to build a creative solution and, thus, meet the user’s needs. Then, in the implementation stage, it was defined that the ETL (Extract Transform Load) process would be used, which is widely used in the migration of data between systems, with the objective of extracting data from a source, adjusting and adapting this data and , then load them to a destination. Thus, an ETL tool was used to facilitate the implementation. The use of this tool, through a graphical environment, with several options of components for different purposes, facilitates the implementation and makes maintenance faster and more practical. Compared to the import tools of the other systems mentioned in this work, including the legacy tool of the Flowup system, Migrup encompasses almost all the features and characteristics present in these other tools, bringing several benefits to users in a single tool. The main ones were: available to customers, import any spreadsheet format, faster error detection, correction in the format of some data and presentation of a report after the import process execution.