Viegas, Carlos Manuel DiasSousa, Gabriel Felipe Azevedo de2023-12-142023-12-142023-12-11SOUSA, Gabriel Felipe Azevedo de. Desenvolvimento de uma estrutura unificada de dados dos sistemas eletrônicos do poder judiciário brasileiro utilizando Pentaho Data Integration. 2023. 55f. Trabalho de Conclusão de Curso (Graduação em Engenharia de Computação) - Departamento de Engenharia da Computação, Universidade Federal do Rio Grande do Norte, Natal, 2023.https://repositorio.ufrn.br/handle/123456789/55920This work addresses the development of a unified data structure using Pentaho Data Integration for the Court of Justice of the State of Rio Grande do Norte (TJRN), in accordance with the criteria of DataJud, a database of procedural data and metadata from the National Council of Justice (CNJ). The main motivation of the project is the challenge of collecting and standardizing data from judicial proceedings processed in Rio Grande do Norte since 2015, whether digital or physical, stored in various electronic judicial systems, and ensuring that this information is correctly received and processed by the CNJ. The goal is to create a database following a dimensional model to input information from judicial processes, ensuring standardization and centralization of all processes in a single database. Additionally, this unified database aims to assist in the statistical analysis of the productivity of judicial units. The project will be developed using Pentaho Data Integration for the tasks of extraction, transformation, and loading of data, as well as PostgreSQL to host the database. The project stages include data collection from various sources, transformation according to DataJud standardization, and insertion of records into the unified database. At the end of development, the data will be ready to be sent to DataJud, after conversion to XML format and submission through the API provided by the CNJ.Attribution-NonCommercial-NoDerivs 3.0 Brazilhttp://creativecommons.org/licenses/by-nc-nd/3.0/br/DataJudCNJPentaho Data IntegrationBanco de dadosSistemas Judiciais EletrônicosDatabaseElectronic Judicial SystemsTJRNbachelorThesisCNPQ::CIENCIAS EXATAS E DA TERRA::CIENCIA DA COMPUTACAO::METODOLOGIA E TECNICAS DA COMPUTACAO::BANCO DE DADOS