Integration Platform for Federal Financial Execution Structuring Systems

• Isaque Alves USP
• João Egewarth UnB
• Laila Bellix UnB
• Alex Reis UnB
• Carla Rocha UnB

DOI: https://doi.org/10.5753/lasdigov.2025.9140

Abstract

This paper presents an experience report on implementing an open-source platform for integrating data from Structuring Systems involved in federal budget execution (SIOP, SIAFI, SIAPE, TransfereGov, and ContratoGov). Given the challenges of promoting interoperability among systems managed by different agencies, a data-driven approach based on the Medallion architecture was adopted. The solution enables automated report generation, decentralized data governance, and the identification of requirements for future interoperability. As a result, it offers a scalable and reusable alternative with centralized data, documented APIs, and interactive dashboards, along with lessons learned on process improvement and enhanced public management.

References

Costa, L., Dutra, M. T., Oliveira, G., Silva, M., Soares, D. C., de Cássia Silva Faria, L., Jr., W. M., and Pappa, G. (2024). Ciência de dados e transparência: Experiências com dados públicos do sicom. In Anais Estendidos do XXXIX Simpósio Brasileiro de Bancos de Dados, pages 246–252, Porto Alegre, RS, Brasil. SBC.

da Silva Cristóvam, J. S., Saikali, L. B., and de Sousa, T. P. (2020). Governo digital na implementação de serviços públicos para a concretização de direitos sociais no brasil. Seqüência (Florianópolis), 43(89):209–242.

Data, M. C., Komorowski, M., Marshall, D. C., Salciccioli, J. D., and Crutain, Y. (2016). Exploratory data analysis. Secondary analysis of electronic health records, pages 185–203.

Dunleavy, P., Margetts, H., Bastow, S., and Tinkler, J. (2006). New public management is dead—long live digital-era governance. Journal of Public Administration Research and Theory, 16(3):467–494.

Gil-Garcia, J. R., Dawes, S. S., and Pardo, T. A. (2018). Digital government and public management research: Finding the crossroads. Public Management Review, 20(5):633–646.

Machado, I. A., Costa, C., and Santos, M. Y. (2022). Data mesh: concepts and principles of a paradigm shift in data architectures. Procedia Computer Science, 196:263–271.

Ministério do Planejamento (2010). Introdução ao siop – sistema integrado de planejamento e orçamento. Acesso em: 27 mar. 2025.

Nadal, S., Romero, O., Abelló, A., Vassiliadis, P., and Vansummeren, S. (2019). An integration-oriented ontology to govern evolution in big data ecosystems. Information systems, 79:3–19.

Russom, P. et al. (2017). Data lakes: Purposes, practices, patterns, and platforms. TDWI white paper.

Viana, A. C. A. (2021). Transformação digital na administração pública: do governo eletrônico ao governo digital. Revista Eurolatinoamericana de Derecho Administrativo, 8(1):115–136.