Software that integrates different data sources to a centralized one. Each data source stores information about software agents installed in the private network of computers. Examples of agents are anti-virus, intruder detection, remote access, and so on. A tool was built on top of the centralized data source that allows reporting and graphic generation. These show the status of the network in relation to the agents and allows proactive discovery of inconsistencies. Dimensional modeling, dynamic reporting, and ETL (Extraction, Transformation, and Load) techniques were applied. A huge database was built since the private network has more than 500 thousand computers and the ETL process is executed daily.

Share this project: