This definitely seems like an issue with IBM’s ODBC plugin for SPSS. I managed to make a simple script to connect and select data with the pyodbc module, no problems getting the data out.
I guess I need to query this with IBM some how.
Thanks for confirming ODBC for Percona is enabled and suggesting the MySQL driver