open data. automated process. ETL. SUAP. CKAN. 

Public access to government information is an important aspect of modern society that allows the active participation of the population in monitoring government actions. Decree No. 8777, signed by the president on May 11, 2016, establishing the Open Data Policy of Brazilian’s Federal Government. From it, the entities of the federal public administration, autarchic and foundational are obliged to make the data available in the open format. However, so far, of the 210 institutions only 75 of them are fulfilling the commitments defined in the Decree. One possible explanation for this low number is the need for technical staff to have a good knowledge of their information systems and current legislation allied with the difficulty in extracting the data since in most of the institutions the entire process of extraction, treatment and publication of the open data is done manually. In this sense, this work proposes the development of an automation tool for the ETL process for open data in the scope of the Federal Institutions that use the Unified System of Public Administration since this automation brings a greater agility in the publication and periodic updating of the open data, time saving and ease of management of open data portals