CSG International

CSG International

Year: 2018 Duration: 1 Month

SIEM Logs Project

A short project in CSG International, where I was responsible for creating a cron job in Spring Boot for reading and filtering logs from different databases, merging them and saving as files in different servers by SFTP.

A short project in CSG International, where I was responsible for creating a cron job in Spring Boot for reading and filtering logs from different databases, merging them and saving as files in different servers by SFTP. Log4j was the tool for the internal application logs, JDBC with Hiraki pool to establish connection with the database, triggering SQL queries. 

 

Spring Batch and @Scheduled annotation was the core to run and trigger the application, the most complex part of this application was the matching and merging of the tables from different databases, with large PL/SQL queries to merge the information. 

 

The deployment was simple, instead of being a war deployed in a servlet container or web server, it was simple a jar running as a process in unix systems.

Image-empty-state_edited_edited.jpg

Image-empty-state_edited_edited.jpg

Image-empty-state_edited_edited.jpg