The ODBC driver is probably my favorite WebTrends feature.  I still haven’t bothered to use REST because ODBC does everything I want.
With the ODBC driver I can create a 1 click report in Excel that I can distribute to anyone in my organization. They don’t have to log in, they don’t have to figure out [...]

Use this Excel macro to dump a workbook’s ODBC information into a spreadsheet, where you can edit queries and connection strings.