https://sourceforge.net/projects/in2sql
Video for best usage https://rb.gy/tvl8lk
This Excel Addin helps SQL analytic create an Excel report based on ODBC relational data.
*Creates table base on data from a relational database
*Generate a pivot report using the same external connection (1)
*Some ad-hoc tools are available - like "keep only" and "remove only"
*you can use the row limit option for exploring the largest dataset
*The ODBC connection manager is available...
...JAETL allows to Extract data from ARFF (Weka), CSV, and SQL, Transform the data with join, replace missing values, remove duplicates, mapping filtering, variable selection, and Load the data into SQL server and export to CSV and ARFF.
Use JIRA's REST API to sync issues, worklogs, projects etc into SQL tables, enabling you to point your favourite BI tool at the data. I highly recommend Tableau (http://www.tableausoftware.com).