01.07.2012

How to parse JMeter logs and import it into database for further processing

Bellow two scripts which can help you to export JMeter logs into Oracle through sqlplus&sqlldr (it should be installed in your system)
With jtl_to_db_struct.sql you can create in Oracle two tables, "tests" - with information about tests iterations and "results" - with responses from jtl, and sequence "test_id_seq" for tests identification.
With jtltodb.py you can parse jtl into csv and load it into database, use Python 2.7+ for it.