ODBC Plugin for Percona Community MySQL

[jambonum5]

I don’t know if anyone can advise anything around ODBC plugins with Percona MySQL.

I have tried three different ODBC connectors to try and join SPSS to data in a Percona DB server. Each plugin informs me that I require MySQL enterprise or Commercial for the plugin to work. This includes the Progress Direct Plugin seems to have this problem, this is confusing as SPSS state that this shouldn’t have a problem connecting to community versions of MySQL.

https://www.ibm.com/support/pages/data-direct-odbc-drivers-53-support-only-mysql-enterprise-edition

[vadimtk]

Did you try ODBC drivers from MySQL ?

https://dev.mysql.com/downloads/connector/odbc/

[jambonum5]

I think I have been working with some old information on IBM’s website, the ODBC driver was to match version 5 of mysql which is a little dated at this point.

Also, the sales person at DirectData said…

Our connector for MySQL only works with the enterprise edition … I don’t believe anyone can legally create a commercial connector for MySQL community because of limitations placed by Oracle. We only support MySQL community via our HDP product but if anyone is not willing to pay for a MySQL enterprise license, they probably won’t pay for the HDP license.

I think the next question is whether Percona can be upgraded to enterprise/commercial MySQL to allow ODBC? Or will the be more trouble from that beloved tech giant Oracle

[vadimtk]

@jambonum5
I am pretty sure that official MySQL drivers
https://dev.mysql.com/downloads/connector/odbc/
or MariaDB drivers
https://downloads.mariadb.org/connector-odbc/

will work with community version or Percona Server without restrictions.

[jambonum5]

I had tried installing the mysql-connector-odbc_8.0.22-1ubuntu18.04_amd64.deb package and it had complained about not finding the mysql-community-client-plugins package. I tried a few variations of apt-cache search mysql-community-client-plugins to locate this additional package but nothing came up.

I have gone through the following steps to install from the more generic unix files - MySQL :: MySQL Connector/ODBC Developer Guide :: 4.2.2 Installing Connector/ODBC from a Binary Tarball Distribution

The drivers appear present:
$ myodbc-installer -d -l
MySQL ODBC 8.0 Driver
MySQL ODBC 8.0

When I try and make a connection from SPSS, I get the following warning:

[jambonum5]

I’m going to look at a sanity check here to work out whether this is a problem with IBM’s/SPSS ODBC plugin. I’ll look to make an ODBC connection with some other software.

[jambonum5]

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