A usabilidade do T-SQL na construção e manutenção de processos ETL

Abstract

This technological report aims to present the usability of the T-SQL language (Transact-SQL) - a variation of the SQL language (Structured Query Language) developed to interact with the Microsoft SQL Server database - in the construction and maintenance of ETL processes (Extract, Transform and Load, from Portuguese: Extraction, Transformation and Load) in Business Intelligence and Business Analytics environments. In this technological report, we carry out a review of the bibliography to understand the main characteristics and functionalities that deal with the concepts of Business Intelligence, Business Analytics, ETL processes and the T-SQL language, exploring the suitability of these concepts for the implementation and maintenance of ETL processes. Thus, using T-SQL and its Microsoft ecosystem, we present the construction and maintenance of the ETL Processes of a leading Brazilian company in a strategic sector, where the results obtained allowed us to understand the challenges faced by developers and analysts, the best practices adopted by them and the benefits obtained from using the language in this context, where it was found that T-SQL is a powerful and flexible language for building and maintaining ETL processes. However, we also identified some limitations of the language in question applied to ETL processes, mainly regarding the complexity of operationalization, maintenance and costs of those processes.