Automation Process for the National Vulnerability Database

Objectives

1. Accept multiple file formats (e.g.: XML, JSON, CSV) but work only accepted JSON format data.
2. Extract the original JSON data into intended format based on the business needs.
3. Create tables and load the processed data into the data warehouse in a ready-to-load format for RDBMS.

Run Command

python3 nvd/scripts/vuln2db.py --json_file wrong_file.json nvdcve-1.1-2021.json wrong_file.txt

Prerequisite

Python==3.8.10
mysql-connector-python==8.0.31
typing-extensions==3.7.4.3