Muñoz Sanchez, Tatiana XimenaEspinoza Mejía, Jorge Mauricio2022-07-132022-07-132022978-303103883-91865-0929http://dspace.ucuenca.edu.ec/handle/123456789/39367https://www.scopus.com/record/display.uri?eid=2-s2.0-85128491309&origin=resultslist&sort=plf-f&src=s&st1=Proposal+of+a+Real+Time+Microservice+Architecture+Applied+to+Business+Intelligence+for+the+Financial+Sector&sid=e64e74e4fa150fa692439aa2b2679a71&sot=b&sdt=b&sl=122&s=TITLE-ABS-KEY%28Proposal+of+a+Real+Time+Microservice+Architecture+Applied+to+Business+Intelligence+for+the+Financial+Sector%29&relpos=0&citeCnt=0&searchTerm=&featureToggles=FEATURE_NEW_DOC_DETAILS_EXPORT:1This work proposes to i) generate a microservice, which allows the capture of massive transaction information from a relational database, ii) develop the extract, transform and load process (ETL), and iii) store proper and valuable information for decision-making in a non-relational database. The entire process also uses business intelligence mechanisms to convert data into information. Three phases were used for the implementation of this process: the first one, a mechanism within the relational database for change data capture (CDC)- Then, the second one, the design and implementation of a consumer in charge of listening to the messages, generate the transformation process and load it to the non-relational data-base, ensuring fault tolerance, reliability and scalability. Finally, through defined indicators, a control panel was designed, which offers operators and managers the necessary guidelines to generate decisions and measure the achievement of objectives and goals. The entire process, implemented through a visual and intuitive tool, allows converting the data into knowledge, which generates a competitive advantage in companies’ management and operational processes. The proposed integration, results in an architecture design that efficiently manages thousands of records in real-time, offering greater speed, performance, and optimization in searches of large volumes of data for effective decision-making. © 2022, Springer Nature Switzerland AG.es-ESMicroserviceBusiness intelligenceCDCETLIndicatorsNoSQLARTÍCULO DE CONFERENCIA10.1007/978-3-031-03884-6_33