My existing scans have huge CSV reports which excel cannot handle properly. Can we export the scan results to an external database like SQL Server or Oracle and then create Analytics such as list of all Windows 7 vulnerabilities in past month etc. Mainly excel has row limitation and limited analytics using Pivots and Charts. An enterprise database system can be more useful and I am thinking of integrating that database with a BI tool for analytics. How to proceed and is it possible?
And what is the scope of automation in this scenario.